MYSQL：使用UPDATE修改用戶名，無法登錄的問題

1、創建一個用戶test/test

[sql]

mysql> create user test identified by 'test';

Query OK, 0 rows affected (0.00 sec)

mysql> exit

Bye

2、使用test/test用戶登錄成功

[sql]

C:/Users/qxl>mysql -utest -ptest

Welcome to the MySQL monitor. Commands end with ; or /g.

Your MySQL connection id is 25

Server version: 5.1.28-rc-community MySQL Community Server (GPL)

Type 'help;' or '/h' for help. Type '/c' to clear the buffer.

mysql> exit

Bye

3、使用root用戶登錄，修改test用戶名為newuser

[sql]

C:/Users/qxl>mysql -uroot -p

Enter password: ****

Welcome to the MySQL monitor. Commands end with ; or /g.

Your MySQL connection id is 27

Server version: 5.1.28-rc-community MySQL Community Server (GPL)

Type 'help;' or '/h' for help. Type '/c' to clear the buffer.

mysql> update mysql.user set user='newuser' where user='test';

Query OK, 1 row affected (0.00 sec)

Rows matched: 1 Changed: 1 Warnings: 0

mysql> exit

Bye

4、使用newuser/test登錄失敗

[sql]

C:/Users/qxl>mysql -unewuser -ptest

ERROR 1045 (28000): Access denied for user 'newuser'@'localhost' (using password: YES)

聲明：本網頁內容旨在傳播知識，若有侵權等問題請及時與本網聯系，我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com