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:xamppphpMyAdminlibrariesclassesDbiDbiMysqli.php:199 Stack trace: #0 C:xamppphpMyAdminlibrariesclassesDbiDbiMysqli.php(199): mysqli->query('SHOW MASTER LOG...', 0) #1 C:xamppphpMyAdminlibrariesclassesDatabaseInterface.php(316): PhpMyAdminDbiDbiMysqli->realQuery('SHOW MASTER LOG...', Object(mysqli), 1) #2 C:xamppphpMyAdminlibrariesclassesDatabaseInterface.php(1869): PhpMyAdminDatabaseInterface->tryQuery('SHOW MASTER LOG...', 256, 1, false) #3 C:xamppphpMyAdminlibrariesclassesMenu.php(573): PhpMyAdminDatabaseInterface->fetchResult('SHOW MASTER LOG...', 'Log_name', NULL, 256, 1) #4 C:xamppphpMyAdminlibrariesclassesMenu.php(107): PhpMyAdminMenu->_getServerTabs() #5 C:xamppphpMyAdminlibrariesclassesMenu.php(70): PhpMyAdminMenu->_getMenu() #6 C:xamppphpMyAdminlibrariesclassesHeader.php(445): PhpMyAdminMenu->getDisplay() #7 C:xamppphpMyAdminlibrariesclassesResponse.php(323): PhpMyAdminHeader->getDisplay() #8 C:xamppphpMyAdminlibrariesclassesResponse.php(336): PhpMyAdminResponse->_getDisplay() #9 C:xamppphpMyAdminlibrariesclassesResponse.php(495): PhpMyAdminResponse->_htmlResponse() #10 [internal function]: PhpMyAdminResponse->response() #11 {main} thrown in C:xamppphpMyAdminlibrariesclassesDbiDbiMysqli.php on line 199
2
Answers
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.
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)