Remove Privileges

  1. Login to MySQL
    • mysql -uUSER -p
  1. Revoke privileges
    • REVOKE [type of permission] ON [database name].[table name] FROM ‘[username]’@‘localhost;
  1. Refresh the privileges in MySQL to apply changes
    • flush privileges;

Remove a user

  1. Login to MySQL
    • mysql -uUSER -p
  1. Remove a user
    • DROP USER ‘user’@‘localhost;
  1. Refresh the privileges in MySQL to apply changes
    • flush privileges;

Leave a Reply

Your email address will not be published. Required fields are marked *