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=arch...@jab.org