got it. thanks.
t. hiep
On Tue, 4 Mar 2008, Dan Rogart wrote:
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]
