Can't see mysql databases created by phpmyadmin

[HenryTheEight]

Hi,

I am new to ispconfig and linux (Centos), but have found ispconfig a very easy to use application.

My problem: phpmyadmin seems to be able to list and display the databases
created by ispconfig e.g. web1_db1 etc. and all works well i.e. the databases
are listed on the left column on phpmyadmin. However, databases created
directly by the phpmyadmin control panel e.g. "db_test" does not show up on the please select a database column.

I only can see the database using mysql commands "show databases;". Is this a bug or do I need to do something to make phpmyadmin recognise the newly created database. Without being able to select the "db_test" database, I won't be able to use the web GUI functions to manipulate db_test.

Help appreciated.... with thanks

BTW using phpmyadmin 2.11.4 ispconfig 2.2.19

[Hans]

If you want to display the databases you mention, please remove "test" or "information_schema" from the line:

$cfg['Servers'][$i]['hide_db'] = '(information_schema|mysql|pmadb|test)';

within the phpMyAdmin configuration file, which is: /home/admispconfig/ispconfig/web/phpmyadmin/config.inc.php

[HenryTheEight]

Hans,

Thanks for the tip. Of all the database names to choose from, I had
to be lucky enough to choose a default hide-db name like "db_test".

I have since created another database with a more 'unique' database name (i.e. something without the word 'test' or 'mysql' etc.) in it. And ... now all
is well and working. Now the database with a new name is no longer hidden.

[Desp]

Hi,

I have done an upgrade from ubuntu 11.10 to 12.04 and the problem is that I can see my site up and running while I can't see the database in phpmyadmin. Is there a way to find the old databases or find why I cant see them in phpmyadmin anymore. My website is selman.us

I have also 2 other sites that show a new wordpress installation when I try to open them and they seem can't see the databases created for this sites before.

So actually I have 2.5 website working out of 5 and can't see any of the databases in phpmyadmin.

Please help!

[till]

Please take a look into the directory /var/lib/mysql/ on your server, there should be a subfolder with the name of the database for each db.

[Desp]

Originally Posted by till

Please take a look into the directory /var/lib/mysql/ on your server, there should be a subfolder with the name of the database for each db.

Awesome till, I can see them there thank you alot. Can I just import them to phpmyadmin again? I tried but getting permission denied.

[Desp]

Your help is much appreciated till, I found the answer.