How to delete a MySQL user ?

• 08 October 2021
• in: MySQL

Login to your server via SSH & access MySQL prompt, To delete a MySQL user.

Select the database mysql & follow the steps as given below. Here, the database is mysql. Replace the database name as required.

mysql> use mysql;
mysql> DELETE FROM user where user=’username’;
mysql> FLUSH PRIVILEGES;

Replace ‘username’ with the username of the user you want to delete. Also, Which has the user records stored select that table make sure you select the correct table. Then run this as the root user or an account that has appropriate privileges on the grant tables.