472,145 Members | 1,474 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,145 software developers and data experts.

GRANT query not working properly in MySQL Query Browser.

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 2914
5,058 Expert 4TB

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
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!

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
reply views Thread by Saiars | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.