安装完mysql后,执行 [b][color=blue]mysqld_safe --user=mysql &[/color][/b] 命令报以下错误:
# [b][color=blue]/usr/local/mysql/bin/mysqld_safe --user=mysql&[/color][/b]
[1] 3527
# 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.
[b][color=blue]解决办法:[/color][/b]
/usr/local/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist
问题应该出在这里!重新初始化下数据库看下能否解决问题!
# /usr/local/mysql/bin/mysql_install_db --user=mysql
问题已解决!
# [b][color=blue]/usr/local/mysql/bin/mysqld_safe --user=mysql&[/color][/b]
[1] 3527
# 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.
[b][color=blue]解决办法:[/color][/b]
/usr/local/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist
问题应该出在这里!重新初始化下数据库看下能否解决问题!
# /usr/local/mysql/bin/mysql_install_db --user=mysql
问题已解决!