MySQL is a free open source SQL Database Server available for multiple OS platforms. Since it normally uses a command prompt interface, it can be tricky to install and configure without detailed knowledge of the commands. This Tech Note explains how to install and configure the Windows version of MySQL
First download the most recent version of the Windows version of MySQL from http://www.mysql.com, along with the appropriate MyODBC driver for Windows.
Install them by decompressing the files in an empty folder and running Setup.exe (We recommend closing any other open application)
Next, you need to install the server as an NT Service. To do so, you need to log on with administrator rights and open up the Command Prompt. From there, go in the Bin folder of MySQL.
Example: "C:\MySQL\Bin" if you installed MySQL from the root of the C: Drive.
Type "MySQL-NT --Install"
Next, we strongly suggest clearing all anonymous logons, for security purposes.
Type "MySql MySql" to enter MySQL console mode
(you should then see a prompt like this:)
Type "DELETE FROM user WHERE Host ='localhost' AND User='';"
You should be back to the console prompt.
Type "MySqlAdmin reload" to make the new changes effective and then Type "MySqlAdmin -u Root password your_password" (replace your_password with the master password you want to use)
This will set the root user password.
You could use the command line console of MySQL (MySql.EXE) for the next steps, but we suggest you download a free graphical frontend which is available from the MySql website, called "MySQLFront".
When you open up this frontend, you are greeted by a logon screen. Enter the user ROOT and the password you set earlier to connect. If you are familiar with the Microsoft SQL Server Administrator, you will feel right at home. When you launch it for the first time, there should be a database already created named "mysql", click on it and then on the table "user". Then click on the SQL Query tab.
Creating a GoldenGate User
Find the "SQL-Query On Database MySQL:" text box.
Type "GRANT Select, Insert, Update, Delete ON *.* to goldengate@'%'
IDENTIFIED BY 'your_pass'"
This line creates a user named "goldengate", which has the rights to Select, Insert, Update, Delete on every tables and all databases.
The '%' suffix after the name means that user "goldengate" can connect from anywhere on the net. if you would have put 'localhost', the "goldengate" user would only have been able to connect from that same computer.
"IDENTIFIED BY 'your_pass'" sets the "goldengate" user password. "your_pass" should be replaced by the password you want to assign to the "goldengate" user.
Creating a Sample Database
Create a new database for GoldenGate to use (keeping the default MySql database intact) in the tree view by right-clicking LocalHost and selecting Create Database. Give it a significant name, let's say "GoldenGateDB".
Create a table by first selecting the "GoldenGateDB" Database and the Database Tab.
Right-Click on an empty line and select Create Table.
This part is well documented in the interface. Give the table a name, then name the field, click the Add button and finally set the properties as you like, making sure one of the fields is Primary.
Click Create when all your fields are ready!
ODBC Driver Configuration
In the Administrative Tools of the control panel, double-click the "Data Sources (ODBC)" icon
Select the System DSN tab, and click ADD
Select the MySQL driver
Fill the configuration as in the following screenshot, by making sure to replace the example IP with the one from your (SERVER or WORKSTATION?).
Connecting Your New Database Through GoldenGate
The only step left is to make this database available through GoldenGate by adding this ODBC Connection to the GoldenGate server in the GoldenGate Administrator Panel.