phpmyadmin doesn't show all my mysql dabatabases

Forum Moderators: open

Message Too Old, No Replies

phpmyadmin doesn't show all my mysql dabatabases

tirengarfio

11:47 pm on Aug 1, 2009 (gmt 0)

Hi,

I have this databases:

t@t-laptop:/home/aplis_sf/rs/config$ mysql -uroot -pm
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 370
Server version: 5.0.51a-3ubuntu5.4 (Ubuntu)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases;
+--------------------+
¦ Database ¦
+--------------------+
¦ information_schema ¦
¦ jobeet ¦
¦ mysql ¦
¦ rs ¦
+--------------------+
4 rows in set (0.01 sec)

mysql>

But phpmyadmin only shows "information_schema" and "mysql". Any idea?

Ciao

belfasttim

1:34 am on Aug 4, 2009 (gmt 0)

Are you logging in to phpmyadmin as root?

janharders

4:53 am on Aug 4, 2009 (gmt 0)

iirc, phpmyadmin has an option that lets you define that only certain databases should be shown - make sure it is not set.

Edit: look at $cfg['Servers'][$i]['only_db'] and also check that $cfg['Servers'][$i]['hide_db'] is not set to hide your databases.