Installing the MySQL Database on Windows

For Emptoris® Spend Analysis, MySQL 5.5.41 can be installed on Windows 2008 or Windows 2012.

To install MySQL on Windows, complete the following steps:

1. Create a tools directory by using the mkdir command.

   C:\mkdir C:\opt\emptoris\tools

2. Extract the mysql-5.5.41-winx64.zip file to the tools directory.
3. Rename the extracted mysql directory to MySQL-5.5.41.
4. From the bin directory, open the my.ini file.
5. Modify the my.ini file.

   For more information, see Creating the my.ini File on Windows.

6. To create a Windows service for MySQL, use the following command.

   D:\opt\emptoris\tools\mysql-5.5.15-winx64\bin>mysqld.exe --install MySQL --defaults-file="D:\opt\emptoris\tools\mysql-5.5.15-winx64\my.ini"

7. When installing for the first time, from the bin directory of MySQL, start the mysqld service by using the following commands.

   cd C:\opt\emptoris\tools\MySQL-5.5.41\bin

8. Close the command prompt.
9. Start the MySQL server by using the mysqld.exe command.

   The MySQL server is started.