I just created a generic test user account on MySQL 5.1 and now for some reason I am unable to remove him...
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.01 sec) I obviously from above have a user name 'carlos'@'localhost' & when I try to delete him, I get the following: mysql> drop user 'carlos'@'localhost'; ERROR 1396 (HY000): Operation DROP USER failed for 'carlos'@'localhost' Can someone please help me understand why I am unable to remove this user from MySQL? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org