What version of mysql a you using? Drop user works differently for versions before 5.0.2.
You could just remove the user from the mysql.user table with a delete statement. Regards John Daisley Mobile +44(0)7812 451238 Email j...@butterflysystems.co.uk Certified MySQL 5 Database Administrator (CMDBA) Certified MySQL 5 Developer Cognos BI Developer ----------------------- Sent from HP IPAQ mobile device. -----Original Message----- From: Carlos Williams <carlosw...@gmail.com> Sent: Wednesday, September 30, 2009 12:47 PM To: mysql@lists.mysql.com Subject: Re: Unable To Remove User On Tue, Sep 29, 2009 at 11:36 PM, mos <mo...@fastmail.fm> wrote: > Why don't you just say "Drop User carlos"? > Also are you logged in as root? In my original message to the board I demonstrated the error I get on my server when I attempt to run the 'drop user 'carlos'@'localhost'; command. Why can't I remove this user from MySQL? I am logged in as root on both Linux and MySQL so I don't see why I can't remove 'carlos'@'localhost'. It's as if MySQL doesn't understand this user exist. He might not exist because I can't login as him however I need this entry removed from the "user" table. [r...@tiger ~]# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 9 Server version: 5.1.38 Source distribution mysql> show grants for 'carlos'@'localhost'; ERROR 1141 (42000): There is no such grant defined for user 'carlos' on host 'localhost' mysql> use mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed [The entire original message is not included] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
