mysql worbench on lamp stack

Posted February 14, 2014 2.7k 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 .

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.

Submit an Answer
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:
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.