mySQL error 1064

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7 to server version: 4.0.14-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database Forum
-> grant all privileges on Forum.* to Noctum@localhost
-> identified by 'my_password';
ERROR 1064: 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 privileges on Forum.* to Noctum@localhost
identified
mysql>

What am I doing wrong? It never works. Im using mySQL version 4.0.14b and i have WinmySQLadmin 1.4. Im doing it on my computer. Can anybody help?

mysql.com

You forgot the good ole' semicolon.
Try this:
"CREATE DATABASE Forum;"
(no quotes of course)

Then do the
"grant all privileges on Forum.* to Noctum@localhost identified by 'my_password';"

Those are two different commands and cannot be entered together.

I don't know if that syntax is exact on that grant statement because my MySQL server is down.

acces denied?

What is the username you are loggin in with ? The username you are logging in doesn't have the access for that action.

Try this


Where PASSWORD is the password of the root account.

Also after you have granted the privileges, you should execute .... in mysql


HTH!

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8 to server version: 4.0.14-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database Forum;
Query OK, 1 row affected (0.00 sec)

mysql> grant all privileges on Forum.* to Noctum@localhost
-> identified by 'pass';
ERROR 1044: Access denied for user: '@localhost' to database 'Forum'
mysql>

First, make sure you are logged in as a privileged user to the mysql database, usually 'root'
Second, make sure that privileged user has a password defined.

Your syntax should be as follows:
GRANT all privileges ON Forum.* TO 'Noctum'@'localhost' IDENTIFIED BY 'insertpasswordhere';

Remember to use the single quotes or it won't work.

Thanks for the replies.

Sorry to say Tazlord but you are about 3 years to late on this one but thanks for the answer anyway.