After updating php version in XAMPP I'm facing Fatal Error in http://localhost/phpmyadmin/

Question

For the New Laravel project, I need to update the PHP version using XAMPP, After the update, the PHP version and apache folder when I start apache and MySQL from the XAMPP control panel this working but I open localhost/phpmyadmin/ it shows me fatal error and doesn't show the database.

Fatal error: Uncaught mysqli_sql_exception: You are not using binary logging in C:\xampp\phpMyAdmin\libraries\classes\Dbi\DbiMysqli.php:199 Stack trace: #0 C:\xampp\phpMyAdmin\libraries\classes\Dbi\DbiMysqli.php(199): mysqli->query('SHOW MASTER LOG...', 0) #1 C:\xampp\phpMyAdmin\libraries\classes\DatabaseInterface.php(316): PhpMyAdmin\Dbi\DbiMysqli->realQuery('SHOW MASTER LOG...', Object(mysqli), 1) #2 C:\xampp\phpMyAdmin\libraries\classes\DatabaseInterface.php(1869): PhpMyAdmin\DatabaseInterface->tryQuery('SHOW MASTER LOG...', 256, 1, false) #3 C:\xampp\phpMyAdmin\libraries\classes\Menu.php(573): PhpMyAdmin\DatabaseInterface->fetchResult('SHOW MASTER LOG...', 'Log_name', NULL, 256, 1) #4 C:\xampp\phpMyAdmin\libraries\classes\Menu.php(107): PhpMyAdmin\Menu->_getServerTabs() #5 C:\xampp\phpMyAdmin\libraries\classes\Menu.php(70): PhpMyAdmin\Menu->_getMenu() #6 C:\xampp\phpMyAdmin\libraries\classes\Header.php(445): PhpMyAdmin\Menu->getDisplay() #7 C:\xampp\phpMyAdmin\libraries\classes\Response.php(323): PhpMyAdmin\Header->getDisplay() #8 C:\xampp\phpMyAdmin\libraries\classes\Response.php(336): PhpMyAdmin\Response->_getDisplay() #9 C:\xampp\phpMyAdmin\libraries\classes\Response.php(495): PhpMyAdmin\Response->_htmlResponse() #10 [internal function]: PhpMyAdmin\Response->response() #11 {main} thrown in C:\xampp\phpMyAdmin\libraries\classes\Dbi\DbiMysqli.php on line 199

Bonestorm · Accepted Answer · 2022-10-07 04:24:27Z

4

I had this exact same issue and I have spent many hours trying to figure this out, so it is as simple as this.

Once you have upgraded your php. (In my case I upgraded to php 8.1.10)

Make a copy of your phpMyAdmin folder renaming it different than the current value that it has.
Download phpMyAdmin 5.2.0 or higher.
Unzip the file, and then copy it into your xampp folder replacing the old phpMyAdmin folder.
Inside the new folder create the file config.inc.php and paste inside there the data that is in config.inc.php located in your old phpMyAdmin folder.
Thats it!

answered Oct 7, 2022 at 4:24

Bonestorm

3793 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Asadullah AbdulJabbar Over a year ago

Thank you so much i am facing 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."

Asadullah AbdulJabbar Over a year ago

this is due to root user in xampp>phpMyAdmin>config.inc.php

Kristian · Accepted Answer · 2022-04-21 12:08:48Z

2

I feel the main issue is that your tried to upgrade only php instead of the whole Xampp Bundle. Either you should install complete xampp again or you should upgrade phpMyAdmin manually too as this will fix the php compatibility issues.

edited Apr 21, 2022 at 12:08

Kristian

3,5113 gold badges31 silver badges53 bronze badges

answered Apr 20, 2022 at 11:08

Harsh Raj Dubey

1194 bronze badges

Collectives™ on Stack Overflow

After updating php version in XAMPP I'm facing Fatal Error in http://localhost/phpmyadmin/

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related