I decided to clean up a bit my MySQL obsolete users. I use to test free software every now and then and often in the hurry I forgot to clean up the respective soft database and created user in database/table mysql.user.
This is how this tiny article get born. Deleting users in version MySQL 5.0 and higher use command:
mysql> DROP USER username@localhost;
On older MySQL versions; 3.x / 4.x the SQL query is a bit longer:
mysql> DELETE FROM user WHERE User= 'type_your_user_name_here' AND Host= 'localhost'; mysql> FLUSH PRIVILEGES;
Well that's all, now user is wiped out, Enjoy 🙂