mysql -uroot -p
use mysql;
select user,host from user;
# 授权用户root可以在任意主机上登录
update user set host='%' where user='root';
flush privileges;
# 授权用户root任意权限,并可以在任意主机上登录
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
flush privileges;
# 授权用户root任意权限, 但是只能在某一个主机上登录
GRANT ALL PRIVILEGES ON *.* TO 'root'@'10.16.60.61' IDENTIFIED BY 'root' WITH GRANT OPTION;
flush privileges;
MySQL配置远程访问
于 2023-07-31 10:34:57 首次发布