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