Mysql Remove Privileges From User

February 24, 2021

Remove provileges

REVOKE ALL PRIVILEGES ON phpmyadmin.* FROM 'user'@'localhost';

Delete user

DROP USER 'user'@'localhost';

or

DELETE FROM mysql.user WHERE User = 'user' and Host = 'localhost';
FLUSH PRIVILEGES;
This work is licensed under a
Creative Commons Attribution-NonCommercial 4.0 International License.