MySQL(Linux)用户管理之总结

最新推荐文章于 2024-09-12 12:42:46 发布

ITRunner

最新推荐文章于 2024-09-12 12:42:46 发布

阅读量1.5k

点赞数

分类专栏： DB数据库(MySQL) 文章标签： mysql linux server 文档 command shell

本文链接：https://blog.csdn.net/ITRunner/article/details/453208

版权

DB数据库(MySQL) 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

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';

17:01 2005-8-11