登录到MySQL服务器端,在mysql库下执行grant all on *.* to ‘remote’@’172.16.21.3本文来源gaodaimacom搞#^代%!码&网*9′ identified by ‘password’;即可
如果要设置为任何客户端都可以以root连接的话,可以这么写:
grant all on *.* to ‘root’@’%’ identifiied by ‘root的密码’
登录到MySQL服务器端,在mysql库下执行grant all on *.* to ‘remote’@’172.16.21.3本文来源gaodaimacom搞#^代%!码&网*9′ identified by ‘password’;即可
如果要设置为任何客户端都可以以root连接的话,可以这么写:
grant all on *.* to ‘root’@’%’ identifiied by ‘root的密码’