Creating and Configuring the MySQL Database for Windows Machines

You can create and configure the MySQL database for Windows machines.

Procedure

To configure the MySQL database on a Windows machine, complete the following tasks:

Download MySQL 5.5.15 for Windows (64-bit) from the following locationhttp://downloads.mysql.com/archives/mysql-5.5/mysql-5.5.15-winx64.zip.
Tip: Run and install the MySQL service on the D drive.
On the Windows database server, create a directory on the D drive called Spend.
Extract the downloaded compressed file of MySQL in the Spend directory. The MySQL directory in your setup might be D:\Spend\mysql- 5.5.15-winx64\.
Create the my.cnf file. For more information, see Creating and Configuring the my.cnf File for Windows Machines.
From the bin directory of MySQL, start the MySQL services using the following commands:
```
D:\cd D:\Spend\mysql-5.5.15-winx64\bin

D:\Spend\mysql-5.5.15-winx64\bin\mysqld
```
Log in to the database using the following command.
```
D:\Spend\mysql-5.5.15-winx64\bin>mysql –u root
```

Create the expmap user with the expensemap1 password for the host (local host, %), and IP address using the following commands.

mysql>create user 'expmap'@'localhost' identified by
'expensemap1';
mysql>create user 'expmap'@'%' identified by 'expensemap1';
Grant all privileges to the expmap user
mysql>GRANT ALL PRIVILEGES ON *.* to 'expmap'@'localhost'
identified by 'expensemap1';
mysql>GRANT ALL PRIVILEGES ON *.* to 'expmap'@'%' identified
by 'expensemap1';
mysql>exit

Stop the mysql services using the following command.

D:\Spend\mysql-5.5.15-winx64\bin>mysqladmin.exe -u expmap -p shutdown

When prompted, enter expensemap1 as the password.