Online Help > Data Sources > Data Sources Types > Advanced Data Sources

MySQL Data Source

Description

 

DataSourceMySQLLarge

Password Vault Manager uses a MySQL database to store the session data. It is only supported in the Enterprise edition.

 

Highlights

 

The data can be shared on a MySQL database installed on any Operating System MySQL supports.

Full connection log and attachment support.

Integrated Security support. (Requires a v5.5.16 commercial distribution of MySQL).

 

Settings

 

Connection

 

MySQL - Connection tab

MySQL - Connection tab

 

Option

Description

Name

Name of the data source.

Host name

Name of the server where the data source will be store.

Integrated security (Active Directory)

Specify to use Windows Integrated Authentication for authenticating to the data source. Applies only to SQL Server and RDMS, depending on their configuration. When checked, an ellipsis button appears to allow you to browse for the user account in the directory. Consult Integrated Security topic for more information.

User

Username to access the MySQL server.

Password

Password to access the MySQL server.

Schema

Name of the schema on the MySQL server for the utilization of Password Vault Manager.

Two factor

Enable the 2-Factor Authentication to access your data source.

Test Host

Test the connection with the Host (server) to validate if the proper information has been provided.

Test Schema

Test the connection with the schema to validate if the proper information has been provided

 

Advanced

 

MySQL - Advanced tab

MySQL - Advanced tab

 

Option

Description

Offline mode

Determine if you want to use this data source in Offline Mode. In this mode, the data source can be available in Read Only or in Read/Write mode.

Prompt for offline mode on startup

Every time you will connect to your data source, you will be prompted to use the data source in offline mode.

Caching mode

Determine how the entries will be reloaded in the data source. See Caching Mode topic for more information.

Auto refresh

Set the interval for the automatic refresh.

Connection timeout

Waiting time before a connection timeout.

Command timeout

Waiting time before a command timeout.

Ping online method

Indicate the prefer ping online. Select between:

None

Port Scan

Auto go offline

If the ping online method doesn’t respond it will automatically go offline.

Disable lock

Disable the option to lock the data source directly. You can still lock the application but you won't be prompted for the database password if this option is disabled.

Advanced Settings

Edit the connection string values directly.

 

Upgrade

 

MySQL - Upgrade tab

MySQL - Upgrade tab

 

Option

Description

Test Host

Test the connection with the host (server) to validate if the proper information has been provided.

Create Schema

Create the schema on the MySQL server to use.

Update Schema

Update the schema on the MySQL server, if required, to use.

Test Schema

Test the connection with the schema to validate if the proper information has been provided.

Email Schema to Support

Send your schema to the Devolutions Support team.