-----Ursprüngliche Nachricht-----
Von: Paul DuBois [mailto:paul@stripped]
Gesendet: Donnerstag, 17. Februar 2000 05:06
An: M. Erickson
Cc: mysql@stripped
Betreff: Re: user creation
>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
>Enter password:
>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 " ?
You must restart mysql (mysqladmn -u root -p restart) to make Your changes
work.
