mysql设置指定ip或全部 ip访问的方法

//设置全部ip访问方法一use mysql; 使用mysql数据库update user set host = '%'where user ='root';flush privileges; //立即生效//设置全部ip访问方法二GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;flu

1002710030

9398人浏览 · 2022-01-26 11:00:45

1002710030 · 2022-01-26 11:00:45 发布

//设置全部ip访问方法一
use mysql; 使用mysql数据库
update user set host = '%'  where user ='root';
flush privileges; //立即生效

//设置全部ip访问方法二
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
flush privileges; //立即生效

//设置192.168.1.168访问方法一
GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.168' IDENTIFIED BY 'root' WITH GRANT OPTION;
flush privileges; //立即生效