Database Visibility in Adminer

First, I really like Local.

But, once I log into the Adminer panel you only get to see the current database in use. Versus like phpmyadmin where you see ALL of your databases on your system.

I also noticed that it creates and names your new database “local”…

1) Is there a way to name your database inside Local, on each WP install?
2) And is it possible to see more than 1 database at a time?

Thanks!
Thomas

Can anyone please provide clarity on my two questions? Thanks!

Local runs each of it’s sites in its own Docker instance. This means each site has their own copy of the web server, PHP, and a database.

If you were using something like MAMP, all the databases are stored in the same location so you would see all of them.

I’m not certain it’s possible or advisable to change the database name when using Local.

1 Like

Not at this time, but if it’s something you need feel free to write up a request in Feature requests and we’ll look into it!

Not in Adminer by default.

Your best bet is to use something like Sequel Pro and set up bookmarks/favorites to individual sites. If you’re on Windows, MySQL Workbench and HeidiSQL are two great alternatives to Sequel Pro.

Thank you for your responses @afragen and @clay!

I was hoping that wouldn’t be the case… I was starting to contemplate switching from MAMP… But not having a singular visibility of DBs and the ability to name them before install is a deal breaker, unfortunately.

Much appreciated.

@tkbrown87,

Bummer!

I’m curious, can you elaborate on why not being able to name the databases is a deal breaker?

No worries, it’s staying in my doc for now and I may try it out again at a later time.

The reason is one in the same, I want to be able to name the database so I can distinguish them in adminer/phpmyadmin.

I don’t really want to download another software in order to manage databases when my current build is already barebones as is: mamp, codekit, vscode.

If Local could match the browser refresh feature and allow a singular database management tool like phpmyadmin and include all the standard WP setup options, that would cut 2 tools out.

But currently I still need to run codekit alongside Local to get the browser refresh ability.

I’m not knocking the software, I love what Local is and what it does. Thank you for taking the time to ask and respond. I appreciate your help.