Question

How do I connect MySQL Workbench to my VPS?

Posted February 21, 2014 31k views
I am wondering if any one can tell me the correct method to connect to MySQL Server on my VPS using MySQL Workbench over SSH.... I tried earlier and the connection was refused... I don't like using phpMyAdmin on a live server!
Add a comment
shane.scott
By:
shane.scott

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
Submit an Answer
11 answers
rupert July 26, 2016

The key on a 2 server setup for me was to have the full internal address for the MySQL Hostname, i.e. 127.0.0.1:3306 - without this it just wouldn’t work and it was by a LOT or trial and tests that I managed to get this to work.....so:
SSH Hostname: xx.xx.xx.x:22 of the DB server, which is also used as the bind address in my.cnf
SSH Username: your admin username
MySQL Hostname: 127.0.0.1:3306
MySQL Server Port: 3306
Username: whatever LOCAL , i.e. on the same db server, admin user you have set up on MySQL

You can then close it down as needed, e.g. with ufw on Ubuntu etc.

this took a LONG time to figure out so hopefully will save some peeps some time!

Reply Report
kamaln7 February 22, 2014
A more secure way would be keeping MySQL on the loopback interface and tunneling port 3306 to your local computer: https://www.digitalocean.com/community/articles/how-to-set-up-ssh-tunneling-on-a-vps.
How To Set Up SSH Tunneling on a VPS
In this article, you'll learn how to create a safe, encrypted tunnel between your computer and your VPS along with how to bypass limits in a corporate network, how to bypass NAT, etc.
Reply Report
michaelf January 21, 2016

If yo’re still having issues with this, see this thread which solved the connection to MySQL Workbench for me:
https://www.digitalocean.com/community/questions/trying-to-connect-to-mysql-database-server-through-mysql-workbench-using-ssh?comment=42464

Reply Report
ricardo.parraga February 21, 2014
Basically you'll need to have MySQL service listen to the public IP for remote connections since by default it listens on the loopback adapter.

Look at these two posts that might answer your question:
https://digitalocean.com/community/questions/how-to-create-a-secure-connection-for-workbench-to-mysql
https://digitalocean.com/community/questions/how-to-allow-remote-mysql-database-connection
Reply Report
shane.scott February 27, 2014
Thanks guys :)
Reply Report
abel.adam6 May 21, 2014
@kamal can you provide me with a very simple tutorial. i can't understand the link you provided.please.
Reply Report
kamaln7 May 24, 2014
@Tekeste: Try following Example 1 in that article and replacing port 110 with port 3306.
Reply Report
wmassingham July 5, 2014

MySQL Workbench works without any configuration necessary. When making a new connection, select “Standard TCP/IP over SSH”, then change the SSH and MySQL parameters as necessary. (You should probably keep the SQL server IP address as 127.0.0.1.)

Reply Report
jango December 16, 2015

For those of you still searching, here’s the command you can use based on @kamaln7 ’s suggestion.

Reply Report
dennismonari November 14, 2016

Thank you Rupert. You reply above saved me alot!

Reply Report
Previous 1 2 Next
Load More Answers

Looking for something else?

Ask a new question Search for more help