MAMP PRO (macOS) Documentation

FAQ > MySQL

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.

Please note that MAMP PRO includes two different versions of phpMyAdmin (for different PHP versions). Therefore, the change needs to be made twice, which is already accounted for in the following instructions.

1. Open the file “/Library/Application Support/appsolute/MAMP PRO/phpMyAdmin5/config.inc.php” in your text editor.
2. Add the following line at the end of the file:
   $cfg['NavigationTreeEnableGrouping'] = false;
3. Save the file.
4. Open the file “/Library/Application Support/appsolute/MAMP PRO/phpMyAdmin/config.inc.php” in your text editor.
5. Add the following line at the end of the file:
   $cfg['NavigationTreeEnableGrouping'] = false;
6. Save the file.

Databases will no longer be grouped based on a common prefix in their names.