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 '[EMAIL PROTECTED]' 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 '[EMAIL PROTECTED]' IDENTIFIED BY 'password' WITH
 GRANT OPTION;
Note the ' before and after [EMAIL PROTECTED]

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


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]