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.
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.