How to remotely connect to the cloud server database using Navicat

It is very convenient to connect to a remote server database without opening the secret key. Just fill in the data on the new connection. However, there is a big pitfall in connecting to the server after opening the SSH secret key. Let's talk about it in detail below.

In fact, the secret key is turned on. Under the new connection, first select SSH to log in to the remote server

1. Fill in the public IP address (I won’t show you my address here)

2. The default SSH port is 22 and does not need to be modified

3. Please note that the username is not your Xshell or third-party console username, but your server username. Generally, it is Root if it is not modified.

4. There are two ways below, one is the secret key and the other is the password. Let's talk about the secret key here. Once you apply for SSH on the server, it will return you a public key and a private key. Save them and then import them here.

The SSH part here is fine, don't rush to test it. Remember you are only connecting to the remote server

The huge pit begins below

Step 2: Connect to the database

1. Connection name, self-made

2. This host name or IP address! ! ! ! ! ! ! I have read many online tutorials and they all require you to fill in the IP address of the remote server. In fact, you should fill in the local address here. Yes, it is the intranet address, because you have logged in to the remote server. Of course, the mysql address connected to the remote server is localhost! ! ! ! !

3. Ports need no further explanation

4. The username and password are the username and password of your database on the server. This step is to connect to the database, don't make a mistake

Finally, test the connection! success!

By the way, one last thing to say, after the test is successful and you press OK, when you double-click the database, there is a very scary thing... that is

It's OK, just enter your server login password, if you forget to look for Cloud Daddy..............................

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.