Often play MySQL database on the server, but the Linux-based operation of MySQL is more inconvenient, so I would like to use GUI tools to remotely manipulate the MySQL database. It is not three times to use Navicat-for-mysql, but each connection to the remote server MySQL database will encounter problems, annoying, simply write down this time, the next time you use Navicat for MySQL convenient.
Before also played Navicat-for-postgresql, it seems that the Navicat series is indeed a wide span. To connect to a remote server's MySQL database, you should first connect to the remote server:
This operation we should fill in the SSH list entry information, note that the account information here is the Linux server account information, not the MySQL database account information. But this time you test the connection success or not will be error! Before checking the information, someone directly connected to the end, the test connection was successful. I'm a loser, so I need to be careful here. This is followed by filling out the MySQL account information. :
At first I in the host column filled in the information is localhost, but always error, so I changed the wording, replaced by: 127.0.0.1
Then the connection was successful.
Navicat for MySQL remote connection to the Ubuntu server MySQL database