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

6 posts / 0 new
Topic locked
Last post
#1 Mon, 10/01/2012 - 10:41
pesja

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

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?

Fri, 10/26/2012 - 16:05
PepinYaco

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

Sat, 10/27/2012 - 17:36
PepinYaco

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

Sun, 05/12/2013 - 13:49
PepinYaco

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

Thu, 06/20/2013 - 09:30
librasoft

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 :-)

Sat, 06/29/2013 - 11:53
PepinYaco

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

Topic locked