After querying the log is ' Fatal Error:can ' t open and Lock Privilege tables:table ' mysql.host ' doesn ' t exist ' this error (Less/var/log/mysqld.log)
Try to remove all of the MySQL clean, generally delete dirty (after deletion of residual configuration file my.cnf) The total removal method is as follows
[Email protected] lib]# Rpm-qa¦grep mysqlmysql-5.5.25-1.el6.remi.i686mysql-libs-5.5.25-1.el6.remi.i686compat-mysql51-5.1.54-1.el6.remi.i686mysql-server-5.5.2 5-1.el6.remi.i686[[email protected] lib]# yum remove MySQL mysql-server mysql-libs compat-mysql51 (delete all)
This is completely unloaded, and then reloading will get a new MySQL.
Or not?
http://blog.csdn.net/indexman/article/details/16980433 (see this article for resolution)
The contents are as follows:
Today after installing MySQL, boot time did not start successfully, check the following log error as follows:
---------------------------------------------
[Email protected] local]# Less/var/log/mysqld.log
1. Check the error message as follows:
[ERROR] Fatal Error:can ' t open and Lock Privilege tables:table ' mysql.host ' doesn ' t exist
2, after access to information learned. To hit the following command to resolve:
Mysql_install_db–usrer=mysql Datadir=/var/lib/mysql
DataDir is my MySQL storage file directory
3. Then restart MySQL or not:
MySQL Daemon failed to start.
Starting mysqld: [Failed]
4, and then tried the next separate command, start to complete
mysql_install_db
5. Start the MySQL service
[Email protected] mysqld]#/etc/init.d/mysqld restart
Stop mysqld: [OK]
Starting mysqld: [OK]
------------------------
Dylan Presents
MySQL doesn't start up.