Category: MySql

Control Panel, CPanel / WHM, Installation, MySql

How to replace MySQL with MariaDB in cpanel

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 ...

CPanel / WHM, 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 ...

CPanel / WHM, MySql

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. ...

Cloud Linux, CPanel / WHM, MySql, Plesk, Security, WHM Plugins

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  

Cloud Linux, Control Panel, Installation, MySql, Uncategorized

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

Cloud Linux, CPanel / WHM, Installation, MySql, Plesk, Security, WHM Plugins

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

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 | ...

MySql

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. ...

CPanel / WHM, MySql, WHM Plugins

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 ...