Delete user from database

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
canadian_angel
Forum Commoner
Posts: 31
Joined: Fri Jun 11, 2010 3:13 pm

Delete user from database

Post 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!
User avatar
VladSun
DevNet Master
Posts: 4313
Joined: Wed Jun 27, 2007 9:44 am
Location: Sofia, Bulgaria

Re: Delete user from database

Post by VladSun »

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
Post Reply