Question

mysql Database management

Hey everyone I am new to digital ocean deployment environment, I deployed my Laravel app & created mysql db using terminal then migrate all my tables, my confusion start here how can I manage my db without terminal like laragon? if there is no way how can u guys manage ur data in digital ocean or there is any 3rd party suitable for visualizing my tables rows staff & where is my folders inside digital? every thing is hidden only access via terminal? if that the case I am in nightmare!

Any one can explain me the case please!


Submit an answer

This textbox defaults to using Markdown to format your 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 or Sign Up to Answer

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.

Hi @showmore5,

You can indeed use a Third-party software to connect from your laptop to your Database, mysql-workbench is one that I would recommend. It will provide you with a GUI which can help a lot of the managing:

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

Hello,

I personally use Tableplus to connect and manage my MySQL databases or if you are using Windows, you could use MySQL Workbench as described here:

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

An alternative approach would be to install PHPMyAdmin on your server and use it instead. Here is a step by step guide on how to do that:

https://www.digitalocean.com/community/questions/how-to-install-manually-phpmyadmin-on-ubuntu

Best,

Bobby