At 2:28 PM -0500 10/2/99, Jeffrey Greer wrote:
>[posted and emailed]
>
>Thanks, but it still does not work:
>
>Here is what I have typed:
>
>>mysql -u root -p mysql
>
>mysql> GRANT ALL PRIVILEGES ON *.* TO test@"%"
>IDENTIFIED BY 'test$$*' WITH GRANT OPTION;
>Query OK, 0 rows affected (0.01 sec)
>
>
>At another command line I typed:
>
>> mysqladmin reload -u root -p<my password>
>
>I try to login and get this error
>
>>mysql -u test -p'test$$*'
>ERROR 1045: Access denied for user: 'test@localhost' (Using password:
>YES)
>
>I next killed all mysqld processes and restarted mysqld. Still does
>not work. I checked the tables with "SELECT * FROM user WHERE
>user='test';" "test" is in there.
I'll bet you're being bitten by the anonymous user entries.
Connect to mysql as root and run these statements:
mysql> DELETE FROM user where User="";
mysql> FLUSH PRIVILEGES;
Then try connecting as test. Bet it'll work.
--
Paul DuBois, paul@stripped
