How to Update MySQLTuner in CWP Control Panel

Today we’ll update MySQLTuner in cwp centos web panel to latest possible version with this easy updating guide. Just follow the below steps and you’re running latest version. First a short introduction to MySQLTuner :

MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability. Running MySQL at optimal settings for specific resources helps handle larger server loads and prevents server slowdown.

To update Follow this easy steps :

STEP 1 :

Backup current cwp provided MySQLTuner :

Backup the files (backups will be in /root/mysqltunner/ :

rsync -av /usr/local/cwpsrv/htdocs/resources/conf/mysqltunner/ /root/mysqltunner/

after backing up Then remove the current files :

cd /usr/local/cwpsrv/htdocs/resources/conf/mysqltunner
rm -rf basic_passwords.txt mysqltuner.pl vulnerabilities.csv

Now we’ll download the updated version of MySQLTuner :

STEP 2 :

cd /usr/local/cwpsrv/htdocs/resources/conf/mysqltunner
wget --no-cache https://raw.githubusercontent.com/major/MySQLTuner-perl/master/mysqltuner.pl
wget --no-cache https://raw.githubusercontent.com/major/MySQLTuner-perl/master/vulnerabilities.csv
wget --no-cache https://raw.githubusercontent.com/major/MySQLTuner-perl/master/basic_passwords.txt

Done you’ve successfully updated MySQLTuner in CWP.

You can run this comamnd to run and check version of MySQLTuner :

perl /usr/local/cwpsrv/htdocs/resources/conf/mysqltunner/mysqltuner.pl