CONTACT US: 1-800-622-4403
ABOUT    CONTACT SALES    SERVICE AREAS
Domains To Datacenter Since 1994

Upgrade MySQL to 5.6 on Plesk VPS

Login to your VPS via terminal.

Commands in order
-----------------
wget http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm && 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/libmyodbc5.so to /usr/lib64/libmyodbc5a.so
 
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