Database Viewer

@braed There are desktop-based applications such as Sequel Pro if you’re using macOS for remotely managing databases.

You shouldn’t really have web-based SQL editors installed on your server as it’s a huge vulnerability if someone were to get access to your server.

For added security, you may only connect to the database via a SSH tunnel.

See the first things on this page: https://forge.besnappy.com/laravel-forge

It's been quite awhile since I've used PhpMyAdmin and not sure if it can do tunneling and use ssh keys. If it can it should work. I definitely wouldn't install it on your actual server through! I use Sequel Pro and Navicat and don't have issues connecting to it. Sequel Pro is free (mac).

I didn't realise this was possible but I used my SQL database client (Heidi) to SSH into my Forge server and view my database. Thanks for your comments.

On a side note, why would you need to login to your production database?

That should surely be a pretty rare requirement.

Using normal migrations in Laravel is normally sufficient.

If you need to view the database visually then use something on your local machine. I'm of the view that remote access to your production database is rarely a good thing or something that is required.

@ROBSTAR - That's a great point, Robstar. I was developing on my server briefly before launching and wanted to debug an issue which I think turned out to be caching.

For those that stumble across this post, Forge now has an official guide:

https://forge.helpscoutdocs.com/article/9-how-to-connect-to-your-database-using-a-gui-client