Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

phpmyadmin cannot delete user

After upgrading to Debian Stretch phpmyadmin no longer give me the option in the User accounts tab to delete database users. Mariadb and phpmyadmin was installed with standard Debian packages and I access phpmyadmin with and administrative user that I think received the necessary privileges. The only option available is export which I hereby use:

GRANT ALL PRIVILEGES ON . TO 'admuser'@'%' IDENTIFIED BY PASSWORD '*my_password_hash' WITH GRANT OPTION;

Did something change in phpmyadmin, no longer showing or allowing this? Is there another privilege or mariadb setting that I should change?

like image 327
ñull Avatar asked Jan 29 '23 17:01

ñull


2 Answers

Sorry, I'm getting older. It is there further down under "Add user account"!

PhpMyAdmin how to remove user accounts

like image 72
ñull Avatar answered Feb 12 '23 00:02

ñull


For those even older and more blind, like me, it's the 'go' button on the right, under 'Remove selected user accounts'

like image 42
lockstock Avatar answered Feb 12 '23 01:02

lockstock