Can't see created databases

Question

I've got two problems with EasyPHP (probably related).

1) If I create the database in PhpMyAdmin I can't see it in the navigation panel or in the "Database" page. the database exists because I can make query on it and it conflicts with other CREATE instructions (using the same name). I supposed it was a configuration (permission?) problem so...

2) Going to tray icon, right click on easyPHP icon, then "Configuration->PhpMyAdmin" I obtain "Object not found" error for the URL http://127.0.0.1/home/mysql/.

I use win8.

Thank you.

EDIT: I tried to update to PhpMyAdmin 4.1.12, but nothing happened.

It looks more like an issue with the use of a program, then an actual programming issue? — Nanne
– Nanne, Commented Apr 28, 2014 at 18:48
@Nanne, yes, but the forum of easyPHP does not exist anymore, so I have to ask here for assistence (see easyphp.org/forums). — ufo
– ufo, Commented Apr 28, 2014 at 21:50

ufo · Accepted Answer · 2014-05-02 19:08:09Z

8

I finally found the solution! In config.inc.php configuration file, I changed this line:

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

With:

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

Now it works fine!

answered May 2, 2014 at 19:08

ufo

6852 gold badges12 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Martavis P. Over a year ago

This just worked for me too! All I did was create a database through phpMyAdmin and when I went to export it, the database in question didn't show while others did. Does anyone know why this happens?

Atthapon Junpun-eak Over a year ago

I've just faced this problem for the first time. This solution really amazes me. Why does phpmyadmin create this kind of issue lol?

LowFieldTheory · Accepted Answer · 2017-01-21 18:24:19Z

0

if you create a database with the string "test" in it, it will hide, because of the line in the accepted answer. I removed "test" from this line

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

and the database showed up.

answered Jan 21, 2017 at 18:24

LowFieldTheory

1,7932 gold badges30 silver badges42 bronze badges

Comments

ilomax · Accepted Answer · 2017-08-14 08:12:16Z

0

The solution you gave didn't really work in my case so I tried commenting the $cfg['Servers'][$i]['hide_db'] = ' ' line, as its only purpose is to hide the "default" DBs used to make the whole system function correctly. When I did, all the databases showed in the PhpMyAdmin dashboard.

DISCLAIMER: Using this method allows you to DROP and ALTER system databases, which can result in PhpMyAdmin not working anymore. If you ever need to comment this line, be sure not to ALTER any of the said databases afterwards.

Reminder: the databases which must remain untouched are :

information_schema
mysql
performance_schema
test
phpmyadmin

answered Aug 14, 2017 at 8:12

ilomax

5681 gold badge4 silver badges24 bronze badges

Collectives™ on Stack Overflow

Can't see created databases

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related