error in SQL syntax

Drgreenfingers · #1 Jan 27th, 2006, 16:49

Hello everyone

I am trying to make a database in
MySqlManager.

But it just says this:

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 ''TEST_DB'' at line 1

What does this mean?
Is the Query ok?

Please Help

Thanks

Drgreenfingers · #2 Jan 28th, 2006, 08:21

Have any of you got any ideas?

SweetLou · #3 Jan 28th, 2006, 10:24

Just a guess here, but I think it means you have an error in your syntax.
How would we know?

Drgreenfingers · #4 Jan 28th, 2006, 13:01

Quote:

Originally Posted by SweetLou

Just a guess here, but I think it means you have an error in your syntax.
How would we know?

What is syntax?

SweetLou · #5 Jan 28th, 2006, 14:03

What you wrote and how you wrote it. Something like:

Code: Select all

SELECT field FROM table WHERE id=2;

We would need to see you code to see what you did wrong.

Drgreenfingers · #6 Jan 28th, 2006, 15:08

Quote:

Originally Posted by SweetLou

What you wrote and how you wrote it. Something like:

Code: Select all

SELECT field FROM table WHERE id=2;

We would need to see you code to see what you did wrong.

The sql Query i uesed was:

CREATE DATABASE 'TEST_DB'
i used phpmyadmin

Pheonix · #7 Jan 28th, 2006, 20:05

Your error is a simple one you used ' instead of `

Code: Select all

CREATE DATABASE `TEST_DB`

This is the correct form you used quotes for data, tilds (`) for database/table/column names

Drgreenfingers · #8 Jan 29th, 2006, 12:01

Quote:

Originally Posted by Pheonix

Your error is a simple one you used ' instead of `

Code: Select all

CREATE DATABASE `TEST_DB`

This is the correct form you used quotes for data, tilds (`) for database/table/column names

I tryed this but this is what i got:

1044 - Access denied for user ''@'localhost' to database 'test_db'

guelphdad · #9 Jan 29th, 2006, 14:04

drgreenfingers, see the personal note I sent to you via posting in the forums.

As to your question, do you have proper permissions to create database with that user? Did you set up mysql on your own machine? If so did you set up proper user permissions?

Drgreenfingers · #10 Jan 29th, 2006, 15:59

Quote:

Originally Posted by guelphdad

drgreenfingers, see the personal note I sent to you via posting in the forums.

As to your question, do you have proper permissions to create database with that user? Did you set up mysql on your own machine? If so did you set up proper user permissions?

no i haven't
so how do you set up permissions?

guelphdad · #11 Jan 30th, 2006, 02:00

Look in the mysql manual on using GRANT permissions to set up a user. If the user does not have permissions to create tables or databases you won't be able to do anything with that user.

Is this on your own machine or a hosted machine? If on your own machine are you connecting as ROOT to mysql or are you connecting as a regular user?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
[SOLVED] error in SQL syntax but where it all looks fine to me	Andrew1986	Databases	3	Nov 28th, 2007 01:21
Syntax error with Ajax file reading	Paramiliar	JavaScript Forum	0	Aug 12th, 2007 16:48
syntax error...	ktsirig	Databases	2	Feb 4th, 2007 14:48
Annoying little syntax error	adeking	Web Page Design	4	Aug 9th, 2006 13:50
syntax error: unexpected T_BOOLEAN_AND...	jswebdev	PHP Forum	4	Jan 28th, 2006 07:29

		Webforumz.com > Main Forums > Program Your Website > Databases
error in SQL syntax