I need a step by step approach to accessing MySQL from the one-click LAMP droplet installation. It seems to be very difficult doing so

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.

×
1 answer

Hi there @april7baby,

What I could suggest in this case is to use a tool like MySQL Workbench to connect to your MySQL database directly from your computer.

You can follow this step by step tutorial on how to do that here:

https://www.digitalocean.com/community/tutorials/how-to-connect-to-a-mysql-server-remotely-with-mysql-workbench

That way you can connect securely to your database over SSH.

Hope that this helps and let me know how it goes!
Regards,
Bobby

by Jon Schwenn
Use MySQL Workbench to connect securely to your remote MySQL database using SSH.
Submit an Answer