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

Latest XAMPP version has phpMyAdmin problem

Participant ,
Oct 21, 2015 Oct 21, 2015

Copy link to clipboard

Copied

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.

Views

10.5K

Translate

Translate

Report

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/

Votes

Translate

Translate
Guru ,
Oct 21, 2015 Oct 21, 2015

Copy link to clipboard

Copied

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/

Votes

Translate

Translate

Report

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

Copy link to clipboard

Copied

Thanks Rob for the link and info

Votes

Translate

Translate

Report

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

Copy link to clipboard

Copied

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?

Votes

Translate

Translate

Report

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