Shulou(Shulou.com)06/01 Report--

This article is about how navicat connects to the database on the server. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

It is very convenient to connect to the remote server database without opening the secret key, so you can ok the new connection by filling in the data. But there is a big hole in the server connection after opening the SSH secret key. How can navicat connect to the database on the server?

In fact, the secret key is opened. Under the new connection, log in to the remote server in SSH mode first.

Fill in the public network IP for 1.ip address (I won't show you my address here)

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

3. Note that the user name is not your Xshell or the user name of the third-party console, but the user name of your server. Generally speaking, it is Root without modification.

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, the server will return your public key and private key and save them. The SSH part here will be fine. Don't rush to test it. Remember that you just connected to the remote server.

The pit below begins.

Step 2: connect to the database

1. Connection name, self-made

two。 This hostname or IP address! Read a lot of network tutorials are to fill in the ip address of the remote server, in fact, here is to fill in the local address, yes, is the intranet address, because you have logged in to the remote server, of course, the mysql to connect to the remote server is localhost!

3. Needless to say about the port.

4. The user name and password are the user name and password of your database under the server. This step is to connect to the database. Make no mistake.

Final connection test! Success!

By the way, after the test is successful, press OK, and when you double-click the database, there is a terrible thing. That's

Thank you for reading! This is the end of this article on "how to connect navicat to the database on the server". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it out for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.