Previous Article Next Article MySQL 遇到 ERROR 1054 (42S22): Unknown column ‘plugin’ in ‘mysql.user’
Posted in Database

MySQL 遇到 ERROR 1054 (42S22): Unknown column ‘plugin’ in ‘mysql.user’

MySQL 遇到 ERROR 1054 (42S22): Unknown column ‘plugin’ in ‘mysql.user’ Posted on 2017 年 03 月 02 日Leave a comment

不能新建使用者

修正一下就可以了

mysql>use mysql;
mysql>ALTER TABLE user ADD Create_tablespace_priv ENUM('N','Y') NOT NULL DEFAULT 'N' AFTER Trigger_priv; 
mysql>ALTER TABLE user ADD plugin CHAR(64) NULL AFTER max_user_connections; 
mysql>ALTER TABLE user ADD authentication_string TEXT NULL DEFAULT NULL AFTER plugin; 
mysql>ALTER TABLE user ADD password_expired ENUM('N','Y') NOT NULL DEFAULT 'N' AFTER authentication_string;

發佈留言

發佈留言必須填寫的電子郵件地址不會公開。 必填欄位標示為 *