MySQL的Grant命令

我安装的版本：

MySQL> select version();
+————+
| version()   |
+————+
| 5.0.22-log |
+————+
1 row in set (0.05 sec)

添加用户：

mysql> grant select,update,insert,delete on *.* to jimmy@AS3 identified by “jimmy”;
Query OK, 0 rows affected (0.00 sec)

mysql> select host,user,password from user;
+———–+——–+——————————————-+
| host       | user    | password                                   |
+———–+——–+——————————————-+
| localhost | root    |                                            |
| AS3        | root    |                                            |
| AS3        |         |                                            |
| localhost |         |                                            |
| AS3        | yuanjl | 550185cd02026208                           |
| localhost | yuanjl | 550185cd02026208                           |
| AS3        | jimmy   | *1E7F320B8F580AADC02E8A70285E46A8CFDA3359 |
+———–+——–+——————————————-+
7 rows in set (0.00 sec)

mysql> quit
Bye
[root@AS3 mysql-5.0.22]# mysql -pjimmy -u jimmy -h AS3 mysql
ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client
[root@AS3 mysql-5.0.22]# mysql -u root -h AS3 mysql
Welcome to the MySQL monitor.   Commands end with ; or /g.
Your MySQL connection id is 36 to server version: 5.0.22-log

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

mysql> update user set password=old_password(‘jimmy’) where user=’jimmy’ and host=’AS3′;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1   Changed: 1   Warnings: 0

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

mysql> quit
Bye
[root@AS3 mysql-5.0.22]# mysql -pjimmy -u jimmy -h AS3 mysql
Welcome to the MySQL monitor.   Commands end with ; or /g.
Your MySQL connection id is 37 to server version: 5.0.22-log

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

mysql>