MySQL DROP user --- how to

fhleung · 08-15-2007, 05:03 AM

If I want to delete an account, a user from one of the databases

I login as root by
mysql -u root databasename

This is the user tables
If I DROP USER username from mysql database

Code:

mysql>SELECT host,user,password FROM user ;

+-----------+-----------------+------------
| host      |user             |password   |
-------------------------------------------
|localhost  |root             |
|localhost  |admin            |
|%          |admin@localhost  |xxxxxxxxxxx|
|%          |someone@localhost|xxxxxxxxxxx|
-------------------------------------------

Error would be 
ERROR 1396 (HY000): Operation DROP USER failed for "xxx user"

How can I delete the user (the last two rows)
with host = '%'

Please help

GATTACA · 08-15-2007, 10:27 AM

First try

Code:

SELECT host,users,password FROM user WHERE host = '%'

if that returns the rows you want to remove do

Code:

DELETE * FROM user WHERE host = '%'