MySQL 授权指定ip访问
MySQL 授权指定ip访问 我超怕的-https://www.cnblogs.com/iAmSoScArEd/p/13632279.html
提前多一次flush privileges一下,是为了防止报错。
1、指定ip
修改下面命令的:
ip(172.16.1.123)
用户名(root)
密码(password)
进行授权
flush privileges; GRANT ALL PRIVILEGES ON *.* TO 'root'@'172.16.1.123' IDENTIFIED BY 'password' WITH GRANT OPTION; flush privileges;
2、所有ip
修改 下面命令的用户名(root)、密码(password)进行授权
flush privileges; GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION; flush privileges;
3、授权指定账户、指定库表权限
```
CREATE USER '账户名'@'来源ip' IDENTIFIED BY '密码'; --创建授权用户指定ip登录
GRANT SELECT ON 库名.表名 TO '账户名'@'来源ip'; --授权账户指定库、表、来源权限
CREATE USER '用户名'@'%' IDENTIFIED BY '密码'; -- 创建授权用户任意来源登录
GRANT ALL PRIVILEGES ON *.* TO '账户名'@'%'; -- 授权用户任意库、表、任意来源登录
```
取消授权
1、指定IP
flush privileges; REVOKE ALL PRIVILEGES ON *.* FROM 'root'@'172.16.1.123' IDENTIFIED BY 'password' WITH GRANT OPTION; flush privileges;
2、取消所有IP授权
flush privileges; REVOKE ALL PRIVILEGES ON *.* FROM 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION; flush privileges;
俗人昭昭,我独昏昏。俗人察察,我独闷闷。