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 |
+-----------------------+-------+-------------------------------------------+
89
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
