1

I have setup WAMP which I managed by using a tutorial and everything seems fine... I am logging into mysql as the root user with full privileges granted and I am able to create databases in mysql and view them by using SHOW DATABASES; so far so good !

...However...

enter image description here

When I access phpMyAdmin and go to the databases section, there are no databases which I have created in mysql, even though phpMyAdmin shows the Database server as User:root@localhost which is the same user I am accessing mysql with.

This situation is also the same when reversed, I can create a database as the root user in phpMyAdmin but the database will not show in mysql when I am logged in as root user and use SHOW DATABASES;

i have tried every soution available ONLINE .. most of them saying about

$cfg['Servers'][$i]['hide_db'] = '';

i have done that too .... but nothing seems to work.... plzzzz help

1

The database server that you are accessing using phpmyadmin and the mysql monitor (command line client) are different. If you look at the versions, phpmyadmin is accessing a 5.5.1-m2-community version, while you are accessing 5.6.17-community on the command line.

Either you are accessing a remote server or you have two separate installations of mysql on the server. If the later, use netstat -aon | more or the Task Manager to locate the mysql processes running on your machine (and on which port they are listening).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.