Navitcat connection to the remote MySQL server is not connected

Using putty to operate MySQL database is not very convenient, just want to use navitcat ssh to connect to the remote MySQL server, you can dynamically modify the data operation. According to the opinions of many netizens online, landlord use the following command: VIM/ETC/MY.CNF.

Under [Mysqld], add the following two lines
Skip-name-resolve

Skip-grant-tables

Save, restart the MySQL service, the results on the Putty login not MySQL (username and password right), and then remove Skip-grant-tables, finally boarded. I then manipulated the project on the Web page that was deployed on the remote server, but I received a "database connection failure." Think of the changes made, I think this sentence skip-name-resolve suspect the biggest, in the comments, finally the project connected to the database successfully. But the problem is, Navitcat always connect not on the remote MySQL service, the landlord uses the intranet (the company does not allow the external network), and has been added to the local IP MySQL host there, refresh the permissions, or not. Login connection for a long time, last not even. Does the great God have any clever idea?

Navitcat connection to the remote MySQL server is not connected