Can not startup mysql db

byran cheung · 06-19-2014, 10:21 PM

When I start mysql db , it pops the below error .

Code:

/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
[ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

then I tried to mysql_upgrade it , but got the following errors.

Code:

mysql_upgrade -uroot -p --force
Enter password: 
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck with default connection arguments
mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed

When I run mysql_upgrade , I found that them mysql.plugin is exist and upgraded.
mysql_upgrade -uroot -p --force

Code:

"
mysql.ndb_binlog_index                             OK
mysql.plugin                                       OK
mysql.proc                                         OK
"

It is strange that I sure the plugin db is exist , would advise what is the problem and how to fix it ? thanks

karim.ouda · 06-20-2014, 02:21 AM

Check the owner of mysql data directory, it should be mysql

Code:

sudo chown mysql:mysql /mysql/data/dir/path

If it does not solve the problem, one reason your my.cnf may be corrupted. Try to restore working my.cnf
Take the backup of my.cnf

Code:

cp /path/of/my.cnf /path/of/my.cnf.bk

Now copy it using by default back up

Code:

cp /path/of/my.cnf.rpmnew /path/of/my.cnf

You can find it in directory /etc or /etc/mysql according to your linux distribution.

byran cheung · 06-20-2014, 04:05 AM

Quote:

Originally Posted by karim.ouda

Check the owner of mysql data directory, it should be mysql

Code:

sudo chown mysql:mysql /mysql/data/dir/path

If it does not solve the problem, one reason your my.cnf may be corrupted. Try to restore working my.cnf
Take the backup of my.cnf

Code:

cp /path/of/my.cnf /path/of/my.cnf.bk

Now copy it using by default back up

Code:

cp /path/of/my.cnf.rpmnew /path/of/my.cnf

You can find it in directory /etc or /etc/mysql according to your linux distribution.

thanks reply,

all the file/directory are mysql:mysql , it should be not related to my problem

karim.ouda · 06-26-2014, 08:18 AM

I hope the data directory is in /var/lib/mysql. Run

Code:

mysql_install_db --user=mysql --ldata=/var/lib/mysql/

and now try to start mysql again.
For more details, read
https://dev.mysql.com/doc/refman/5.0...nstall-db.html