MySQL(Linux) 用户管理之总结

用 root 登录（仅限本地）

[root@np3 bin]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 344 to server version: 4.1.10a-standard

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

mysql〉　

增加或修改用户权限---本地

mysql〉GRANT all on *.* to globus@’localhost’ identified by “123456“;

增加或修改用户权限---远程

mysql〉GRANT all on *.* to globus@’%’ identified by “123456“;

关键是此句中的%号要加’ ’,否则说语法错误，这是4.1.1的新规则。害的我到www.mysql.com上找了文档看了一下。

下面是官方的文档

shell〉mysql --user=root mysql

If you have assigned a password to the root account, you’ll also need to supply a --password or -p option for this mysql command and also for those later in this section.

After connecting to the server as root, you can add new accounts. The following statements use GRANT to set up four new accounts:

mysql〉 GRANT ALL PRIVILEGES ON *.* TO ’monty’@’localhost’

-〉IDENTIFIED BY ’some_pass’ WITH GRANT OPTION;

mysql〉GRANT ALL PRIVILEGES ON *.* TO ’monty’@’%’

-〉IDENTIFIED BY ’some_pass’ WITH GRANT OPTION;

mysql〉GRANT RELOAD,PROCESS ON *.* TO ’admin’@’localhost’;

mysql〉GRANT USAGE ON *.* TO ’dummy’@’localhost’;