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