Is there any way to disable grouping databases in phpMyAdmin?

phpMyAdmin groups databases by default based on a common prefix in their names. If you do not want this behavior, follow these steps.

Note

MAMP PRO includes three versions of phpMyAdmin (for different PHP versions). The change needs to be made in all three configuration files.

Caution

These changes will be lost when MAMP PRO updates phpMyAdmin to a newer version. You will need to repeat the steps after each update.

1. Open /Library/Application Support/appsolute/MAMP PRO/phpMyAdmin6/config.inc.php in a text editor.

2. Add the following line at the end of the file:

   $cfg['NavigationTreeEnableGrouping'] = false;

3. Save the file.

4. Open /Library/Application Support/appsolute/MAMP PRO/phpMyAdmin5/config.inc.php in a text editor.

5. Add the following line at the end of the file:

   $cfg['NavigationTreeEnableGrouping'] = false;

6. Save the file.

7. Open /Library/Application Support/appsolute/MAMP PRO/phpMyAdmin/config.inc.php in a text editor.

8. Add the following line at the end of the file:

   $cfg['NavigationTreeEnableGrouping'] = false;

9. Save the file.

Databases will no longer be grouped by a common prefix.

---

← MySQL