If you want to remove all the privileges and start totally from scratch do the following:
Revoke all privileges on database level:
REVOKE ALL PRIVILEGES ON dbname.* FROM 'username'@'hostname';
Drop the user:
DROP USER 'username'@'hostname';
Above procedure will entirely remove mysql user from your instance, this means you can recreate him from scratch.
Revoke all privileges on database level:
REVOKE ALL PRIVILEGES ON dbname.* FROM 'username'@'hostname';
Drop the user:
DROP USER 'username'@'hostname';
Above procedure will entirely remove mysql user from your instance, this means you can recreate him from scratch.
No comments:
Post a Comment