>I am creating a user, but I can't log in as that user from localhost
>('mysql -u me -p' fails)
>here is the insert query:
>mysql> insert into user
> -> (host, user, password, select_priv, insert_priv, update_priv,
>delete_priv, create_priv, drop_priv, alter_priv)
> -> values('%','me',password('XXX'),'Y','Y','Y','Y','Y','Y','Y');
>Query OK, 1 row affected (0.01 sec)
>I think the problem is with the host field, but I'm not 100% sure. when I
>try to log in it gives me:
>$ mysql -u me -p
>ERROR 1045: Access denied for user: 'me@localhost' (Using password: YES)
>I've also tried specifying the exact hostname in place of the '%', but
>that didn't work..
>I'm taking the creation string RIGHT out of my ORA mysql book..
>do i need to add something more somewhere else?
>also, does it matter whether I use ' or " ?
If you have an entry with localhost as the host and a blank user value,
delete it from the user table (and db table if there's one there),
flush the privileges, and try it again.
Paul DuBois, paul@stripped