Installing MySQL

Before installing the Deployment Automation server, install MySQL. If you are evaluating Deployment Automation, you can install the database on the same machine where the Deployment Automation server will be installed.

When you install Deployment Automation, you will need the MySQL connection information, and a user account with table creation privileges.

To install the MySQL database:

  1. Create a database by executing the following commands:

    CREATE DATABASE serena_ra;

    GRANT ALL ON serena_ra.* TO 'serena_ra'@'%'

    IDENTIFIED BY 'password' WITH GRANT OPTION;

  2. Obtain the MySQL JDBC driver.

    The JDBC jar file is included among the MySQL installation files. The driver is unique to the edition you are using.

  3. Begin the server installation. See Server Installation.

    Select the MySQL database option in the installer.

  4. Provide the MySQL JDBC driver (see step 2).

    The default value is com.mysql.Driver.

  5. Provide the JDBC connection string. Typically, it is similar to:

    jdbc:mysql[DB_URL]:[DB_PORT]:[DB_NAME]

    For example:

    jdbc:mysql://serverName:3306/serena_ra

  6. Finish by entering the database username and password.