首页 > Mysql数据库 > 安装mysql 出现:Fatal error: Can’t open and lock privilege tables: Table ‘mysql.user’ doesn’t exist

安装mysql 出现:Fatal error: Can’t open and lock privilege tables: Table ‘mysql.user’ doesn’t exist

2017年2月3日

安装mysql 出现:Fatal error: Can’t open and lock privilege tables: Table ‘mysql.user’ doesn’t exist
来源:http://blog.csdn.net/dapeng0112/article/details/37053407

本来初始化配置是这样的:

scripts/mysql_install_db –basedir=/usr/local/mysql –datadir=/usr/local/mysql/data –user=mysql

出现了

[[email protected] mysql-5.6.14]# service mysql restart
ERROR! MySQL server PID file could not be found!
Starting MySQL. ERROR! The server quit without updating PID file (/var/lib/mysql/localhost.localdomain.pid).

在日志中出现了如下错误:

Can’t open and lock privilege tables: Table ‘mysql.user’ doesn’t exist

后来采用了下面的语句就可以了:

scripts/mysql_install_db –basedir=/usr/local/mysql –datadir=/usr/local/mysql/data –user=mysql –ldata=/var/lib/mysql

分类: Mysql数据库 标签:
本文的评论功能被关闭了.