Installing with 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™ Build server, install MySQL. If you are evaluating IBM UrbanCode Build, you can install the database on the same computer as the IBM UrbanCode Build server. For example, the command to install MySQL on a Linux system is similar to this following code:
yum install mysql mysql-server

When you install IBM UrbanCode Build, you must have the MySQL connection information, and a user account with table creation privileges.

Procedure

  1. Log in to the MySQL command line interface. The command might look like the following example:
    mysql -u username -ppassword
    For username, specify the user name for MySQL. The default user name is root. For password, specify the password for that user name. The default account has no password; in this case, omit the -p flag and the password. There is no space between the -p flag and the password.
  2. Create a database. The following commands are an example of to create this database: 
    CREATE USER 'ibm_ucb'@'localhost' IDENTIFIED BY 'password';
    CREATE DATABASE ibm_ucb;
    GRANT ALL ON ibm_ucb.* TO 'ibm_ucb'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
  3. Log out of the MySQL command line interface.
  4. Obtain the MySQL JDBC driver. The JDBC JAR file is included with the installation files. The driver is unique to the edition that you use.
  5. Copy the JDBC JAR file to the installer_directory\lib\ext directory.
  6. Begin to install the server. See Installing the server in interactive mode. When you are prompted for the database type, enter mysql.
  7. Provide the JDBC driver class that IBM UrbanCode Build uses to connect to the database. The default value is com.mysql.jdbc.Driver.
  8. Next, provide the JDBC connection string. Typically, the string is similar to the following code: 
    jdbc:mysql://DB_URL:DB_PORT/DB_NAME
    This example shows a connection string: 
    jdbc:mysql://localhost:3306/ibm_ucb
  9. Finish by entering the database user name and password.
Feedback