本文介绍了一个MySQL实例中用户的权限管理操作，包括查看当前系统中已有的用户及其权限，并演示了如何为root用户授予所有数据库的所有权限。
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> SELECT User, Password, Host FROM user;
+------+----------+-----------+
| User | Password | Host |
+------+----------+-----------+
| root | | localhost |
| root | | m00 |
| root | | 127.0.0.1 |
| | | localhost |
| | | m00 |
+------+----------+-----------+
5 rows in set (0.00 sec)
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> SELECT User, Password, Host FROM user;
+------+----------+-----------+
| User | Password | Host |
+------+----------+-----------+
| root | | localhost |
| root | | m00 |
| root | | 127.0.0.1 |
| | | localhost |
| | | m00 |
+------+----------+-----------+
5 rows in set (0.00 sec)
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)
扫一扫
3839
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
