Invalid SQL: INSERT INTO `swsessions` (`sessionid`, `ipaddress`, `lastactivity`, `useragent`, `isloggedin`, `sessiontype`, `typeid`, `dateline`, `status`) VALUES('4b5fb524c2fffd3edc38afa28b0964ae', '54.167.225.62', '1498610823', 'CCBot/2.0 (http://commoncrawl.org/faq/)', '0', '40', '0', '1498610823', '0'); (The table 'swsessions' is full)
Warning: Cannot modify header information - headers already sent by (output started at C:\Inetpub\support.inm.com\includes\functions.php:410) in C:\Inetpub\support.inm.com\includes\functions.php on line 1612
Installing MySQL - Support Center
inm logo
Corporate Website | Contact | Store | Support | Login  
     


Knowledgebase
View categorized listing of all common frequently asked questions.
Downloads
View our categorized library of downloads for all necessary manuals, software, etc.
 Article Options
Support Center » Knowledgebase » INM GoldenGate for Director » Installing MySQL
Support Page Banner
 Installing MySQL
Product:Platform:Area:Version:
GoldenGate ServerWindowsSetupall

Summary

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

Example

Installing 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:)
MySql>

Type "DELETE FROM user WHERE Host ='localhost' AND User='';"
Type "QUIT"

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?).

You're done!

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.



Article Details
Article ID: 90
Created On: 26 Sep 2006 12:34 PM

 This answer was helpful  This answer was not helpful

inm general footer
Services Xtras Go Products Support Gallery Store Download About Us Contact Newsroom