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

Configuring client access

This is an example of how to grant full access to a database named dispatch to a Windows computer named drafting1-PC. The user is named root and the users password is sqlsql.

 

GRANT ALL PRIVILEGES

ON dispatch.*

TO 'root'@'drafting1-PC';

Allowing Dispatch to create new databases

Dispatch will be allowed to create database if the user has global privileges.

 

GRANT ALL PRIVILEGES

ON *.*

TO 'root'@'drafting1-PC';

 

https://dev.mysql.com/doc/refman/5.7/en/grant.html#grant-global-privileges

Enable access to INFORMATION_SCHEMA

The show_compatibility_56 must be ON to allow Dispatch 3.2 to query the INFORMATION_SCHEMA tables. To enable access to the tables, you must run this command on the server.

 

SET GLOBAL show_compatibility_56=ON;

Enabling ANSI quotes

Dispatch 3.2 automatically executes the following command after it connects to a MySQL database:

 

SET SESSION sql_mode='ANSI_QUOTES';

Why are ANSI quotes required?

To enable Dispatch to easily share SQL across database servers, we simply instruct MySQL to use the same double quote convention that other database servers use..

 

If a reserved words has been used as column name, whenever that column is referred to in a SQL statement it must be quoted. Quotes are also required if column names or table names contain spaces, (e.g. "1st Quarter").

 

In MySQL, the default is to use the backtick like this: `type`. Using the backtick woth PostgreSQL or SQL Server will result in an error.