mysql重启服务失败 很急,求解答

qq_38400484 2019-08-07 12:50:59
大佬们求解答,怎么解决这个问题, mysql重启服务失败


190807 00:27:54 mysqld_safe Starting mysqld daemon with databases from //www/server/mysql
/www/server/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist
190807 0:27:54 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
190807 0:27:54 InnoDB: Initializing buffer pool, size = 8.0M
190807 0:27:54 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
190807 0:27:54 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
190807 0:27:54 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
190807 0:27:54 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
190807 0:27:54 InnoDB: Started; log sequence number 0 0
190807 0:27:54 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
190807 00:27:54 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
...全文
300 2 打赏 收藏 转发到动态 举报
写回复
用AI写文章
2 条回复
切换为时间正序
请发表友善的回复…
发表回复
「已注销」 2019-08-17
  • 打赏
  • 举报
回复
你都打开日志了,就搜一下呗 https://www.cnblogs.com/already/p/5944803.html
TamoR. 2019-08-07
  • 打赏
  • 举报
回复
这个启动报错是因为你的默认配置文件/etc/my.cnf中的datadir的路径为默认路径,而不是你自己设置的路径导致的,修改一下应该就可以了。

56,679

社区成员

发帖
与我相关
我的任务
社区描述
MySQL相关内容讨论专区
社区管理员
  • MySQL
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧