MySQL remove User and Privileges

查詢使用者

SELECT User,Host FROM mysql.user;

移除使用者權限

Revoke all privileges on database level:

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

移除使用者

Drop the user 'phpmyadmin'@'localhost'

DROP USER 'phpmyadmin'@'localhost';