欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

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 exist

090517 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

这样问题就解决了。