service mysqld start 报错:service mysqld start 报错 090517_MySQL
程序员文章站
2022-06-12 22:27:23
...
service mysqld start报错
090517 13:34:15[ERROR]Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
090517 13:34:15
[ERROR]
Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist090517 13:34:15 mysqld_safe mysqld from pid file /usr/local/mysql/var/mail.bmitwap.com.pid ended
090517 13:38:35 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
解决办法:
在运行初始化权限表的时候使用增加参数--datadir,命令格式为:
shell>./scripts/mysql_install_db --user=mysql --datadir=/usr/local/mysql/data
这样问题就解决了。
推荐阅读
-
启动docker服务的时候报错:Failed to start docker.service: Unit docker.service is masked.
-
service docker start 报错 :Failed to start docker.se
-
service mysql start 报错总结
-
service docker start 报错
-
The nexus service was launched, but failed to start. --nexus启动报错完美解决
-
Mysql“service mysqld start”无法启动
-
centos启动rpcbind报错Job rpcbind.service/start failed with result 'dependency'
-
Linux启动某个服务报错:Failed to start xxx.service: Unit not found
-
Mysql systemctl start mysqld报错的问题解决
-
service mysqld start 报错:service mysqld start 报错 090517_MySQL