By shanescott
I am wondering if any one can tell me the correct method to connect to MySQL Server on my VPS using MySQL Workbench over SSH… I tried earlier and the connection was refused…
I don’t like using phpMyAdmin on a live server!
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
If yo’re still having issues with this, see this thread which solved the connection to MySQL Workbench for me: https://www.digitalocean.com/community/questions/trying-to-connect-to-mysql-database-server-through-mysql-workbench-using-ssh?comment=42464
Basically you’ll need to have MySQL service listen to the public IP for remote connections since by default it listens on the loopback adapter. <br> <br>Look at these two posts that might answer your question: <br>https://digitalocean.com/community/questions/how-to-create-a-secure-connection-for-workbench-to-mysql <br>https://digitalocean.com/community/questions/how-to-allow-remote-mysql-database-connection
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.