![]() ![]() If the connection was successful, save your connection for easier access by clicking on the Save changes button.Finally, test the connection by clicking on the Test Connection button.Note: If your SSH key is stored as ~/.ssh/id_rsa, you can usually leave this blank without any action, but depending on your client, you may need to manually select it. How to Connect to a Remote MySQL Server Using SSH Octoby Marko Zivkovic This article will explain how to set up a connection from a Windows host OS using a PuTTY client to a remote MySQL server on Linux Ubuntu 18.04. Download a fully-functional 30-day free trial, and start saving time with your database management today. To set your SSH password, click on the k ey icon to the right of the SSH Password field and locate your SSH private key.Within the SSH Host and SSH User fields, enter in your SSH credentials that you would normally use when connecting over SSH.Next, fill in the MySQL Host, Username, Password, and Database settings with the settings that you obtained in the previous section of this article.For your Connection Method, be sure that SSH is selected.The settings will be the same across most clients, although the UI reflected in the screenshots will vary between MySQL clients. You can use any MySQL client, as long as it has the ability to utilize an SSH tunnel. ![]() Note: In this example, we will be using Sequel Pro. You're now ready to continue on with configuring your MySQL client. You now have your MySQL database credentials for your WordPress site. Be sure to make note of these values as you'll need them later when configuring your MySQL client.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |