mysql授权远程访问的例子

mysql>select host,user from user;
+-----------------------+------+
| host | user |
+-----------------------+------+
| 127.0.0.1 | root |
| localhost |  |
| localhost | root |
| localhost.localdomain |  |
| localhost.localdomain | root |
+-----------------------+------+

mysql> grant all privileges on *.* to 'root'@'%' identified by 'password' with grant option;
mysql> select host,user from user;
+-----------------------+------+
| host | user |
+-----------------------+------+
| % | root |
| 127.0.0.1 | root |
| localhost |  |
| localhost | root |
| localhost.localdomain |  |
| localhost.localdomain | root |
+-----------------------+------+
mysql> flush privileges;