How to connect to a database using Sequel Pro

Although remote MySQL connection is disabled on our shared servers due to security reasons, you can still easily set up an SSH tunnel between your PC and our server using SSH-tunneling with the MySQL port (3306) forwarding. It will allow you to connect to the database remotely via the SSH tunnel.

To connect to your MySQL database with the Sequel Pro MySQL client, you should perform the following steps:

1. Contact our hosting support via Live chat or the ticket system in order to enable SSH access for your account
2. Launch Sequel Pro
3. Choose SSH under the connection details:



4. Fill out the fields as follows:

Name: the name you want to give the favorite
MySQL Host: 127.0.0.1
Username: your MySQL database username
Password: password for your MySQL user
Database: (optional) leave blank to have access to all of your databases
Port: 3306
SSH Host: server your account is hosted on (e.g., server1.web-hosting.com)
SSH user: your cPanel username
SSH Password: your cPanel password
SSH Port: 21098



5. Click on Add to Favorites:



6. You will see your new connection on the left:



7. Double-click on it to connect to your MySQL databases:




That's it!

              
                      Need any help? Contact our HelpDesk

Updated
Viewed
35417 times

Need help? We're always here for you.

notmyip