From: Dan Rogart (dan.rogartrevolutionhealth.com)
Date: Tue Mar 04 2008 - 09:02:53 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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" <hiepee.ucr.edu> 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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]