GRANT query not working properly in MySQL Query Browser.

[stmfc]

i have a problem with user creation for mysql db
i think the problem stems from string style.

     GRANT ALL
      ON newDB.*
      TO 'test'@'localhost'
      IDENTIFIED BY 'test';

i am using mysql query browser, and i got the following error:

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 'GRANT ALL
ON newDB.*
TO 'test'@'localhost'
IDENTIFIED BY 't' at line 5

versions of the binaries that i am using are as follows
MySql version: 5.0.45
MySql Query Browser version:
1.2.12 (i got this browser from MySQL GUI Tools bundle 5.0)

[Atli]

Hi.

I tested that query on MySQL Query Browser (version 1.2.12) on my localhost.
Worked fine.

The error you are getting would suggest that there may be something else in front of the query you posted.

Are you sure this is the exact query you are using?

[Atli]

I've changed the title of this thread to better describe it's topic.
Using good, descriptive titles that follow the Posting Guidelines will increase your chances of getting you questions answered!

Moderator