任意访问
如果不限制ip访问,授权某个用户可以以任意ip访问该服务,可以这样写:
GRANT ALL PRIVILEGES ON *.* TO admin@'%' IDENTIFIED BY 'admin'; FLUSH PRIVILEGES;
设置ip对应访问
grant all on *.* to 'remote'@'172.16.21.39' identified by 'password';FLUSH PRIVILEGES;
任意访问
如果不限制ip访问,授权某个用户可以以任意ip访问该服务,可以这样写:
GRANT ALL PRIVILEGES ON *.* TO admin@'%' IDENTIFIED BY 'admin'; FLUSH PRIVILEGES;
设置ip对应访问
grant all on *.* to 'remote'@'172.16.21.39' identified by 'password';FLUSH PRIVILEGES;