Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
1

Latest XAMPP version has phpMyAdmin problem

Participant ,
Oct 21, 2015 Oct 21, 2015

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.

11.2K
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

Guru , Oct 21, 2015 Oct 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/

Translate
Guru ,
Oct 21, 2015 Oct 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/

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Participant ,
Oct 21, 2015 Oct 21, 2015

Thanks Rob for the link and info

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Nov 21, 2022 Nov 21, 2022
LATEST

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?

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines