grant all on *.* to 用户名@"%" identified by "密码";




mysql>  select host,user,password from user;

+-----------------------+-------+-------------------------------------------+

| host                  | user  | password                                  |

+-----------------------+-------+-------------------------------------------+

| localhost             | root  | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |

| localhost.localdomain | root  | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |

| 127.0.0.1             | root  | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |

| ::1                   | root  | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |

| %                     | root  | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |

| %                     | mysql | *9B6C840E719272EB0A76A3E66F16123F088C785A |

+-----------------------+-------+-------------------------------------------+