筆者當前的版本
- mysql Ver 14.14 Distrib 5.7.30
- ubuntu 16.04.6
解決方案
查看端口是否有誤允懂，默認是3306
1.查看遠程連接權(quán)限是否打開 修改 root 用戶 host = % 并且重啟mysql
update user set host='%' where user =='root';
sudo service mysql restart
+-----------+------------------+
| host | user |
+-----------+------------------+
| % | root |
| localhost | debian-sys-maint |
| localhost | mysql.session |
| localhost | mysql.sys |
+-----------+------------------+
2.修改mysqld.cnf ,直接注釋掉bind_address
#bind-address = 127.0.0.1
sudo service mysql restart
