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

MySQL

Description

 

DataSourceMySQLLarge

Remote Desktop Manager for Mac uses a MySQL database to store the session data. It's only supported in the Enterprise edition.

 

BadgeInfo48x48

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

 

Please follow directions given 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.

 

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

Enter the port to connect on MySQL server.

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.

Schema

Name of the schema on the MySQL server for the utilization of Remote Desktop Manager for Mac.

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

 

My SQL - Advanced tab

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

When Remote Desktop Manager for Mac is start, you will be prompt to go offline or not.

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.

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.

Connection timeout

Waiting time before a connection timeout.

Command timeout

Waiting time before a command timeout.

Ping online method

Indicate your prefer ping online method. Select between:

None

Ping

Port Scan

Auto go offline

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

Manage Cache

Manage your cache on your computer to analyse, vacuum, repair or delete it. This can be very helpful if you have offline issues. For more information please follow this link.

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

Update Schema

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

Test Schema

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

View upgrade script...

Display the upgrade script.

 

Private Vault

 

MySQL - Private Vault tab

MySQL - Private Vault tab

 

OPTION

DESCRIPTION

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