mysql worbench on lamp stack

February 14, 2014 1.2k views
any idea how to make mysql workbench work on lamp stack? i'm like total noob in servers and would really appreciate if someone could help me set it up .
2 Answers
It might not be an easy task, but in essence you need to edit the configuration file of MySQL to listen to the external IP your Droplet has. You also need to have a user who can connect remotely in MySQL and the port open on the firewall to accept external connections.
A more secure way would be tunneling port 3306 via SSH: https://www.digitalocean.com/community/articles/how-to-set-up-ssh-tunneling-on-a-vps.
In this article, you'll learn how to create a safe, encrypted tunnel between your computer and your VPS along with how to bypass limits in a corporate network, how to bypass NAT, etc.
Have another answer? Share your knowledge.