phpmyadmin / phpmyadmin/phpmyadmin

v. 5.2.1 displays errors messages as user accounts

Open
#18,647 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

affects/5.2 affects/6.0 Bug
Dominant language
PHP
Stars
7.9k
Forks
3.6k
Avg merge
4d 18h
Merged PRs (30d)
36

Description

Describe the bug

When clicking on the User accounts tab at the server level, multiple rows containing error messages in both the User name and Host name fields are displayed. Currently there are 820 such rows. Mixed in among them are the 16 actual user accounts, which are very difficult to find in the clutter.

To Reproduce

Click the User accounts tab at the server level

Expected behavior

I expect to see the 16 user accounts that actually exist in the mysql > user table.

Screenshots

Note: only the first 34 rows of the 836 total are visible in this screenshot:

pma 5 2 1 screenshot

Server configuration
  • Operating system: Windows 10 Pro
  • Web server: nginx/1.9.4
  • Database version: 10.1.6-MariaDB
  • PHP version: 8.1.20
  • phpMyAdmin version: 5.2.1
Client configuration
  • Browser: Brave v1.57.49, Chrome Version 116.0.5845.111, Microsoft Edge Version 116.0.1938.54
  • Operating system: Windows 10 Pro
Additional context

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by reproducing the problem from the server-level User accounts tab using the reported phpMyAdmin, MariaDB, and PHP versions, then compare the displayed rows with the mysql > user table. Done means the tab shows the actual user accounts without the error-message rows mixed into the results.

Written by the indexing model from the issue text.

Assessment

Tech stack
mariadb, mysql, php
Domain
database
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.