Home > Database > Mysql Tutorial > 安装mysql 出现:Fatal error: Can't open and lock_MySQL

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

WBOY
Release: 2016-05-31 08:48:30
Original
1072 people have browsed it

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

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

source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template