解決:Navicat遠端連接配接mysql失敗

一:修改mysql配置檔案,允許遠端連接配接

sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf

将bind-address=127.0.0.1注釋

二:登入mysql,運作指令

grant all privileges on . to ‘使用者名’@’%’ identified by ‘密碼’ with grant option;;

flush privileges;

三:重新開機mysql

service mysql restart