Aftab Khan [EMAIL PROTECTED] wrote on 12/28/2005 02:15:33 PM:
Can some one please tell me what I am doing wrong here I have
installed
and configured users in the database. I am using ODBC driver to logon.
When I use the password, it does not work but surprisingly the logon is
allowed without a password. I have tried to use MySQL Administrator to
logon remotely but same thing. I reset user's password and Flushed but
still could not get the logon with blank password go away. Any help is
appreciated.
Depending on how you installed MySQL, you may or may not have performed
this step of the installation process:
http://dev.mysql.com/doc/refman/4.1/en/default-privileges.html
It sounds to me that you have the anonymous account still in your
mysql.user table.
Try this:
SELECT id, user, host, password from mysql.user;
You should be able to identify the odd account pretty easily. Just DELETE
the account and FLUSH PRIVILEGES again and you should no longer be able to
login without both a user name and a password.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine