Common Issue #1: Temporary Block of Your IP Address It will connect to MySQL through an SSH Tunnel. List the databases by clicking the Schemas navigational elements as shown in the image below:īelow are some of the issues faced on trying to create an SSH Tunnel for MySQL. Double-click on the connection name to connect to your database. You should see your new connection on the left in the panel listing connections:Ħ. Again, press OK to save the connection settings. Click the OK button to close the dialog box. It will show the ‘Connection Successful’ message as shown in image below:ĥ. Click the Test Connection button on the New Connection dialog box shown above after completing all the fields. Host Name/IP Address: Provide the Nexcess IP / Hostname.Ĥ.Then, go to the SSH Tab section, check the Use SSH Tunnel checkbox and fill out the fields as follow: Password: The MySQL Database User Password.ģ.User Name: The MySQL Database Username to open the connection.In the General Tab section, fill out the fields as follow: Open your Navicat for MySQL client and click Connection > MySQL option from dropdown menu:Ģ. Using the MySQL Navicat for MySQL Client Steps 1-6 Once downloaded and installed, please follow the below steps to create an SSH Tunnel for MySQL using Navicat for MySQL. You can download the Navicat for MySQL client from here: How to Connect to a MySQL database Through an SSH Tunnel Using the Navicat for MySQL Client List the databases by clicking the Schemas Tab as shown in image below. Now click on the newly added connection to connect to the MySQL Server. Also, click the OK button to add the connection to the Connections Library. Now click the OK button to close the dialog box. As shown in the image below, it will render the ‘Successfully made the MySQL connection’ message. Provide the password and click the OK button. It will prompt for the password if you have not stored it previously in the vault. Click on the Continue Anyway button when the prompt appears:Ĭlick the OK button to confirm the connection. It might show the Connection Warning message when the connection is used for the first time as shown in then image below. You have the option to store it in the vault by clicking the Store in Keychain button.Ĭlick the Test Connection button after filling in all the fields. Password: The MySQL Database User Password to be used to open the connection.Username: The MySQL Database Username to be used to open the connection.MySQL Hostname: Leave it as '127.0.0.1' to access the MySQL server installed on the same remote system.SSH Password or SSH Key File: The SSH Password or SSH Key File is used to connect the remote system over SSH.( Note: No need to supply the optional port, as the default SSH port is 22.) SSH Hostname: Provide the Nexcess IP / Hostname.Connection Method: Choose Standard TCP/IP over SSH from dropdown menu.Connection Name: The connection name for your reference.Open the MySQL Workbench client and click the Plus Icon to the right of MySQL Connections test string as shown in the image below:įill in the connection parameters as listed below: Using the MySQL WorkBench Client Steps 1-7 Once downloaded and installed, please follow the below steps to create an SSH tunnel for MySQL using MySQL WorkBench. MySQL Community Downloads > MySQL Workbench You can download MySQL Workbench client from here: How to Connect to a MySQL Database Through an SSH Tunnel Using the MySQL WorkBench Client You can easily find this information using the Nexcess Portal Dashboard. MySQL Community Downloads > MySQL Workbench. How to Connect to a MySQL Database Through an SSH Tunnel Prerequisites to Connect to MySQL Database Through an SSH Tunnel Both of them let you manage your databases remotely without having to go through logging into the Nexcess Portal every time you want to make database changes. The most popular software tools used to connect to a MySQL database through tunnels are MySQL Workbench and Navicat for MySQL. For example, SSH-Tunneling with the MySQL Port (Port 3306) forwarding provides strong authentication and secure encrypted communication between two hosts and lets you manage the databases remotely. Secure Shell or SSH is a client-server-based communication protocol that is used to securely to connect from one machine to another. This is where the MySQL SSH Tunnel comes in handy. Creating an SSH Tunnel for Your Site’s MySQL Database Why SSH-Tunneling with the MySQL Port?īy default, your databases are not directly accessible from outside the Nexcess environment since the database cannot reliably maintain the security and patch levels available with the Secure Shell Protocol (SSH). Secure Shell (SSH)-Tunneling provides strong authentication and secure encrypted communication between two hosts and lets you manage the databases remotely.
0 Comments
Leave a Reply. |