Skip to main content
Inspiring
October 21, 2015
Answered

Latest XAMPP version has phpMyAdmin problem

  • October 21, 2015
  • 2 replies
  • 11502 views

I upgraded to XAMPP version 5.6.14 yesterday and using phpMyAdmin I get an error going to User accounts.  The analysis shows this sql query saying there are 5 unexpected closing brackets.  Here's the query:

(SELECT DISTINCT `User`, `Host` FROM `mysql`.`user` ) UNION (SELECT DISTINCT `User`, `Host` FROM `mysql`.`db` ) UNION (SELECT DISTINCT `User`, `Host` FROM `mysql`.`tables_priv` ) UNION (SELECT DISTINCT `User`, `Host` FROM `mysql`.`columns_priv` ) UNION (SELECT DISTINCT `User`, `Host` FROM `mysql`.`procs_priv` ) ORDER BY `User` ASC, `Host` ASC

It doesn't show in the above query, but phpMyAdmin shows all 5 right brackets as errors and thus you can not open the User accounts, which is a serious problem.

Anybody else seen this bug in the lastest XAMPP release that came out October 19th?  Sometimes it lets you into the User accounts and sometimes it throws this "fake" analysis and you can't get in.

This topic has been closed for replies.
Correct answer Rob Hecker2

Since phpMyAdmin is just a PHP program, you can download it, delete everything in the phpMyAdmin directory on your web root and replace it with the downloaded files.

https://www.phpmyadmin.net/downloads/

2 replies

Participant
November 21, 2022

Salut, effectivement je me retrouve dans cette situation ou je ne peux pas acceder au compte d'utilisateur avec une erreure qui s'affiche, mais que faire dans ce cas svp?

Rob Hecker2
Rob Hecker2Correct answer
Legend
October 21, 2015

Since phpMyAdmin is just a PHP program, you can download it, delete everything in the phpMyAdmin directory on your web root and replace it with the downloaded files.

https://www.phpmyadmin.net/downloads/

RR456Author
Inspiring
October 22, 2015

Thanks Rob for the link and info