Page 1 of 1

phpmyadmin database order

PostPosted: 25. March 2021 11:40
by bookie56
Hi guys!
If I create a database with the name bookie56_test....the database is created...
If I create a new database with bookie56_test1....the new one is created but in same tree as the first one and the tree gets renamed to bookie56...
Is this usual behaviour?
Can I still treat them as individual databases even if they have become part of a tree?


bookie56

Re: phpmyadmin database order

PostPosted: 25. March 2021 13:44
by Altrea
Hi,

Yes that is the default behavior in phpmyadmin. You can group databases by beginning with the same letters and an underscore.
This can be pretty weird especially because databases which only contains of the group word will also be grouped in, like "test" and "test_data".
But you can disable this behavior in the phpmyadmin config.inc.php file by setting $cfg['NavigationTreeEnableGrouping'] to value false.
Or you can redefine the letter which triggers the DB separator with $cfg['NavigationTreeDbSeparator']

And yes, the databases in a group are still seperate from each other. It is just a visual help.