首頁 >資料庫 >mysql教程 >安装mysql 出现:Fatal error: Can't open and lock_MySQL

安装mysql 出现:Fatal error: Can't open and lock_MySQL

WBOY
WBOY原創
2016-05-31 08:48:301068瀏覽

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

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

出现了

[root@localhost 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

陳述:
本文內容由網友自願投稿,版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容,請聯絡admin@php.cn