方法一 改表:
1.更改/etc/mysql/my.cnf
将文件中的“bind-address = 127.0.0.1”改为“bind-address = 0.0.0.0”,让所有IP都能访问2.修改user表
mysql -u root -p输入密码
update user set host='%' where user='root' and host='localhost';
方法二 授权:
如果你想允许用户elvis从ip为192.168.1.3的主机连接到mysql服务器,并使用elvis作为密码GRANT ALL PRIVILEGES ON *.* TO 'elvis'@'192.168.1.3' IDENTIFIED BY 'elvis' WITH GRANT OPTION;
允许所有ip,则用% 代替IP
GRANT ALL PRIVILEGES ON *.* TO 'elvis'@'%' IDENTIFIED BY 'elvis' WITH GRANT OPTION;