downmovies 发表于 2018-9-29 08:22:41

Mysql启报错报The server quit without updating PID file

  mysql 安装时候安装后启动不成功报错:
  Starting MySQL.. ERROR! The server quit without updating PID file (/data/mysql/26765574162f.pid).

  
  查看报错日志:
   Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist

  解决办法:
  1.编辑配置文件:
vim /etc/my.cnfbasedir = /usr/local/mysql  
datadir = /data/mysql
  
socket = /tmp/mysql.sock
  
log-error = /data/mysql/error.log
  
pid-file = /data/mysql/mysql.pid
  
user = mysql
  
tmpdir = /tmp
  2.重新初始化mysql:
./mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql --pid-file=/data/mysql/mysql.pid --tmpdir=/tmp  然后再启动就会成功了:



页: [1]
查看完整版本: Mysql启报错报The server quit without updating PID file