A11393ab0ddb075b28a157c7688efccd1fb25057
By:
tgif

Connecting to Mysql database via workbench.

August 6, 2015 8.2k 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?

2 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.

Have another answer? Share your knowledge.