What's wrong with mysql 4.0.9?

2003-01-25 Thread Octavian Rasnita 
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';

All went right but I can't access mysql using this newly created account.

I can see this new account in mysql.user and there is a password set for it.

However, if I try:

mysql -u teddy -p
... and give that password it tells me that I don't have access to mysql.

Thanks.

Teddy,
Teddy's Center: http://teddy.fcc.ro/
Email: [EMAIL PROTECTED]



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: What's wrong with mysql 4.0.9?

2003-01-25 Thread 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

-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php