重装了mysql后,用下面的命令一直不能启动。
/etc/init.d/mysql start
查看/var/lib/mysql/NC-VM-PL-DEV-40.err
发现错误显示如下:
[ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
于是运行下面的命令:
mysql_install_db --user=mysql --ldata=/var/lib/mysql
之后就OK了。
#/etc/init.d/mysql start
Starting MySQL. [ OK ]
refer:
http://will-bloggs-too.com/2011/11/29/mysql-error-cant-open-and-lock-privilege-tables-table-doesnt-exist/
转载于:https://blog.51cto.com/leander/1284071