Configuring PROIV to connect to MySQL

Virtual Machine

Trail: PROIV Documentation > Administration > Environment Guide > Configuring PROIV to connect with MySQL

You can establish a connection between PROIV and MySQL in three ways:

Method 1: Update PRO4V8.ini file with the following configuration

[DATABASE - SQLDEFAULT]

FILETYPE=MYSQL

PRODB_CHARSET=8

CONNECTION="<USER>/<PWD>@<HOST>:<PORT>/<DB>” where:

• USER and PWD - The username and password to connect the Windows or Unix machine.

• HOST - The ip address or the hostname of the MySQL server. Enter 'localhost', if MySQL is installed on the same machine.

• PORT - The port number to use for the connection.

• DB - The database specified here behaves as the default database for the connection.
  
  Example: “mysqluser/mysqlpwd@localhost:3306/testdb"

Method 2: Select MySQL option for External Database Support during PROIV installation.

Refer to PROIV V8.2 Installation guide for more information.

Method 3: Configure MySQL database using PROIV Control Panel

Open PROIV Control Panel > Virtual Machine > Database

The DATABASE - SQLDEFAULT page appears. Click here for more information.

Comment on this topic

Topic ID: 560003