<< Click to Display Table of Contents >> Navigation:  Supported database systems > MySQL and MariaDB > MySQL and MariaDB connection properties

As of 2024-04-04, support for MySQL and MariaDB is still a work in progress. Please contact us for support if you intend to use MySQL or MariaDB.

 

When you connect to a MySQL or MariaDB server and the database specified by the Database property does not exist, Dispatch will attempt to create it.

 

If the user has permission to create a database, the new database will be created. Once the database has been created, Dispatch will connect to the database and create all the database objects (e.g. tables, procedures, triggers) that it requires.

 

Alternatively, a database can be created using a tool like MySQL Workbench or HeidiSQL.

 

 

Database driver

Database driver must be set to MySQL. This applies to both MySQL and MariaDB servers.

Server

The location of the server. We have tested the connection using IP addresses (e.g. 192.168.7.134) and a resolvable host names (e.g. localhost). Unless specified as the Advanced option, Dispatch will attempt to connect to the server using port 3306.

Database

The name of the database. In the example the Database is canscale.

Advanced

The only supported option is to specify the port number. For example Port=7777.

User name

The database user name. In the example the User name is root.

 

If the User name property empty, Dispatch will display a Database Login dialog when Dispatch tries to connect to the database.

Password

The password associated with the User name.

 

If the Password property empty, Dispatch will display a Database Login dialog when Dispatch tries to connect to the database.

 

The password must be supplied for the user to be allowed to connect to the database. As you type the password, each character type is shown as an asterisk (*).