When using MySQL on Amazon RDS

(1) Target database

The database that can be used as a repository database is as follows:

  • MySQL on Amazon RDS

(2) Necessary information for a repository database

When you use the database described in the target database as a repository database, the following information is necessary:

  • Host name or IP address for the environment in which the target database is installed

  • Number of the port providing the service (default value: 3306)

  • Database name

  • Path to the supported JDBC driver

    For details on supported JDBC drivers, refer to HULFT Script system requirements on our website at the following URL:

    URL: http://www.hulft.com/

(3) User settings

Follow the procedure below to configure the settings for the database, and confirm that external connections can be made.

1. Add new users to the database.

2. Set the DBA role to the user you added in step 1. .

3. Set the following values to the database.

Field Name

Setting Value

lower_case_table_names

1

character-set-server

utf8

Use the user you added in step 1. to perform the procedure in (4) Repository database settings.

(4) Repository database settings

After installing HULFT Script, configure the settings for the repository database in Control Panel - Repository DB Management in HULFT Script Studio.

The details of the settings for repository database management are shown below.

Table B.6 Settings for repository database management (MySQL on Amazon RDS)

Field Name

Setting Description

DBMS

MySQL

JDBC Driver Path

Path to the supported JDBC driver confirmed in (2) Necessary information for a repository database

URL

URL of the repository database

Example: jdbc:mysql://<host_name>:<port_number>/<database_name>

User

User added to the database in (3) User settings

Password

Password used in the settings for the user