Linux Ask!

Linux Ask! is a Q & A web site specific for Linux related questions. Questions are collected, answered and audited by experienced Linux users.

Jan 022010

How to delete MySQL user?


1. Enter the MySQL shell using root account

mysql -u root -p mysql

2. Execute the SQL like the followings

DROP USER user1;

3. Now try to login using user1 account to check if account is removed

mysql -u user1 -p db1

 Leave a Reply



You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>