mysql> select User,Host from mysql.user;
+------+-----------+
| User | Host |
+------+-----------+
| root | 127.0.0.1 |
| root | ::1 |
| root | localhost |
+------+-----------+
3 rows in set (0.01 sec)
/***** 授权用户 *****/
mysql> GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘192.168.11.80‘;
Query OK, 0 rows affected (0.01 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
mysql> select User,Host from mysql.user;
+------+-----------+
| User | Host |
+------+-----------+
| root | % |
| root | 127.0.0.1 |
| root | 192.168.* |
| root | ::1 |
| root | localhost |
+------+-----------+
5 rows in set (0.00 sec)
/***** 删除用户 *****/
mysql> drop USER ‘root‘@‘192.168.11.80‘;
Query OK, 0 rows affected (0.00 sec)
mysql> select User,Host from mysql.user;
+------+-----------+
| User | Host |
+------+-----------+
| root | % |
| root | 127.0.0.1 |
| root | ::1 |
| root | localhost |
+------+-----------+
4 rows in set (0.00 sec)
/***** 授权部分网段用户 *****/
mysql> GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘192.168.%‘;
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
mysql> select User,Host from mysql.user;
+------+-----------+
| User | Host |
+------+-----------+
| root | % |
| root | 127.0.0.1 |
| root | 192.168.% |
| root | ::1 |
| root | localhost |
+------+-----------+
5 rows in set (0.00 sec)
/***** 设置用户密码 *****/
mysql> SET PASSWORD FOR ‘root‘@‘192.168.%‘ = PASSWORD(‘123456‘);
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
本文出自 “老炮儿” 博客，请务必保留此出处http://joelemma.blog.51cto.com/11189330/1763068
Mysql用户授权
标签：mysql