That error occurs when the user has already been dropped - so it's good news :).
You can check for users with blank user names and/or blank passwords by querying the mysql.user table: select user,host,password from mysql.user where user = '' or password = ''; Those are the users you should consider dropping or assigning passwords to. Hope that helps, Dan On 3/4/08 9:57 AM, "Hiep Nguyen" <[EMAIL PROTECTED]> wrote: > On Tue, 4 Mar 2008, Dan Rogart wrote: > >> You should definitely consider getting rid of them, otherwise people can log >> in to MySQL from any host with no credentials. >> >> They are created during installation by the mysql_install_db script. >> >> This tells you how to remove them: >> http://dev.mysql.com/doc/refman/5.0/en/default-privileges.html > > i followed the instruction and typed: > mysql> DROP USER ''; > ERROR 1396 (HY000): Operation DROP USER failed for ''@'%' > mysql> DROP USER ''@'localhost'; > Query OK, 0 rows affected (0.00 sec) > > and > mysql> DROP USER ''@'localhost'; > ERROR 1396 (HY000): Operation DROP USER failed for ''@'localhost' > > what's wrong here??? > t. hiep -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
