错误1396 (HY000):为'jack'@'localhost'创建用户操作失败

我似乎无法重新创建一个我已经删除的简单用户，即使是MySQL的根用户。

我的案例:用户'jack'之前存在，但我从mysql中删除了它。用户才能重新创建它。我在那张桌子上没看到这东西的痕迹。如果我对其他一些随机用户名执行这个命令，比如'jimmy'，它就能正常工作(就像它最初对'jack'所做的那样)。

我做了什么破坏用户'jack'，我如何撤销这个破坏，以重新创建'jack'作为MySQL安装的有效用户?

参见下面的示例。(当然，最初，jack这个词从被创造到被移除之间有很长一段时间。)

mysql> CREATE USER 'jack'@'localhost' IDENTIFIED BY 'test123';
Query OK, 0 rows affected (0.00 sec)

mysql> select user,host from user;
+------------------+-----------------+
| user             | host            |
+------------------+-----------------+
| root             | 127.0.0.1       |
| debian-sys-maint | localhost       |
| jack             | localhost       |
| root             | localhost       |
| root             | russ-elite-book |
+------------------+-----------------+
5 rows in set (0.00 sec)

mysql> delete from user where user = 'jack';
Query OK, 1 row affected (0.00 sec)

mysql> select user,host from user;
+------------------+-----------------+
| user             | host            |
+------------------+-----------------+
| root             | 127.0.0.1       |
| debian-sys-maint | localhost       |
| root             | localhost       |
| root             | russ-elite-book |
+------------------+-----------------+
4 rows in set (0.00 sec)

mysql> CREATE USER 'jack'@'localhost' IDENTIFIED BY 'test123';
ERROR 1396 (HY000): Operation CREATE USER failed for 'jack'@'localhost'
mysql> CREATE USER 'jimmy'@'localhost' IDENTIFIED BY 'test123';
Query OK, 0 rows affected (0.00 sec)

mysql> select user,host from user;
+------------------+-----------------+
| user             | host            |
+------------------+-----------------+
| root             | 127.0.0.1       |
| debian-sys-maint | localhost       |
| jimmy            | localhost       |
| root             | localhost       |
| root             | russ-elite-book |
+------------------+-----------------+
5 rows in set (0.00 sec)

当前回答

步骤1)打开MySQL命令行客户端。

步骤2:select user, host from mysql.user;

步骤3)删除用户:drop user username@localhost;

步骤4)再次使用MySQL GUI创建用户。

步骤5)现在问题解决了。

2022-04-25 12:26:26

其他回答

在MySQL 5.6中使用Drop user userid;不管用。使用方法:删除用户userid @ localhost;和/或删除用户'userid'@'%';通过这种方式，我可以删除用户并重新创建它。

2017-06-18 10:33:17

尝试删除mysql.db where user = 'jack'然后创建一个用户

2011-04-05 16:46:05

删除用户，刷新权限;然后，创建用户。它确实有效!

2012-03-15 10:19:32

mysql> DELETE FROM mysql.db WHERE user = 'jack'

重启服务器:

# mysql。服务器重启

然后执行CREATE USER命令。

2018-03-22 21:09:05

我今天遇到了这个问题，我通过以下步骤解决了它:

1)手动在mysql.user中插入麻烦的用户提供的必填字段值

mysql> insert into user(Host, User, Password, ssl_type) 
   values ('localhost', 'jack', 'jack', 'ANY');

mysql> select * from user where User = 'jack';
   1 row in set (0.00 sec)

3)。

mysql> drop user jack;
Query OK, 0 rows affected (0.00 sec)

B. mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

C. mysql> create user 'jack' identified by 'jack';
Query OK, 0 rows affected (0.00 sec)

D. mysql> select Host, User, Password, ssl_type  from user where User = 'jack';
+-----------+-----------+-------------------------------------------+----------+
| Host      | User      | Password                                  | ssl_type |
+-----------+-----------+-------------------------------------------+----------+
| localhost | jack      | jack                                      | ANY      |
| %         | jack      | *45BB7035F11303D8F09B2877A00D2510DCE4D758 |          |
+-----------+-----------+-------------------------------------------+----------+
2 rows in set (0.00 sec)

4)。

mysql> delete from user 
 where User = 'nyse_user' and 
       Host = 'localhost' and 
       Password ='nyse';
Query OK, 1 row affected (0.00 sec)

mysql> select Host, User, Password, ssl_type  from user where User = 'jack';
+------+-----------+-------------------------------------------+----------+
| Host | User      | Password                                  | ssl_type |
+------+-----------+-------------------------------------------+----------+
| %    | jack      | *45BB7035F11303D8F09B2877A00D2510DCE4D758 |          |
+------+-----------+-------------------------------------------+----------+
1 row in set (0.00 sec)

希望这能有所帮助。

2020-04-12 23:54:17

错误1396 (HY000):为'jack'@'localhost'创建用户操作失败

推荐文章

最新文章

标签