MySQ版本:
mysql -V
mysql Ver 14.14 Distrib 5.5.47, for Win32 (x86)
mysql> select host, user, password from user;+-----------+------+-------------------------------------------+
| host | user | password |
+-----------+------+-------------------------------------------+
| localhost | root | *93E34F4B81FEC9E8271655EA87646ED01AF377CC |
+-----------+------+-------------------------------------------+
root用户,只能以localhost访问。
允许远程访问:
grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;
刷新权限:
flush privileges;
mysql> select host, user, password from user;+-----------+------+-------------------------------------------+
| host | user | password |
+-----------+------+-------------------------------------------+
| localhost | root | *93E34F4B81FEC9E8271655EA87646ED01AF377CC |
| % | root | *93E34F4B81FEC9E8271655EA87646ED01AF377CC |
+-----------+------+-------------------------------------------+