You can use MySQL as a supporting database with IBM® UrbanCode Release
server. Create the database before you install IBM UrbanCode Release.
Typically the database is installed on a computer other than the one
where the server is located.
About this task
When you install IBM UrbanCode Release,
you need the database connection information and the JDBC JAR file.
The user account for the database must have table creation privileges.
Procedure
Create a user that is named ibm_ucr.
CREATE USER 'ibm_ucr'@'localhost' IDENTIFIED BY 'password';
Create a database named ibm_ucr.
CREATE DATABASE ibm_ucr;
Grant the user that you created all privileges
on the database.
GRANT ALL ON ibm_ucr.* TO 'ibm_ucr'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
Obtain the MySQL JDBC driver JAR file for the edition of
MySQL that you are using. This file must be available when you run IBM Installation Manager.
Record the values of the database parameters so that you
can supply them when you install the server. The following parameters
are typical for an installation of MySQL used to support IBM UrbanCode Release: