Page 1 of 1

Delete user from database

Posted: Thu Jul 15, 2010 2:43 pm
by 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!

Re: Delete user from database

Posted: Fri Jul 16, 2010 1:48 am
by VladSun
Try to REVOKE ALL the user privileges before DROP USER user.