trouble with mysql

[James]

  On 06/23/10 11:49, Harley Laue wrote:
> James wrote:
>> $  mysql -u amarokuser -h localhost -p
>> Enter password:
>> ERROR 1045 (28000): Access denied for user 'amarokuser'@'localhost'
>> (using password: YES)
> Did you create the user in mysql? If you've never administered mysql before,
> you may want to consider using the default method of mysqle instead of using
> an external mysql server.  Just a suggestion, feel free to search for how to
> create and mysql users if you really want to use the stand alone server.
I did:

CREATE DATABASE amarokdb;
GRANT ALL PRIVILEGES ON amarokdb.* TO 'amarokuser' IDENTIFIED BY 
'password'; FLUSH PRIVILEGES;

select * from mysql.user;

| %              | amarokuser | 
*2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19 | N           | N           | 
N           | N           | N           | N         | N           | 
N             | N            | N         | N          | N               
| N          | N          | N            | N          | 
N                     | N                | N            | 
N               | N                | N                | N              | 
N                   | N                  | N                | N          
| N            |          |            |             |              
|             0 |           0 |               0 |                    0 |