Use Navicat to manage MySQL databases on a remote Linux Server

Although phpMyadmin is very easy to manage Mysql, if your database is already relatively large, it may be difficult to import or export the database through a browser due to the speed of the domestic network. It is estimated that your database has not been uploaded yet, the program has timed out and PHP has a limit on the size of the file to be uploaded. If the database exceeds this limit, the file cannot be uploaded. Use Navica

AlthoughPhpMysql management by Myadmin is very easy to use, but if your database is already relatively large, in view of the domestic network speed, importing or exporting databases through a browser is troublesome. It is estimated that your database has not been uploaded yet, the program has timed out, andPHPThere is a limit on the size of the uploaded files. If the database exceeds this limit, it cannot be uploaded.

Use NaviCatThis Mysql client solves the above problems. However, there are new problems. Generally, for the sake of security, our Mysql will prohibit all IP addresses except local logon. Of course, you can add a Client IP address to solve this problem, however, when we access the Internet through ADSL, the IP address is not fixed. We need to re-Add the IP address each time we manage the database.

The solution is very simple. In fact, Navicat supports the SSH channel, and sets the server address to 127.0.0.1 through the SSH connection on the server. Mysql considers the connection as a local address, and the connection will pass smoothly.

In connection settings, enter 127.0.0.1 as the general option, switch to SSH, fill in the server IP address and SSH account password.