CONTACT US: 1-800-622-4403
Domains To Datacenter Since 1994

Upgrade MySQL to 5.6 on Plesk VPS

Login to your VPS via terminal.

Commands in order
wget && sudo rpm -ivh mysql-community-release-el6-5.noarch.rpm
yum -y upgrade mysql-server
service mysqld restart
mysql_upgrade -uadmin -p`cat /etc/psa/.psa.shadow`
vi /etc/odbcinst.ini
#change the following: /usr/lib64/ to /usr/lib64/
ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
service mysqld restart
(to check if the sock exists)
ls -ld /tmp/mysql.sock  
# if not, you’ll get: ls: cannot access /tmp/mysql.sock: No such file or directory
Do the command again:
ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock 

Feedback and Knowledge Base