Delete user from database...........

[canadian_angel]

I added a user to my database ijdb for a project i am doing and have tried repeatedly to delete them with no luck. The user is jess;

mysql>GRANT SELECT ON ijdb.*

->TO jess@"%.host.net"

->IDENTIFIED BY "jessrules";

mysql>GRANT UPDATE (name, email) ON ijdb.author

->TO jess@"%.host.net";

 

I have tryed DELETE, and DROP USER.............etc.

no luck.

 

Can someone please help!

[premiso]

Try:

 

DELETE FROM mysql.user WHERE User = 'jess'

 

You can limit that further by adding the host or database, do a

DESC mysql.user

 

For other fields you could query by.

[fenway]

Yes, but you should probably use the administrative commands to do this, since playing with the mysql internal database it just a bad idea.

[premiso]

since playing with the mysql internal database it just a bad idea.

 

It is a bad idea, I would agree. But I have had issues with Drop USER messing up and the only way to remediate was to manually delete it. Since he hinted that he tried the DROP USER command to no avail, I figured that he needed another means of doing it.

[Pikachu2000]

If you are using MySQL version 4.1.1 to 5.0.2, see the MySQL manual for DROP USER syntax. You have to revoke all privileges before performing the DROP.