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
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 ONphpmyadmin.* FROM 'new1'@'localhost'; GRANT ALL PRIVILEGES ONphpmyadmin.* 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