MySQL Commands to Create Database

These notes are in relation to this WordPress Support thread
http://wordpress.org/support/topic/wordpress-installation-problems?replies=8

To create a MySql database, login to the MySQL Administrator, and locate the Command Line Client under the Tools menu.
You will get a window that looks similar to the DOS command prompt.
When you see the mysql> prompt enter the following commands including the semi-colon (;) at the end of the command

CREATE DATABASE something_wrdp;

In the above CREATE command, you should replace something_wrdp with whatever database name you want to use.
mysql will respond with something like this>  Query OK, 1 row affected (0.00 sec)

Next command to enter at the mysql> prompt is:

GRANT ALL PRIVILEGES ON something_wrdp.* TO "username"@"localhost" IDENTIFIED BY "password";

In the above GRANT command, you would replace something_wrdp with whatever database name you used in the CREATE command. Also replace username with whatever name you want to use and do the same with password.  Use a very good 12 to 15 character cryptic password using a combination of letters (upper and lower case) and numbers.

mysql will respond with something like this> Query OK, 0 rows affected (0.00 sec)

Next command to enter at the mysql> prompt is:

FLUSH PRIVILEGES;

mysql will respond with something like this> Query OK, 0 rows affected (0.01 sec)

Finally, at the mysql> prompt just enter EXIT and you will see the message Bye

That is it. Your mySQL database should be created and the database name, user name and password that you used here will go in your wp-config.php file when setting up WordPress.