Re: Error 1044 & Error 2003 on 4.0.13 and RH9

[Kevin H. Phillips]

Hi, Nils
Here's what I get:


mysql> GRANT ALL ON *.* TO 'root@localhost' IDENTIFIED BY 'password' 
WITH GRANT OPTION;
ERROR 1047: Unknown command
mysql>


I'm sorry I should have asked before if the apostrophes were necessary. 
  And, the first one is an apostrophe and not the little tilted 
apostrophe (not sure of the exact term for it).

Thanks,
Kevin

Nils Valentin wrote:
> Try this:
> 
> mysql> GRANT ALL ON *.* TO 'root@localhost' IDENTIFIED BY 'password' WITH
>  GRANT OPTION;
> 
> Note the ' before and after root@localhost.
> 
> However it is a bit unusual that you dont get an error 1064  - wrong sql 
> syntax. How did you install the mysql server (rpm or tar.gz ) ?
> 
> Best regards
> 
> Nils Valentin
> Tokyo/Japan