Server IP : 51.222.206.218 / Your IP :
18.188.93.255 [Reverse IP] Web Server : Apache System : Linux srv3.mexxus.com 4.18.0-553.8.1.el8_10.x86_64 #1 SMP Tue Jul 2 07:26:33 EDT 2024 x86_64 User : ottavioc ( 1004) PHP Version : 8.1.32 Disable Function : exec,passthru,shell_exec,system Domains : 3 Domains MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /scripts/
#!/usr/local/cpanel/3rdparty/bin/perl
# cpanel - scripts/killmysqlwildcard Copyright 2022 cPanel, L.L.C.
# All rights reserved.
# copyright@cpanel.net http://cpanel.net
# This code is subject to the cPanel license. Unauthorized copying is prohibited
use strict;
use warnings;
use Cpanel::Config::Users ();
use Cpanel::MysqlUtils::Connect ();
use Cpanel::MysqlUtils::Quote ();
use Cpanel::Logger ();
use Cpanel::DB::Utils ();
my $logger = Cpanel::Logger->new();
my @cpusers = Cpanel::Config::Users::getcpusers();
my $dbh;
if ( my $obj = eval { Cpanel::MysqlUtils::Connect->new() } ) {
$dbh = $obj->db_handle();
}
else {
die "Failed to connect to MySQL: $@";
}
foreach my $cpuser (@cpusers) {
my $dbowner_name = Cpanel::DB::Utils::username_to_dbowner($cpuser);
my $safe_name = Cpanel::MysqlUtils::Quote::quote("$dbowner_name\\_%");
$logger->info("Removing mysql wildcard grant from $cpuser");
$dbh->do("DELETE FROM mysql.db WHERE db = $safe_name;");
}
$dbh->do('FLUSH PRIVILEGES;');
$dbh->disconnect();