Configuring a MySQL database

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 server 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

  1. 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;
  2. 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.
  3. Copy the JDBC JAR file to installer_directory\lib\ext.
  4. Begin server installation, see Installing the server. When you are prompted for the database type, enter mysql.
  5. Provide the JDBC driver class IBM UrbanCode Deploy uses to connect to the database. The default value is com.mysql.Driver.
  6. 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
  7. Finish by entering the database user name and password.

Feedback