Mysql 允许所有IP地址访问

连接上去执行以下命令:

use mysql;
GRANT ALL ON *.* to root@'0.0.0.0' IDENTIFIED BY 'yourPassword'; 
GRANT ALL ON *.* to root@'%' IDENTIFIED BY 'root'; 
FLUSH PRIVILEGES;

grant all privileges on *.* to 'root'@'%' identified by 'yourRootPassword' with grant option;
flush privileges;
赞(0)

评论 抢沙发

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址