Geek Answers Handbook

MySQL Xammp Error

I get this error in my phpmyadmin after recently installing a new local xammp server. Can anyone help with this?

Warning in .\libraries\dbi\DBIMysqli.class.php#261 mysqli_query(): (HY000/1030): Got error 9 "Bad file descriptor" from storage engine MyISAM Backtrace .\libraries\dbi\DBIMysqli.class.php#261: mysqli_query( object, string 'SELECT * FROM `mysql`.`db` LIMIT 1', integer 0, ) .\libraries\DatabaseInterface.class.php#246: PMA_DBI_Mysqli->realQuery( string 'SELECT * FROM `mysql`.`db` LIMIT 1', object, integer 0, ) .\libraries\check_user_privileges.lib.php#46: PMA_DatabaseInterface->tryQuery(string 'SELECT * FROM `mysql`.`db` LIMIT 1') .\libraries\check_user_privileges.lib.php#395: PMA_checkRequiredPrivilgesForAdjust() .\libraries\List_Database.class.php#17: require_once(.\libraries\check_user_privileges.lib.php) .\libraries\PMA.php#17: require_once(.\libraries\List_Database.class.php) .\libraries\common.inc.php#1089: include_once(.\libraries\PMA.php) .\tbl_structure.php#14: require_once(.\libraries\common.inc.php)
+6
source share
5 answers

You can run this executable file: mysql_upgrade.exe , which is located inside this folder: XAMPP/mysql/bin .. I tried this and it worked.

+10
source

I also got this recently on a new installation.

  • Start MySQL from XAMPP or from the command line
  • Open the command line [Windows] + [r], enter "cmd", press [enter]
  • cd \ xampp \ mysql \ bin
  • mysql_upgrade.exe

I found this to happen when I do several mysqldump from MySQL servers and import them into MariaDB. The update checks all your mysql databases, corrects the rights of the table, fixes the names of tables and databases, updates the tables and resets.

+3
source

In old XAMPP packages, MySQL was used, in XAMPP 5.6.12 it was MySQL 5.6.26.

However, in the current XAMPP 5.6.14, they switched from MySQL to MariaDB 10.0.0.17.

An attempt to update the mysql database did not work correctly ("Unable to create table ..." / "Bad file descriptor"). While mysql_upgrade.exe was starting up, I had to pause execution regularly. This allowed him to get through.

+1
source

I tried the solution posted here, but it does not work (possibly due to Windows and MariaDB). I decided to make a “quick and dirty” fix.

I went to my xampp folder, then / phpmyadmin / libraries / dbi /

Open DBIMysql.class.php - find

 if (! $server)

should be around line 138, insert before if statement

 $user = "your phpmyadmin username"; $password = "your phpmyadmin password";

Save the file and use the control to restart MySQL (alias MariaDB). It basically just overwrites the user variables and password - it seems that the new MariaDB has a problem getting the password and username in this class. After I did this, no more errors occurred.

But, as I said, be careful because this is a very dirty decision;)

Hope this helps :)

+1
source

The solution to this run is as the administrator mysql_upgrade.exe, which is located inside this folder: XAMPP / mysql / bin .. I tried this and it works. Deepesh tripathi

+1
source

More articles:


All Articles