Ubuntu Server Cookbook

Troubleshooting MySQL

In this recipe, we will look at some common problems with MySQL and learn how to solve them.

Getting ready

You will need access to a root account or an account with sudo privileges.

You will need administrative privileges on the MySQL server.

How to do it…

Follow these steps to troubleshoot MySQL:

1. First, check if the MySQL server is running and listening for connections on the configured port:

   $ sudo service mysql status
   $ sudo netstat -pltn
   

2. Check MySQL logs for any error messages at /var/log/mysql.log and mysql.err.
3. You can try to start the server in interactive mode with the verbose flag set:

   $ which mysqld
   /usr/sbin/mysqld
   $ sudo /usr/sbin/mysqld --user=mysql --verbose
   

4. If you are accessing MySQL from a remote system, make sure ...