...

Preparing the Database via Command Line

Follow the directions below that are appropriate for your database. Once you have prepared your database, see Connect to an Existing DTP Database below for information about connecting DTP to your database.

Preparing MySQL DB via Command Line

...

1. Click Configure Database Settings and select Create new DTP database, user, and schema in the window that appears.
   
2. Click Next.
   Image Modified
   
3. Select a database type: MySQL, Oracle, or PostgreSQL.
4. Enter the database URL and root credentials, then click Test Connection to confirm that it is correct.
   

   Info
   For MySQL databases, the root user must have the GRANT OPTION privilege.

   
   
5. Click Next.
   Image RemovedImage Added
   

6. Enter new user and credentials and click Create Database.
   

   Info
   title Existing Parasoft Users
   The processes will fail if the Parasoft default "dtp" user already exists. In this rare scenario, you can manually create the database and users, then go through the Create a DTP schema for an existing database described below. Alternatively, you can drop the "dtp" user before running this process.

...

1. Click Configure Database Settings and select Connect to existing DTP database in the window that appears.
   
2. Click Next.
   Image Modified
   
3. Select a database type: MySQL, Oracle, or PostgreSQL.

4. Enter the database URL and user credentials, then click Test Connection to confirm that it is correct.
   

5. Click Save & Connect to connect to the database.

...

1. Click Configure Database Settings and select Create DTP database schema in the window that appears.
   
2. Click Next.
   Image Modified
   
3. Select a database type: MySQL, Oracle, or PostgreSQL.
4. Enter the database URL and user credentials, then click Test Connection to confirm that it is correct.
5. Click Create Schema.

...