1. Check the MySQL version
root# mysql -e "select version();";
+------------+
| version() |
+------------+
| 5.5.32-cll |
+------------+
Now replace the 5.5 MySQl version with 5.1 in “/var/cpanel/cpanel.config”
root# sed -i 's/mysql-version=5.5/mysql-version=5.1/g' /var/cpanel/cpanel.config
Execute the script “/scripts/check_cpanel_rpms –fix”
Note : You will see “Error : Unknown table engine ‘PERFORMANCE_SCHEMA’” that is because 5.1 don’t have this table engine.
When the script completed the execution, check the version.
root# mysql -e "select version();";
+------------+
| version() |
+------------+
| 5.1.70-cll |
+------------+
See! It’s downgraded to 5.1.
Regards,
Vinod T K
