List all cPanel users having Wildcard Remote Mysql Access
Remote MySQL option in cPanel allows other webservers to access the MySQL database on your server remotely.
Remote MySQL option can be very handy, if you want to allow applications like shopping carts or guestbooks on your other servers to access the databases.
But on the contrary, if the Remote MySQL option is not handled with care then it can lead to database hacks.
So, If you want to find out all cPanel users having Wildcard Access enabled then you can use the below simple command :
[code]root@server[#]mysql -N mysql -e “Select User from user where Host=’%'” | awk -F _ ‘{print $1}’ | uniq[/code]
Because of Bug in the CPanel release lots of our client are facing issue that MySQL is showing down in cPanel interface. But the MySQL/MariaDB was still running. It’s only the cPanel interface that was showing the error. And cPanel error logs were being populated with below string. Invalid grant…
Error The MySQL server is currently offline. Error while connecting to MySQL: #28000Access denied for user 'root'@'localhost' (using password: YES) Go to WHM > Service Manager and uncheck monitor for MySQL (so it doesn't restart while fixing the issue), then save the area 2. Stop MySQL in root SSH (if…
Backup existing MySQL data Make sure to save all existing data just in case there are any issues. # cp -Rf /var/lib/mysql /var/lib/mysql-old # mv /etc/my.cnf /etc/my.cnf-old Disable the targets so cPanel no longer handles MySQL updates The following will mark the versions of MySQL we distribute as uninstalled so they are…
