mysql 数据库 安全优化 用户授权

 mysql> select user,host from mysql.user;       查询有哪些用户+---------------+-----------+| user          | host      |+---------------+-----------+| mysql.session | localhost || mysql.sys     | localhost || root          | localhost |+---------------+-----------+3 rows in set (0.01 sec)mysql> grant all privileges on *.* to qfedu@'localhost' identified by 'lile@5201314' with grant option;       创建用户Query OK, 0 rows affected, 1 warning (0.01 sec)mysql> select user,host from mysql.user;+---------------+-----------+| user          | host      |+---------------+-----------+| mysql.session | localhost || mysql.sys     | localhost || qfedu         | localhost || root          | localhost |+---------------+-----------+4 rows in set (0.01 sec)mysql> set password for 'mysql.session'@'localhost' = password('lile@5201314');      修改mysql.session用户的密码Query OK, 0 rows affected, 1 warning (0.00 sec)mysql>  set password for 'root'@'localhost' = password('lile@5201314');   修改root用户密码mysql> flush privileges;      刷新权限Query OK, 0 rows affected (0.01 sec)

mysql>  grant all privileges on *.* to 'qfedu'@'192.168.2.%' identified by 'lile@5201314' with grant option;Query OK, 0 rows affected, 1 warning (0.01 sec)mysql> flush privileges;