I this section we will show you how you can remove the user from database. You can create new user and add permission using the grant privileges command. You have to use the revoke command to remove the user from database.
Usually you can connect to mysql through command prompt and issue the command. But other ways is to use the UI interfaces for MySQL. There are some free UI for MySQL also. You can also use the UI tool such as PHPMyAdmin to run the command if your server is hosted on Linux OS.
There is the list of tutorials related to this function:
To change privileges or remove the user from the database you can use the following comand:
revoke all privileges on *.* from 'username'@'hostname';
This way you can remove the user from MySQL database.
Posted on: February 16, 2005 If you enjoyed this post then why not add us on Google+? Add us to your Circles