469,126 Members | 1,295 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,126 developers. It's quick & easy.

GRANT query not working properly in MySQL Query Browser.

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

Expand|Select|Wrap|Line Numbers
  1.      GRANT ALL
  2.       ON newDB.*
  3.       TO 'test'@'localhost'
  4.       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)
Sep 23 '07 #1
2 2824
Atli
5,058 Expert 4TB
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?
Sep 23 '07 #2
Atli
5,058 Expert 4TB
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
Sep 23 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Bruce A. Julseth | last post: by
4 posts views Thread by Joe | last post: by
reply views Thread by Charles Cantrell | last post: by
reply views Thread by Charles Cantrell | last post: by
6 posts views Thread by Xerxes | last post: by
reply views Thread by Andreas Falck | last post: by
reply views Thread by Murphy | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.