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

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-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

 

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.

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.

User

Username to access the MySQL server.

Password

Password to access the MySQL server.

Save password

Save the password in the data source.

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

 

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 reload 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

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.

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 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.

 

Troubleshooting

 

Consult MySQL troubleshooting for more information.