Question
mysql worbench on lamp stack
- Posted February 14, 2014
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 .
Subscribe
Share
Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
Sign in to AnswerThese 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.
A more secure way would be tunneling port 3306 via SSH: <a href=“https://www.digitalocean.com/community/articles/how-to-set-up-ssh-tunneling-on-a-vps”>https://www.digitalocean.com/community/articles/how-to-set-up-ssh-tunneling-on-a-vps</a>.
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.