Connecting to Mysql database via workbench.
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?