mysql remove user

Hi

How do i remove the user in the 5th row?

mysql> SELECT User, Host, Password FROM mysql.user;
+------------------+-----------+-------------------------------------------+
| User             | Host      | Password                                  |
+------------------+-----------+-------------------------------------------+
| root             | localhost | *xxx |
| root             | oscar     | *xxx |
| root             | 127.0.0.1 | *xxx |
| debian-sys-maint | localhost | *xxx |
|                  | localhost |                                           |
| anonymous        | localhost |                                           |
+------------------+-----------+-------------------------------------------+
6 rows in set (0.00 sec)

this user was called 'dave' and i thought i had deleted it by the drop user command but it seems not

thanks
andiejeAsked:
Who is Participating?
 
Randy DownsConnect With a Mentor OWNERCommented:
The drop user should have worked in any case, there doesn't appear to be a displayble user name. You might check it in a GUI like phpMyAdmin
0
All Courses

From novice to tech pro — start learning today.