Ubuntu 14.04 安裝MySQL服務(wù)后，打算遠(yuǎn)程使用Navicat for mysql管理數(shù)據(jù)庫(kù)，但是使用Navicat遠(yuǎn)程連接的時(shí)候一直出現(xiàn)錯(cuò)誤：
網(wǎng)上多番google解決方案，關(guān)閉防火墻，修改數(shù)據(jù)庫(kù)user host以及賦予權(quán)限，grant all privileges on . to 'user'@'%' identified by 'password' with grant option; 修改/etc/mysql/my.conf配置文件bind-address 屬性改為 0.0.0.0 或者直接注釋這一句，我都做了嘗試，但是還是無(wú)法解決遠(yuǎn)程登錄mysql 10038的問(wèn)題。
下面附上我的mysql和3306端口圖：
我遇到的困難所有網(wǎng)上說(shuō)的方案都嘗試過(guò)，甚至重裝過(guò)mysql服務(wù)器都沒(méi)辦法解決。求有經(jīng)驗(yàn)的人士不吝賜教幫忙提供建議，多謝。
6
0
0
走同樣的路，發(fā)現(xiàn)不同的人生
Is the client’s firewall blocked? Use tcpdump on the server to see if the package has been received
Whether it is executed after modifying the permissionsflush privileges
You can try to connect remotely through the command line to see if it is a problem with the command line or navtive. I am a novice and I like to use troubleshooting
I just finished it over the weekend and had a similar problem. I reinstalled it several times. There is a etc/mysql/…/mysqd.conf. It seems to be that file. I was not next to the computer. Binding the file inside The ip is commented
, and then it’s fine
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
