Re: What's wrong with mysql 4.0.9?

[Paul DuBois]

At 11:35 +0200 1/25/03, Octavian Rasnita wrote:
>Hi all,
>
>I have mysql 4.0.9 gama for Windows installed and I have a problem because I
>cannot set a password for a username.
>
>I've tried:
>
>mysql> grant all on *.* to 'teddy@localhost' identified by 'password';

The user name and hostname must be quoted separately: 'teddy'@'localhost'



sql, query