Home  >  Article  >  Database  >  How to connect to Mysql database via SSH?

How to connect to Mysql database via SSH?

黄舟
黄舟Original
2017-08-03 09:36:5215276browse

For the security of the database, the database administrator will add a layer of "protective umbrella" to the database when configuring the database to protect the user's security and information from being leaked when connecting to the database. This is a common practice. Configuring SSH means adding a security protocol to the database, which also makes it difficult for users to connect remotely.

Recommended related mysql video tutorials: "mysql tutorial"

1. Here the editor uses SQLyogEnt for remote connection and configure SSH database. Run the database client through SQLyogEnt on the desktop.

How to connect to Mysql database via SSH?

2. Click the [New] button in the interface and fill in the IP address and user name of the Mysql database under Mysql , password, port (default is 3306), database name. This is the same as the ordinary method of connecting to the database.

How to connect to Mysql database via SSH?

3. At this time, the reader can click [Test Connection]. Is it OK to click Test Connection to connect to the database at this time? will succeed because the database is configured for SSH access. As shown below:

How to connect to Mysql database via SSH?

4. After configuring the Mysql information, select [SSH] next to it

How to connect to Mysql database via SSH?

5. After clicking SSH, a prompt box will pop up. Click the [OK] button in the prompt box.

How to connect to Mysql database via SSH?

6. Click and check "Use SSH tunnel"

How to connect to Mysql database via SSH?

7. After checking, the configuration information below changes from gray before checking to white and can be entered. Here, configure the accessed SSH host address, user name, and password. Or public key.

How to connect to Mysql database via SSH?

8. After the configuration is completed, test whether the configuration connection is correct. Click [Test Connection] because the correct SSH has been configured. Access, this test connection was successful.

How to connect to Mysql database via SSH?

9. Finally, you can click the [Connect] button at the bottom of the interface to connect to the database and proceed.

How to connect to Mysql database via SSH?

##Notes

Information configuration is correct


The above is the detailed content of How to connect to Mysql database via SSH?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn