問題一:can’t connect to mysql server on ‘192.168.xxx.xxx’(10061)
解決:
sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf,bind-address綁定了登陸的IP,把這兩行代碼注釋掉,然后重啟mysql。
問題二:1130-host ‘’ is not allowde to connect to this mysql server
在Linux中登錄到mysql中
use mysql;
select host,user,plugin,authentication_string from mysql.user;
?修改user表中的Host
update user set Host=’%’ where User=‘root’;
flush privileges;
連接成功。?