You must first take backup all your databases. In my case it was a fresh vps install and i needed 5.6 to make the vTiger 6.4.0 work (It was transfer from other server).
1.) Through SSH
then
and put a line
save and quit :wq
2.) Through SSH
You must enable and disable the version of MySQL
See what rpm do you have installed and erase them (or else they will confict the installation)
Example
3.) Through WHM
Upgrade to Latest Version/Force a reinstall even if the system is up to date.
4.) Through SSH
Remove them and reinstall them beacause is not the latest 5.6.43 (in my case WHM installed the 5.6.41)
5.) Through WHM
Home »SQL Services »MySQL Root Password »Add new password
Home »Account Functions »Password Modification »Add new password to the cPanel Account
6.) Through SSH
1.) Through SSH
Code:
mkdir -p /root/cpanel_profile/
Code:
vi /root/cpanel_profile/cpanel.config
Code:
mysql-version=5.6
2.) Through SSH
Code:
sudo yum-config-manager --disable mysql57-community
sudo yum-config-manager --enable mysql56-community
See what rpm do you have installed and erase them (or else they will confict the installation)
Code:
rpm -qa|grep mysql
Code:
sudo yum erase package mysql-community-common-5.7.25-1.el7.x86_64
Upgrade to Latest Version/Force a reinstall even if the system is up to date.
4.) Through SSH
Remove them and reinstall them beacause is not the latest 5.6.43 (in my case WHM installed the 5.6.41)
Code:
yum remove mysql mysql-server
mv /var/lib/mysql /var/lib/mysql_old_backup
yum install mysql mysql-server
Home »SQL Services »MySQL Root Password »Add new password
Home »Account Functions »Password Modification »Add new password to the cPanel Account
6.) Through SSH
Code:
service cpanel restart
service mysql restart
Last edited by a moderator: