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!
Delete user from database
Moderator: General Moderators
-
canadian_angel
- Forum Commoner
- Posts: 31
- Joined: Fri Jun 11, 2010 3:13 pm
Re: Delete user from database
Try to REVOKE ALL the user privileges before DROP USER user.
There are 10 types of people in this world, those who understand binary and those who don't