mysql worbench on lamp stack

February 14, 2014 2.2k views
vfistri2
By:
vfistri2
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 .
Log In to Comment
2 Answers
ricardo.parraga February 14, 2014
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.
Reply
kamaln7 MOD February 14, 2014
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.
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.
Reply
Have another answer? Share your knowledge.