Error #1

Solution: If you’re getting the above error while starting mysql, check the mysql error log by using the following command:

Here you can see the reason. Issue maybe due to the presence of incorrect variables existing in ‘/etc/my.cnf’.

Error #2

Solution: Make sure that /var/lib/mysql/mysql.sock is existing. Also, confirm the presence of /tmp/mysql.sock. If it’s not existing, create it:

Then restart mysql.

Error #3

Solution: Open port 3306 in server firewall. If iptables is the firewall, use the following command:

Error #4

When Plesk login page return some errors

Solution: Disable ‘skip-bdb’ in /etc/my.cnf and then restart mysql.

Error #5

Solution: If you’re getting the above error while executing ‘mysqlcheck’, try to repair the table manually.

If the issue is not solved, try the following command:

It will fix the issue.

One of the most misleading errors generated by MySql is shown below:-

In this case, you need to adjust both ‘sort_buffer_size’ and ‘myisam_sort_buffer_size’.