Connecting to Mysql database via workbench.

August 6, 2015 12.4k views
MySQL

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 127.0.0.1:3306:
Can't connect to MySql server on '127.0.0.1' (10060)

I just dont know what im doing wrong?

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 https://www.digitalocean.com/community/questions/trying-to-connect-to-mysql-database-server-through-mysql-workbench-using-ssh)

by Jon Schwenn
Use MySQL Workbench to connect securely to your remote MySQL database using SSH.
Have another answer? Share your knowledge.