Please enable JavaScript to view this site.

MySQL

Description

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

For added security, you can enable SSL Encryption to communicate with your instance of MySQL Server.

 

Please follow directions in those links;

https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-ssl.html

https://dev.mysql.com/doc/connector-net/en/connector-net-6-10-connection-options.html

We recommend using MySQL version 5.5.62 for this data source.

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

General

MySQL - General Tab

MySQL - General Tab

OPTION

DESCRIPTION

Name

Name of the data source.

Host

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

Port

If not using the default port, enter your Port number.

Integrated Security

When enabling the Integrated Security, the user and password field will be disabled because the operating system will provide a cached copy automatically. Please see Integrated Security for more information.

Username

Username to access the MySQL server.

Password

Password to access the MySQL server.

Always ask password

Prompt for the password when a user connects to the data source.

Allow change username

Allow the username to be edited when connecting to the data source.

(Only with Always ask password enabled)

Schema

Name of the schema on the MySQL server for the utilization of Remote Desktop 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

Private Vault

MySQL - Private Vault Tab

MySQL - Private Vault Tab

OPTION

DESCRIPTION

Type

Select the type of Private Vault to use. Select between:

Default: use the default Private Vault, which is stored in the database.

None: disable the Private Vault for all users.

Online Drive: use a Devolutions Online Drive file (*.dod) as a Private Vault.

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 Remote Desktop Manager.

Update Schema

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

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.

View Upgrade Script

Open the upgrade script in a new window.

VPN

Open a VPN to access your data prior to connecting to your MySQL database.

MySQL - VPN Tab

MySQL - VPN Tab

Advanced

MySQL - Advanced Tab

MySQL - Advanced Tab

OPTION

DESCRIPTION

Caching mode

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

Ping online method

Indicate the preferred ping online method. Select between:

None

Ping

Port Scan

Connection timeout

Waiting time before a connection timeout.

Command timeout

Waiting time before a command timeout.

Auto refresh

Set the interval for the automatic refresh

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.

Auto go offline

If the ping online method doesn’t work 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.

More Settings

Edit the connection string values directly.

Troubleshooting

Consult MySQL troubleshooting for more information.