phpMyAdmin configuration storage is not completely....

[bjh]

What is this error??

The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. Find out why.
Or alternately go to 'Operations' tab of any database to set it up there.

It was working fine earlier today and I've not made any changes to the configuration files in a while.

When I got to the 'Operations' tab, there is an alert box that says 'Create a database named 'phpmyadmin' and setup the phpMyAdmin configuration storage there'. When I click on the 'Create' link nothing happens.
How can I fix this? I did try selecting all the tables in the 'phpmyadmin' database and from the drop down menu select 'Repair tables' but that didn't help.

Do I have to reinstall XAMPP again?

[JJ_Tagy]

It's not an error - just a warning/notice. Plenty of discussion about it.

search.php?keywords=configuration+storage

[bjh]

I get an error trying to access the database with the website I'm developing saying Error : SQLSTATE[HY000] [1044] Access denied for user 'dbUser'@'localhost'. When I try to login to phpMyAdmin with that user I don't see the database listed in the list of databases on the left hand side. All I see is information_schema. When I login as root I get the same errors but I do see the database that I created in the list. So I did a export of that so now I have a backup SQL version and thinking starting over with a fresh reinstall of XAMPP and then import my database again.

Would there be an easier way to solve this?

[JJ_Tagy]

Looks like you created a database user and a database, but didn't grant any permissions to that user on the database.

In the MySQL shell, you can log in as root and grant those privileges:

Code: Select all

GRANT ALL PRIVILEGES ON dbname.* TO 'dbUser'@'localhost';
FLUSH PRIVILEGES;

[bjh]

I had granted all privileges to that user and everything was working fine earlier today and I didn't touch any of the configuration files.

[bjh]

when i tried to re-grant the privileges, I got some kind of checksum error. I exited from XAMPP and tried to restart it and now MySQL won't start. So I guess I'll have to reinstall.

[bjh]

After doing a reinstall everything seemed back to normal and then I get the same error again out of the blue yesterday. Googled it and tried a few of the suggestions I found in the links, with some success. Later in the day when I ran XAMPP i got the same error again. I am getting this error more frequently recently and not sure why. The only time I've touched the config file for phpmyAdmin is after it has been installed and I add the passwords to 'root' and 'pma'. I have tried running it without adding a password to 'pma' and I still get that error.

[shawnw]

I am having the same exact issue. Has there been any solution?