Old thread but, IMO the best place for this comment.
In order to get PHP 8.1 on local machine I needed to upgrade my Xampp install. I honestly don't recall whether my version was the old style or via the windows installer. I am saying I may have created all my problems. But am going to report the facts so that it may help someone because there are hundreds of pages out there that don't help with this issue.
I should also say that I visit localhost (127.0. 0.1) on both my local machine and on a VPS. On the vps phpmyadmin does not have the authority to create or drop a DB. Those functions are manged from the Admin control panel (DirectAdmin).
After the install and updating root password all my sites worked just fine. Phpmyadmin threw 2 very confusing error messages.
Error code 200
Error text: OK (rejected)
it seems that the connection to the sever has been lost
Please check your network connectivity and server status.
Click to dismiss this notification
This first error you can spends days reading all those pages I mentioned. My advice is to try a different browser before you do anything else. The causes that are not mentioned on those pages are browser cached pages, cookies and permissions. Clear all cookies for localhost. Clear the cache for localhost and make sure localhost has permission to set cookies. All of this can be done in the browser settings.
The second problem that I encountered was:
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.
When I followed that advice all I saw was drop database highlighted in red. The solution was simple. Somehow root did not have all permissions on the database. Running a simple command line while connected to MariaDB will solve that for you. To grant GRANT ALL PRIVILEGES ON ALL databases TO 'root'@localhost with the password simply execute this command.
Code: Select all
GRANT ALL PRIVILEGES ON *.* TO 'root'@localhost IDENTIFIED BY 'your_password';
I hope this saves at least one person a lot of miserable wasted time.