How to delete Mysql user?

Hi. How to delete mysql user using query? Please tell me. Thanks in advance.

 

I'd recommend looking in the manual, my friend. Be aware you can very quickly make a mess of things in mysql if you are unclear how things work.

Here...

DELETE FROM user where user='username';
FLUSH PRIVILEGES;

Code (markup):

replace 'username' with the username of the user you wish to delete. Also, you have to run this as the root user or some other account that has appropriate privileges on the grant tables.

 

thanks.........