1. mysql> use mysql;
    2. Database changed
    3. mysql> grant all privileges  on *.* to root@'%' identified by "password";
    5. 可以指定某一个数据库
    6. grant all privileges  on 数据库.表 to root@'%' identified by "指定的密码";
    7. grant all privileges  on your_db.* to root@'%' identified by "password";
    8. your_db的所有表
    10. Query OK, 0 rows affected (0.00 sec)
    12. mysql> flush privileges;
    13. Query OK, 0 rows affected (0.00 sec)
    15. mysql> select host,user,password from user;
    16. +--------------+------+-------------------------------------------+
    17. | host         | user | password                                  |
    18. +--------------+------+-------------------------------------------+
    19. | localhost    | root | *A731AEBFB621E354CD41BAF207D884A609E81F5E |
    20. | 192.168.1.1 | root | *A731AEBFB621E354CD41BAF207D884A609E81F5E |
    21. | %            | root | *A731AEBFB621E354CD41BAF207D884A609E81F5E |
    22. +--------------+------+-------------------------------------------+
    23. 3 rows in set (0.00 sec)