phpmyadmin / phpmyadmin/phpmyadmin
does not set a GRANT at the database level for a database user
Nobody has claimed this yet.
- Dominant language
- PHP
- Stars
- 7.9k
- Forks
- 3.6k
- Avg merge
- 4d 18h
- Merged PRs (30d)
- 36
Description
hello!
in MySQL 8
does not set a GRANT at the database level for a database user
when assigning privileges GRANT то database user at the database level
the installation request GRANT is completed - but the checkbox GRANT becomes inactive
phpMyadmin make sql reguest
REVOKE ALL PRIVILEGES ON phpmyadmin.* FROM 'new1'@'localhost'; GRANT ALL PRIVILEGES ON phpmyadmin.* TO 'new1'@'localhost'; ALTER USER 'new1'@'localhost' ;
and if you do it manually like this - then there are no problems
mysql -Bse "GRANT ALL PRIVILEGES ON \"$database"`.* TO '"$database"'@'localhost' WITH GRANT OPTION;"`
ubuntu22
MySQL 8.0.41-0ubuntu0.22.04.1
PHP: 8.1.2-1ubuntu2.20
phpMyadmin 5.1.1deb5ubuntu1
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Reproduce the privilege assignment in phpMyAdmin 5.1.1 with MySQL 8.0.41 on Ubuntu 22.04, then compare the generated SQL with the manual GRANT command shown in the report. Done means assigning database-level privileges applies the GRANT and the privilege checkbox remains active.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- mysql, php
- Domain
- authorization, databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 30/100