Preparing MySQL

See the Sun Identity Manager 8.1 Release Notes for supported database server versions.

To Prepare MySQL for Use with Identity Manager

1. Install the MySQL^TM software. Start the MySQL process (if it does not start automatically).

2. Create the database. To do this:

   1. Copy the create_waveset_tables.mysql script to a temporary location. This script is located in the db_scripts directory in the Identity Manager installation package, and also in the idm\sample directory if Identity Manager is already installed.

   2. Modify the create_waveset_tables.mysql script to change the database user password.

   3. Create the new tables by using one of the following commands:

      On Windows

      c:\mysql\bin\mysql -u root < create_waveset_tables.mysql

      On UNIX

      $MYSQL/bin/mysql -u root < create_waveset_tables.mysql

3. Download a version of MySQL Connector/J to use with MySQL.

   See Notes on Configuring Databases and Downloading Supporting JAR Files for more information.

   Later, during the Identity Manager installation process, you will install the MySQL Connector/J driver to the $WSHOME/WEB-INF/lib directory on your application server.