Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

MySQL not showing databases created in phpMyAdmin

I'm trying to build a database for my server in phpmyadmin but when I finish building it I can't access it using PHP and it won't show when I list the databases in MySQL. But when I create a database in mySql it shows up in phpmyadmin. Also I'm running phpmyadmin version 4.0.3, and theres a statement at the bottom of the page saying The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. To find out why click here.

Thanks!

like image 969
t3po7re5 Avatar asked Jan 03 '14 17:01

t3po7re5


2 Answers

I just had the problem, and realized that I was creating database with names with '_test' suffixes.

It happens that phpmyadmin has a feature to hide some DBs. To change that behaviour, you can navigate to : settings > features > general > Hide databases

By default, hiddent databases have these patterns : information_schema|mysql|performance_schema|test|phpmyadmin

like image 75
Tanzaho Avatar answered Oct 16 '22 06:10

Tanzaho


If you Still don't see it, Try to logout and then log in again to cPanel or PHPMyAdmin. It worked for me.

like image 20
JackSparrow Avatar answered Oct 16 '22 06:10

JackSparrow