Mysql用户授权

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