List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:October 2 1999 8:12pm
Subject:Re: adding users to mysql is impossible!
View as plain text  
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
Thread
adding users to mysql is impossible!Jeffrey Greer2 Oct
  • Re: adding users to mysql is impossible!Jeffrey Greer2 Oct
    • Re: adding users to mysql is impossible!Paul DuBois2 Oct
  • Re: adding users to mysql is impossible!Jeffrey Greer2 Oct
  • Input from stringkevin12 Dec