MySQL syntax error 1

[kleinicus]

MySQL 4.1 installation on Windows 2000 server is giving me headaches. I know I should install it on Linux, but this is what I decided to do.

Anyway, I'm trying to install a Bugzilla server. It requires MySQL, and part of the instructions provided are to enter the following command into the SQL command line:

GRANT SELECT, INSERT,
UPDATE, DELETE, INDEX, ALTER, CREATE, LOCK TABLES,
CREATE TEMPORARY TABLES, DROP, REFERENCES ON bugs.*
TO bugs@localhost IDENTIFIED BY '$db_pass';

The $db_pass variable is defined in the BugZilla localconfig file. The instructions say that this command is supposed to create the bugs user in MySQL and assign the specified privileges, but it gives me a syntax error. I even tried the following:

GRANT ALL PRIVILEGES TO bugs@localhost IDENTIFIED BY XXXX;

Obviously, where XXXX is our password. Any ideas what's going on here?

 

[sleipnir214]

Knowing what the syntax error said would make it a lot easier to help you.

At first glance, "bugs@locahost" would probably work better as "bugs@'localhost'"

Also, is the password for this user going to literally be the string "$db_pass"? If no, I recommend that you substitute the real password for "'$db_pass'".


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[kleinicus]

Okay, here's what I did...

GRANT ALL PRIVILEGES ON *.* TO bugs@'localhost' IDENTIFIED BY XXXX;

Where XXXX is our password. The following error is returned...

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'XXXX' at line 1

Thanks in advance!

 

[kleinicus]

Thanks for the help. I tried surrounding the password with single quotes and that worked.