Mysql 允许所有IP访问

2018-06-06  本文已影响23人  _oeo___

随手记

$ mysql -u root -p
Enter password:

mysql> use mysql

#mysql> GRANT ALL ON *.* to root@'192.168.1.4' IDENTIFIED BY 'your-root-password'; 


mysql> GRANT ALL ON *.* to root@'%' IDENTIFIED BY 'root'; 

mysql> FLUSH PRIVILEGES;
上一篇下一篇

猜你喜欢

热点阅读