MySQL 5.5.11 Possible Errors During Installation

I’ve compiled this list of errors that I’ve been running into during the installation of MySQL. Here’s the process that I’ve been figuring out, the results have become a tutorial, Installation MySQL 5.5.11.

Can’t start server: Bind on TCP/IP port: Address already in use

Do you already have another mysqld server running on port: 3306 ?.. Aborting. Is an error that I received during this installation process.

To fix this error I use the Killing Processes procedure to stop the instance of mysqld that was arleady running.

mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

It seems that the pid file isn’t being created. This file only contains the process number for the OS. Otherwise its an empty file. Possible causes of this happening are 80% of the time lead back to your my.cnf variables. The other 20% are caused by file or folder permissions.

Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)

Normally this is caused by a bad variable in your /etc/my.cnf file. Once you fix your my.cnf file then restart mysql using this command.

$ /usr/local/mysql/bin/mysqld_safe --user=mysql