修改my.ini中的ip(如果有 localhost 修改為 ip)

/*------------------------2--------------------------*/

mysql -u root -p123
mysql>use mysql;
mysql>update user set host = '%' where user = 'root';
mysql>select host, user from user;

/*------------------------3--------------------------*/

mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION
//賦予任何主機訪問數據的權限
mysql>FLUSH PRIVILEGES
//修改生效
mysql>EXIT
//退出MySQL服務器