1. XenForo 1.5.14 中文版——支持中文搜索!现已发布!查看详情
  2. Xenforo 爱好者讨论群:215909318 XenForo专区

解决:Can't open the mysql.plugin table.

Discussion in '应用交流' started by admin, 2014-11-27.

  1. admin

    admin 管理员 Staff Member

    Joined:
    2011-11-01
    Messages:
    3,671
    Likes Received:
    2,425
    解决:[ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
    mysql初始化结束
    Code:
    bin/mysql_install_db --user=mysql  &
    启动报错
    Code:
    121122 21:36:50 mysqld_safe Starting mysqld daemon with databases from /opt/mysql/data
    121122 21:36:50 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
    /opt/mysql/libexec/mysqld: Table 'mysql.plugin' doesn't exist
    121122 21:36:50 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
    121122 21:36:50 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
    121122 21:36:50 mysqld_safe mysqld from pid file /opt/mysql/data/Client.pid ended
    解决:
    重新初始化:
    Code:
    bin/mysql_install_db --user=mysql --datadir=/opt/mysql/data/
     
Loading...