mariadb: Remove user

list user

SELECT User,Host FROM mysql.user;

Verify grants for user you want to delete, and then revoke them

SHOW GRANTS FOR 'username'@'%';
REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'username'@'%';

Then drop user

DROP USER 'username'@'%';

38

Leave a Reply

Your email address will not be published.