Time for action — creating a MySQL database for Roller

In this exercise, you'll use the MySQL monitor to create a database for your Apache Roller blog site.

1. Open a Terminal window (Start | All Programs | Accessories | Command Prompt) and type

   mysql -u root -p

2. The MySQL monitor will ask you for the "root" user password. This is the password you used when installing MySQL server. Type it and press Enter. If the password is correct, the following screen shall appear:

   

3. Now type the following lines after the mysql> prompt (remember to replace password with a secure password) and press Enter after each line:

   create database rollerdb;
   grant all on rollerdb.* to roller_user@'%' identified by 'password';
   grant all on rollerdb.* to roller_user@localhost identified by 'password';
   

4. When finished, your screen should look like this:

   

5. Notice the Query OK, 0 rows affected (X.XX sec) line after each line you typed. It means there were no errors with the commands you entered. Now type exit and press Enter to exit...