How to upgrade mysql on Cpanel ?

i have mysql 5.5 installed on my cpanel  so i want to know how can i upgrade to 5.6 ?

Supporter Asked on February 13, 2017 in Software.
Add Comment
1 Answer(s)
Best answer

cpanel 11.42 and higher version support 5.6 so you can upgrade easily to 5.6 if you are upgrading from mysql 5.5 , you will not need to recompile php for it , however if you are upgrading from 5.4 or lower version then its better to upgrade first to 5.5 than 5.6 respectively.

so to upgrade to 5.6 first login to ssh
and then edit cpanel.config file for desire mysql version

nano /var/cpanel/cpanel.config
 

find string mysql-version=   and set it to 5.6 

save cpanel.config file and run

 /usr/local/cpanel/scripts/check_cpanel_rpms –fix
 

this will remove old version of mysql and will install mysql 5.6 and will also upgrade mysql database tables , so you do not need to run mysql_upgrade command

Supporter Answered on February 13, 2017.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.