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 no longer maintained by cPanel/WHM /scripts/update_local_rpm_versions –edit…
Category: MySql
mysql is disabled by sys admin while restarting mysql service
Sometimes it may happen that while restarting mysql service on server you are getting below error. mysql is disabled by sys admin Try running below script to bring mysql up again /scripts/mysqlup If it’s Up then ok, but sometime it will give below error Updates for mysql /etc/mysql disabled If it is not working then…
IP remove from Brute Force Attack database by SSH
Sometimes, because of the Brute Force Attack we are unable to login to WHM if we are using correct details also. Then at that time try using below method. Login to server via SSH. Connect with mysql database using mysql command. It will show below output. [email protected] [/var/log]# mysql Welcome to the MySQL monitor….
How to Uninstall MySQL Governor
How to Uninstall MySQL Governor Run the below commands to uninstall MySQL Governor /usr/share/lve/dbgovernor/install-mysql.py –delete yum erase db-governor db-governor-mysql
Upgrading MySQL Governor on CPanel, Plesk and DirectAdmin server
Upgrading MySQL Governor on CPanel, Plesk and DirectAdmin server Run the below command to update MySQL Governor yum update db-governor db-governor-mysql –enablerepo=cloudlinux-updates-testing Run the below command to restart the service service db_governor restart
MySQL Governor installation in without control panel server
MySQL Governor installation in without control panel server Run the below command to install MySQL Governor in plain server or without control panel server. yum install db-governor –enablerepo=cloudlinux-updates-testing yum update mysql-server mysql-devel mysql –enablerepo=cloudlinux-updates-testing Add the below line in my.cnf with root password [dbgovernor] Run the below command to start. service db_governor restart
How to install MySQL Governor on CPanel, Plesk and DirectAdmin
How to install MySQL Governor on CPanel, Plesk and DirectAdmin MySQL governor is set of utilities to monitor and restrict MySQL usage in shared hosting environment. The monitoring is done via USER_STATISTICS table that is available in CloudLinux version of MySQL as well as via tracking of slow queries. To install MySQL governor on cPanel server…
Mysql manager of pid file quit without updating file
Mysql manager of pid file quit without updating file While Starting Mysql service getting the below error message. Mysql manager of pid file quit without updating file This problem occurs because mysql database crashed. To repair mysql database use the below command. cd /var/lib/mysql/ myisamchk -r *.MYI Then run the below command ps aux |…
How to enable mysql query cache
How to enable mysql query cache Please note that i am enabling the mysql query caching limit to 20MB. I have converted the 20MB to 20971520KB Login to the server via SSH. Type “mysql” command It will show the below output. [email protected] [~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g….
How to install WatchMySQL Plugin in WHM
How to install WatchMySQL Plugin in WHM Installation Go to the below path cd /sbin Remove the file or take the backup rm -f watchmysql Download watchmysql plugin using the below link wget http://www.ndchost.com/cpanel-whm/scripts/watchmysql/download.php Change the ownership of that file chown root.root watchmysql Change permission of the file. chmod 0750 watchmysql Configuration Before you…