`

启动mysql时报错: mysqld_safe Logging to '/usr/local/mysql/data/zrf.err'.

阅读更多
安装完mysql后,执行 mysqld_safe --user=mysql & 命令报以下错误:

[root@zrf ~]# /usr/local/mysql/bin/mysqld_safe --user=mysql&
[1] 3527
[root@zrf ~]# 101021 16:37:39 mysqld_safe Logging to '/usr/local/mysql/data/zrf.err'.
101021 16:37:39 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
101021 16:37:39 mysqld_safe mysqld from pid file /usr/local/mysql/data/zrf.pid ended


查看 zrf.err 日志文件,其信息为:
/usr/local/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist
101021 16:37:39 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
101021 16:37:39 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
101021 16:37:39 mysqld_safe mysqld from pid file /usr/local/mysql/data/zrf.pid ended
101021 16:41:17 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
101021 16:41:17 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--sk
ip-external-locking' instead.


解决办法:

/usr/local/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist

问题应该出在这里!重新初始化下数据库看下能否解决问题!
# /usr/local/mysql/bin/mysql_install_db --user=mysql

问题已解决!
















分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics