phpMyAdmin configuration storage is not completely....

Problems with the Windows version of XAMPP, questions, comments, and anything related.

phpMyAdmin configuration storage is not completely....

Postby bjh » 05. July 2020 22:09

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?
bjh
 
Posts: 13
Joined: 24. April 2020 06:06
XAMPP version: 7.4.4
Operating System: Windows 10 Pro 1909 64-bit

Re: phpMyAdmin configuration storage is not completely....

Postby JJ_Tagy » 05. July 2020 23:01

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

search.php?keywords=configuration+storage
JJ_Tagy
 
Posts: 783
Joined: 30. January 2012 13:44
XAMPP version: 5.5.15
Operating System: Windows 10 Pro x64

Re: phpMyAdmin configuration storage is not completely....

Postby bjh » 05. July 2020 23:56

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?
bjh
 
Posts: 13
Joined: 24. April 2020 06:06
XAMPP version: 7.4.4
Operating System: Windows 10 Pro 1909 64-bit

Re: phpMyAdmin configuration storage is not completely....

Postby JJ_Tagy » 06. July 2020 00:15

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;
JJ_Tagy
 
Posts: 783
Joined: 30. January 2012 13:44
XAMPP version: 5.5.15
Operating System: Windows 10 Pro x64

Re: phpMyAdmin configuration storage is not completely....

Postby bjh » 06. July 2020 00:36

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
 
Posts: 13
Joined: 24. April 2020 06:06
XAMPP version: 7.4.4
Operating System: Windows 10 Pro 1909 64-bit

Re: phpMyAdmin configuration storage is not completely....

Postby bjh » 06. July 2020 02:42

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
 
Posts: 13
Joined: 24. April 2020 06:06
XAMPP version: 7.4.4
Operating System: Windows 10 Pro 1909 64-bit

Re: phpMyAdmin configuration storage is not completely....

Postby bjh » 10. July 2020 02:29

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.
bjh
 
Posts: 13
Joined: 24. April 2020 06:06
XAMPP version: 7.4.4
Operating System: Windows 10 Pro 1909 64-bit

Re: phpMyAdmin configuration storage is not completely....

Postby shawnw » 08. November 2020 18:09

I am having the same exact issue. Has there been any solution?
shawnw
 
Posts: 1
Joined: 08. November 2020 18:08
XAMPP version: v3.2.4
Operating System: Windows


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 78 guests