1. 授权某个用户仅指定IP可连接
UPDATE mysql.user set Host = ‘10.37.41.1’ where User = ‘username’;
2. 授权某个用户指定IP段可连接
UPDATE mysql.user set Host = ‘10.37.41.%’ where User = ‘username’;
注:所有权限操作后需执行权限刷新操作flush privileges;且重新登录才可生效。
1. 授权某个用户仅指定IP可连接
UPDATE mysql.user set Host = ‘10.37.41.1’ where User = ‘username’;
2. 授权某个用户指定IP段可连接
UPDATE mysql.user set Host = ‘10.37.41.%’ where User = ‘username’;
注:所有权限操作后需执行权限刷新操作flush privileges;且重新登录才可生效。