Using MySQL with Aurora
This document outlines the installation and configuration of MySQL for use as an output database for Aurora.
Installation
1. Download the latest version of MySQL from http://dev.mysql.com/downloads/. New versions of MySQL are released very frequently so the version numbers change often. Look for the current recommended release, which is usually found at the top of the downloads page.
2. Once you have downloaded and unzipped the MySQL setup file(s), start the install process by double clicking on setup.exe. You can choose the typical type of install. You can also skip the mysql.com sign-up screen unless you desire to create an account on the MySQL website. At the end of the install, be sure to watch for the check box that gives you the option to Configure the MySQL Server now. It looks like this:
3. Start the MySQL Server Instance Configuration Wizard. The opening screen will look like this:
4. Click “Next” to start the wizard. The first option screen will allow you to select the configuration type. We recommend you select the Standard Configuration.
5. Set the Windows options. The next option screen that will appear is the set Windows options screen. We recommend that you select the Install As Windows Service as well as Launch the MySQL Server automatically options. You can leave Include Bin Directory in Windows PATH unchecked as shown below:
6. Set the security options. The next screen sets the security options. We recommend that you select Modify Security Settings and create a secure password for the root user. The root user account is the one you will use to connect to MySQL from the Reporting folder of Simulation Options in Aurora. This is what the security options screen will look like:
7. Complete the MySQL Server Instance Configuration Wizard. After configuring the security options and selecting Next you will be brought to the final screen that looks like this:
8. Press the Execute button and the Wizard will setup the MySQL Server based on the configuration options you have specified.
This concludes the setup and configuration phase of setting up MySQL. You are now ready to use it with Aurora.
If you missed the Configure the MySQL Server Now at the end of the MySQL setup, or would like to make further changes to MySQL Server configuration you can access the wizard again by clicking the MySQL Server Instance Config Wizard icon in the Start Menu.
Configuration
To use MySQL with Aurora:
In the Reporting folder of Simulation Options, select MySQL as the Database Type and select the Change... button to begin the SQL Server setup.
Complete the form, similar to the SQL Server one shown below.
1. If using the server on your local machine, the SQL Server Name may be left with the default name "localhost". If the server name is not known, use the dropdown to browse the network for available servers.
2. If using a SQL Server on your network that requires Windows Integrated Authentication, leave the SQL User Name and SQL Password blank.
If using a SQL Server on your network that requires SQL Server Authentication, you must enter the User Name and Password given to you by your database administrator. Your user rights in SQL Server will need to include those of the “database creators” role.
3. Be sure the Database Name is a valid SQL Server database name. Select one from the list of existing databases or type in a new name.
NOTE: The SQL Server database name cannot begin with a space or contain embedded spaces, special characters, or reserved words.
4. (Optional) Use the additional parameters area when creating custom SQL Server output databases. These additional parameters are specified by entering Transact-SQL CREATE DATABASE statements into this text field. Because SQL Server environment configurations can vary greatly, the syntax of these statements is highly dependent on the setup of the SQL Server you are using (e.g. user access rights, folder permissions, etc.). The syntax to use should be the desired Transact-SQL syntax immediately after the following wording:
“CREATE DATABASE thedatabasename”
NOTE: If a SQL Server database with a given name already exists, Aurora will not drop it, rather it drops all of the tables. A new database is not created for existing databases even if the multiple runs to a database is not set.
Use the text boxes for MySQL Server Name/IP Address, MYSQL User Name and Password to set the corresponding values for MySQL. If you followed the setup instructions above you should enter the following:
MySQL Server Name: localhost
User Name: root
Password: (the password you created in the MySQL Server Instance Configuration Wizard)
If you need further help with MySQL, access their extensive documentation resources at http://dev.mysql.com/doc/
Using MySQL with Aurora
