CODEWITHSUNDEEP
phpsqlubuntuamazon-ec2phpmyadmin
t3po7re5
t3po7re5

Reputation: 211

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!

Upvotes: 6

Views: 45004

Answers (4)

Destiny Alabi
Destiny Alabi

Reputation: 81

This is pure permission issue. If you logged in without specifying the user, you won't see all the databases just like @t3po7re5 mentioned. What you should do is specify root user in your command.

mysql -uroot -p

It will prompt you to then enter the password. this is the default password if you have not specified or changed the default root password depending on the local server you are using.

Upvotes: 0

Oz Solomon
Oz Solomon

Reputation: 3044

This sounds like a permissions issue. I'd guess that your phpMyAdmin is connecting to MySQL as root (or another user with the superuser privilege) and can therefore see all databases. Your app is probably connected using a different, lower privileged user.

Try running select user(); from your app and from phpMyAdmin and you will know for sure.

Assuming your app is running with a different user, you will need to add privilages for it to access the database you create. Please read the section titled Assigning privileges to user for a specific database in the phpMyAdmin documentation.

Upvotes: 6

JackSparrow
JackSparrow

Reputation: 958

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

Upvotes: 12

Tanzaho
Tanzaho

Reputation: 1372

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

Upvotes: 16

Related Questions