Installing Wordpress On Windows (2000 and XP)-Part 4 Creating the MYSQL Databases

 Wordpress stores all of its data in a database. Therefore before we can install Wordpress we need to create a database for it to use.

Before we go ahead and do that we are going to take a look at a few commands. You need to go to the msql\bin directory.

The first thing is to set the password for the root user (main administrator).

 It seems that MYSQL installs with a default root user with no password. So go the the command prompt and type

The command is mysqladmin and the syntax is

mysqladmin -u root password new-password

Therefore to give the root user a password of password type:

F:\mysql\bin\mysqladmin -u root password password

Note: I'm installed on the F drive not c: drive

Now we are going to create the database, the database user and grant the user access to the database. The command to do this is mysql.The procedure is

• Login to mysql user the user root (use password that you just set)
• Create the Database ( Called blogbase in example below)
• Grant User ( User called wordpress password of password) access to the database.- This is a single command.
• Flush to make sure that the privileges are set
• Show databases (note in example below I have created one called blogbase and another called Wordpress. The Wordpress database I created earlier when I did my real install. Don't confuse it with the user Wordpress user used above.
• Quit mysql by typing quit.

You should note that when in MYSQL command line prompt if you need to go to another line just hit return the command is only submitted when you end the line with a semi colon --- ;

Now we are ready to Install Wordpress.

Resources:

• MySQL Primer