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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
