Connecting to Mysql database via workbench.

Posted August 6, 2015 22.8k views

Hi guys,

Im a bit new to digital ocean, Im trying to connect to the MySQL database via workbench and im having a bit of problems. I really need step by step help on how to connect to the MySql database.

I have a windows machine. I tried connecting over standard ( TCP/IP) and also standard( TCP/IP) over SSH.

For the standard( TCP/IP) over SSH:
When i try connect it says could not connect to the ssh tunnel, and proceeds to say “ Your connection attempt failed for user ’root’ from your host to server at
Can’t connect to MySql server on ‘’ (10060)

I just dont know what im doing wrong?

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
3 answers

By default MySQL does not allow remote connections. To change this you will need to modify the /etc/mysql/my.cnf file, change the bind-address line to reflect your droplet’s IP address:

bind-address        = your_database_IP

and then restart MySQL:

service mysql restart

what happen i faced this problem.

This is an old post, but since it was one of top Google searches I’m adding the solution that worked for me to fix the issue.

For anyone who has working SSH connection, like with Putty already, but still get connection errors after following this tutorial

These two things helped me fix:

Generate a private SSH key without passphrase
When using Puttygen, import your existing private key, then export it as OpenSSH. I previously used simply save private key and it didn’t work with Workbench (more info here

by Jon Schwenn
Use MySQL Workbench to connect securely to your remote MySQL database using SSH.