Note: forwarded message attached.


Yahoo! FareChase - Search multiple travel sites in one click.
--- Begin Message ---


Michael Stassen <[EMAIL PROTECTED]> wrote:
ali asghar torabi parizy wrote:
> hi to all
> i have a problem when i trying to delet a user by drop user directive
> ***************************
> drop user atp;
> Can't drop one or more of the requested users
> ***************************
> i add this user by crant:
> ***************************
> GRANT ALL PRIVILEGES ON *.* TO 'atp'@'%' IDENTIFIED BY 'nowayforyou' WITH GRANT OPTION;
> ***************************

A user in mysql is the combination of username and hostname, so the user you
created is 'atp'@'%'. Hence, you need to

DROP USER 'atp'@'%';

Michael
********************************************
hi michael
i try to do it but it impossible.
error continued when i implement it :(
drop user [EMAIL PROTECTED];
Can't drop one or more of the requested users



Yahoo! FareChase - Search multiple travel sites in one click.
--- End Message ---
-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to