jingshen 发表于 2018-10-6 08:18:42

启动mysql报错:ERROR! The server quit without updating

  启动mysql报错:ERROR! The server quit without updating PID file (/data/mysql/localhost.localdomain.pid),查看mysql.log发现报错信息:
   Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
  解决方案:
  scripts/mysql_install_db--user=mysql --datadir=/data/mysql
  之前写成:scripts/mysql_install_db--user=mysql --datadir=/data/mysql basedir=/usr/local/mysql
  需要去掉basedir=/usr/local/mysql才行
  另外需要再/etc/my.cnf加上datadir=/data/mysql

页: [1]
查看完整版本: 启动mysql报错:ERROR! The server quit without updating