MySQL——修改数据库远程权限

佚名 6年前 (2019-04-11) 随笔 1755人围观抢沙发百度已收录

语句

赋予权限

ON *.*前一个*代表库后一个代表表

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'xxxxx' WITH GRANT OPTION;

刷新权限

flush PRIVILEGES;

SRE实战互联网时代守护先锋，助力企业售后服务体系运筹帷幄！一键直达领取阿里云限量特价优惠。

示例

MySQL [(none)]> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'admin123' WITH GRANT OPTION;                           
Query OK, 0 rows affected (0.00 sec)

MySQL [(none)]> flush PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

//删除远程权限
MySQL [mysql]> delete from mysql.user where user='root' and host='%';