Manage MySQL databases through Virtualmin working fine, but with phpmyadmin databases are not showing

Virtualmin
1

Hello,

I have a problem with phpmyadmin. When users (or root) makes a database through Virtualmin (on Centos 6.3) they can manage these databases.

But when they login trough phpmyadmin the cannot see those databases. I tried to uninstall this script and install it again, but with no results.

Is this a common problem with the combination of virtualmin / centos 6.3 / phpmyadmin?

2

I have same problem, please le me know if u find an fix. Thx

3

http://yourdomain.tld/phpmyadmin/Documentation.html#linked-tables is where you can read more about making the changes permanently.I think this has to do with the new version of the phpmyadmin script and not with virtualmin/webmin

Here is a temp fix, once you reboot, the changes go back to not showing databases.

  • type a list of all your databases on a notepad (text editor or your choice)
  • select/copy all databases names from the notepad
  • go to http://your.doamin.tld/phpmyadmin
  • click on Settings -> Features
  • find “Show only listed databases” and paste your db names on there
  • click save

Your preferences will be saved for current session only. Storing them permanently requires phpMyAdmin configuration storage. (http://yourdomain.tld/phpmyadmin/Documentation.html#linked-tables)

I have not done the permanent fix yet, I just discovered this by mistake. Good luck! Let us know if you do, thx

4

Can anyone post instruction on how to permeant show all databases please? Thx

5

Hi,

Just go to your phpmyadmin folder and edit the file “config.inc.php”

Search for the line :

$cfg[‘Servers’][$i][‘only_db’] = Array(‘NAMEOFYOURDB’);

and change it to :

$cfg[‘Servers’][$i][‘only_db’] = Array(’%’);

Log out then log in to phpmyadmin, you should now see all DBs of your domain user.

Enjoy :slight_smile:

6

@ librasoft Thanks a bunch, that did it, I really appreciated and it could not be simpler than that lol