之前把其它服务器的mysql 数据文件拷到本地,覆盖了本地的数据,
服务器上的mysql 版本 如下:
mysql> select @@version;
+-----------+
| @@version |
+-----------+
| 5.1.73 |
+-----------+
1 row in set (0.00 sec)
本地上的mysql 版本:
mysql> select @@version;
+-----------+
| @@version |
+-----------+
| 5.6.28 |
+-----------+
1 row in set (0.00 sec)
----------------
由于两个版本不一样 mysql.user 表的结构不一样,地板本的mysql.user 没有 plugin 等字段,因此,只要按照如下命令在高版本的mysql.user 表加入 这些列就行。
----------------------------------------
mysql> create user test ;
ERROR 1054 (42S22): Unknown column 'plugin' in 'mysql.user'
解决办法:
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;
再创建用户就成功了
mysql> create user jack identified by 'jack';
Query OK, 0 rows affected (0.00 sec)
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mysql -u jacklin -p # login mysql
drop table juser_user;
create table juser_user(id char(20),name char(20),password char(40) );
create user jack identified by 'jack';
grant all on jumpserver.* to 'jacklin'; # DB : jumpserver , username: jacklin
服务器上的mysql 版本 如下:
mysql> select @@version;
+-----------+
| @@version |
+-----------+
| 5.1.73 |
+-----------+
1 row in set (0.00 sec)
本地上的mysql 版本:
mysql> select @@version;
+-----------+
| @@version |
+-----------+
| 5.6.28 |
+-----------+
1 row in set (0.00 sec)
----------------
由于两个版本不一样 mysql.user 表的结构不一样,地板本的mysql.user 没有 plugin 等字段,因此,只要按照如下命令在高版本的mysql.user 表加入 这些列就行。
----------------------------------------
mysql> create user test ;
ERROR 1054 (42S22): Unknown column 'plugin' in 'mysql.user'
解决办法:
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;
再创建用户就成功了
mysql> create user jack identified by 'jack';
Query OK, 0 rows affected (0.00 sec)
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mysql -u jacklin -p # login mysql
drop table juser_user;
create table juser_user(id char(20),name char(20),password char(40) );
create user jack identified by 'jack';
grant all on jumpserver.* to 'jacklin'; # DB : jumpserver , username: jacklin