Cannot view created databases

Question

I have two problems with EasyPHP (possibly related).

1) If I create a database in PhpMyAdmin, I cannot see it in the navigation bar or on the "Database" page. the database exists because I can query it, and it conflicts with other CREATE statements (with the same name). I assumed that this is a configuration (permission?) Problem, Therefore ...

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

I am using win8.

Thank.

EDIT: I tried updating PhpMyAdmin 4.1.12, but nothing happened.

Answer 1

I finally found a solution! In the configuration file, config.inc.phpI 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 great!

Answer 2

if you create a database with the string "test" in it, it will be hidden due to the string in the accepted answer. I removed the "test" from this line

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

and a database appeared.

Answer 3

, , , $cfg['Servers'][$i]['hide_db'] = ' ', "" , . , PhpMyAdmin.

DISCLAIMER: Using this method, you can use system databases DROPand ALTER, which can lead to the fact that PhpMyAdmin is no longer working. If you ever need to comment on this line, don't forget to subsequently ALTER from the specified database.

Reminder: The databases that should remain intact are as follows:

• INFORMATION_SCHEMA
• MySQL
• performance_schema
• test
• Phpmyadmin