DELETE FROM mysql.user WHERE user=''; FLUSH PRIVILEGES; Rolando A. Edwards MySQL DBA (CMDBA)
155 Avenue of the Americas, Fifth Floor New York, NY 10013 212-625-5307 (Work) 201-660-3221 (Cell) AIM & Skype : RolandoLogicWorx redwa...@logicworks.net http://www.linkedin.com/in/rolandoedwards -----Original Message----- From: Carlos Mennens [mailto:carlosw...@gmail.com] Sent: Thursday, March 11, 2010 11:21 AM To: MySQL Subject: Error Removing Anonymous Accounts I installed MySQL 5 today and started by setting up root passwords for all three root accounts: mysql> select User, Password, Host, Create_priv from user; +------+-------------------------------------------+-----------+-------------+ | User | Password | Host | Create_priv | +------+-------------------------------------------+-----------+-------------+ | root | *3B657EF5C969760D3CF4E42931FDCE507F26D2A1 | localhost | Y | | root | *3B657EF5C969760D3CF4E42931FDCE507F26D2A1 | ghost | Y | | root | *3B657EF5C969760D3CF4E42931FDCE507F26D2A1 | 127.0.0.1 | Y | | | | localhost | N | | | | ghost | N | +------+-------------------------------------------+-----------+-------------+ Now my question is when I follow this 'Anonymous Account Removal' guide: http://dev.mysql.com/doc/refman/5.0/en/default-privileges.html I get the following error: mysql> DROP USER ''; ERROR 1396 (HY000): Operation DROP USER failed for ''@'%' Any help is greatly appreciated! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=redwa...@logicworks.net
