Remove manually (delete) the user from all the privilege tables: delete from columns_priv where user='carlos'; delete from db where user='carlos'; delete from procs_priv where user='carlos'; delete from tables_priv where user='carlos'; delete from user where user='carlos';
then a nice FLUSH PRIVILEGES; this should fix, let me know! Claudio 2009/9/30 Carlos Williams <carlosw...@gmail.com> > 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 > mysql> select User, Host from user; > +--------+------------+ > | User | Host | > +--------+------------+ > | carlos | localhost > | > | root | localhost | > +--------+------------+ > 2 rows in set (0.00 sec) > > mysql> drop user 'carlos'@'localhost'; > ERROR 1396 (HY000): Operation DROP USER failed for 'carlos'@'localhost' > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com > > -- Claudio
