MySQL Daemon Cannot Start


Quary
MySQL Daemon Cannot Start

Check Permissions of Files in /var/lib/mysql & /var/lib/mysql/mysql
chown mysql:mysql /var/lib/mysql -R

Configuration File my.cnf Should Copied to /etc/
cp /etc/mysql/my.cnf /etc/my.cnf

Start MySQL Daemon If You are Getting Error
[ERROR] Can’t start server : Bind on unix socket: Permission denied
[ERROR] Do you already have another mysqld server running on socket: /var/run/mysqld/mysqld.sock ?
[ERROR] Aborting

Permissions Of /var/run/mysqld
chown mysql:mysql /var/run/mysqld -R

Start MySQL Service If you Getting Errors
Fatal error: Can’t open and lock privilege tables: Table ‘mysql.host’ doesn’t exist

Install Default Tables From /usr
cd /usr
mysql_install_db –user=mysql –ldata=/var/lib/mysql/

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s