Database is present but not visible in phpmyadmin

Asked May 02 '17 at 11:02

Active May 02 '17 at 17:20

Viewed 414 times

I imported a database from my godaddy server to a local WAMP installation. Everything worked and then I restarted my machine.

Now PHPMyAdmin don't show the database that I imported, but I know its there because my application based on this database is working.

Why my db is not visible in phpmyadmin

EDIT I ran show databases in command prompt of MySQL. its showing me my database. But not present in phpmyadmin

edited May 02 '17 at 17:20

RiggsFolly

asked May 02 '17 at 11:02

Vaibhav Jain

Maybe a permission problem – Jens May 02 '17 at 11:03
where to check it? – Vaibhav Jain May 02 '17 at 11:06
Login as root and check if you can see the database – Jens May 02 '17 at 11:13
doing the same, using root user – Vaibhav Jain May 02 '17 at 11:13
@Jens `WAMPServer` = `Windows` – RiggsFolly May 02 '17 at 17:21
1

It sounds a little like you have 2 MySQL Servers running, or you loaded your database to a MySQL Server off your box – RiggsFolly May 02 '17 at 17:25
@RiggsFolly i know – Jens May 02 '17 at 19:16
@RiggsFolly Yep, I found two MySQL servers running on the box. PhpMyAdmin was pointing to the another server. – Vaibhav Jain May 03 '17 at 10:51

0 Answers0