远程mysql用ssh连接_使用SSH密钥连接到远程MySQL服务器

远程mysql用ssh连接

In this article, it will be described how to connect to remote MySQL Server on Linux OS using SSH key pairs. Windows OS will be used as a host from which will be established a connection using PuTTY as a client. Besides using PuTTY as a client for establishing the connection to remote machines, it will be used to generate and use secure shell – SSH keys as well.

在本文中，将描述如何使用SSH密钥对连接到Linux OS上的远程MySQL Server。 Windows操作系统将用作主机，使用PuTTY作为客户端从中建立连接。 除了将PuTTY用作建立与远程计算机的连接的客户端外，它还将用于生成和使用安全Shell – SSH密钥。

Before starting, some prerequisites must be fulfilled. On the host machine from which a remote machine will be accessed, the Windows 10 OS should be installed and on the remote machine the Linux Ubuntu 18.04 OS.

开始之前，必须满足一些先决条件。 在将要从其访问远程计算机的主机上，应安装Windows 10 OS ，在远程计算机上应安装Linux Ubuntu 18.04 OS。

Also, on a remote machine MySQL Server needs to be installed, too. For more information about how to install MySQL on Linux refer to How To Install MySQL on Ubuntu 18.04 page.

另外，在远程计算机上，也需要安装MySQL Server 。 有关如何在Linux上安装MySQL的更多信息，请参阅如何在Ubuntu 18.04页面上安装MySQL 。

To create SSH keys, the PuTTYgen key generator needs to be installed first. Normally, PuTTYgen is installed as a part of the PuTTY.msi installation package.

要创建SSH密钥，首先需要安装PuTTYgen密钥生成器。 通常，PuTTYgen是PuTTY.msi安装软件包的一部分安装。

安装PuTTY客户端 (Installation of PuTTY client)

Installation of the PuTTY is straightforward, double-click on the executable installer, the welcome screen appears:

PuTTY的安装非常简单，双击可执行安装程序，出现欢迎屏幕：

Click the Next button to continue with the installation. Details about the installation of the PuTTY client can be found on the