Syntax error when trying to create databases.

[praom2104]

i m newbie to linux......wen ever i create database it returns an error as
"mysql> create databases new;
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 'databases new' at line 1"

i dunno wats problem.....i get this even if i try this in root user.....plz help me...

[Atli]

i m newbie to linux......wen ever i create database it returns an error as
"mysql> create databases new;
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 'databases new' at line 1"

i dunno wats problem.....i get this even if i try this in root user.....plz help me...

Hi.
The problem there would be that the keyword is "database", not "databases".