mysql跨服务器权限,如何授予用户的远程访问权限mysql服务器？

If I do SHOW GRANTS in my mysql database I get

GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost'

IDENTIFIED BY PASSWORD 'some_characters'

WITH GRANT OPTION

If I am not mistaken, root@localhost means that user root can access the server only from localhost. How do I tell MySQL to grant root the permission to access this mysql server from every other machine (in the same network), too?

解决方案

This grants root access with the same password from any machine in *.example.com:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%.example.com'

IDENTIFIED BY 'some_characters'

WITH GRANT OPTION;

FLUSH PRIVILEGES;

If name resolution is not going to work, you may also grant access by IP or subnet:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.%'

IDENTIFIED BY 'some_characters'

WITH GRANT OPTION;

FLUSH PRIVILEGES;