Hello.
What version of MySQL are you using? In MySQL 5.0.15 it works fine: mysql> GRANT ALL PRIVILEGES ON *.* TO 'atp'@'%' IDENTIFIED BY 'nowayforyou' WITH GRANT OPTION; Query OK, 0 rows affected (0.00 sec) mysql> drop user atp; Query OK, 0 rows affected (0.00 sec) See: http://dev.mysql.com/doc/refman/5.0/en/drop-user.html 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; > *************************** > > > > > > --------------------------------- > Yahoo! FareChase - Search multiple travel sites in one click. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
