Mysql not working

[Chikwado]

Mysql procedural "CREATE DATABASE" not working, I have written the code exactly the way it appear in the tutorial. But it return error insted of creating the database. I am using xampp version: 5.6.3, Some one help.

Edited June 30, 2015 by Chikwado

[justsomeguy]

What error? Does your MySQL user have permission to create a database?

[Chikwado]

I just do not know that setting, I need advise on how to set that permission. More help <?php echo "";  ?>

Edited June 30, 2015 by Chikwado

[thescientist]

you still need to tell us the error though

[justsomeguy]

All of that information is already online in the MySQL manual. Instead of me looking that up and linking you to it, or copying and pasting the information, just look it up yourself. You don't need to wait for answers that are already online.

[Chikwado]

Yes, I have seen it. Thanks a lot.

[Chikwado]

Some one take a more look at this syntax: I used the following syntax to create a user, but it return error.

CREATE USER 'user'@'localhost'   IDENTIFIED BY ' ***** ';

To grant user:

GRANT ALL PRIVILEGES ON  * . * TO 'localhost';

I got the following error:

'CREATE' is not recognized as an internal or external command,

some one check it.

[justsomeguy]

Are you just typing that into a shell prompt? That looks like a Windows error message. You run queries on MySQL, not Windows.

[thescientist]

did you mean to connect to the mysql server first before trying to run those commands at the prompt? what happens when you try and run them in PHPMyAdmin or similar tool?