Before you install the server, install the MySQL database
and provide the JDBC JAR file for the installation process.
Before you begin
Before you install the IBM® UrbanCode Deploy server,
install MySQL. If you are evaluating IBM UrbanCode Deploy,
you can install the database on the same system as the IBM UrbanCode Deploy server.
When
you install IBM UrbanCode Deploy,
you need the MySQL connection information, and a user account with
table creation privileges.
Procedure
- Create a database. The following commands
are an example of how you might create this database:
CREATE USER 'ibm_ucd'@'localhost' IDENTIFIED BY 'password';
CREATE DATABASE ibm_ucd;
GRANT ALL ON ibm_ucd.* TO 'ibm_ucd'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
- Obtain the MySQL JDBC driver. The JDBC JAR file
is included among the installation files. The driver is unique to
the edition you are using.
- Copy the JDBC JAR file to installer_directory\lib\ext.
- Begin server installation, see Installing the server.
When you are prompted for the database type, enter mysql.
- Provide the JDBC driver class IBM UrbanCode Deploy uses
to connect to the database. The default value is com.mysql.Driver.
- Next, provide the JDBC connection string. Typically,
it is similar to the following code:
jdbc:mysql://DB_URL:DB_PORT/DB_NAME
For
example: jdbc:mysql://localhost:3306/ibm_ucd
- Finish by entering the database user name and password.