Settings for accessing MySQL server

Accessing to MySQL server is native without any ODBC drivers. In networks with more than one user you should use recipients databases on a MySQL server not the local default SQlite databases files.

Requirements

MySQL server/MariaDB server 5.5 or newer,
direct access to MySQL server typically port 3306,
a new empty or existing MySQL database with collation utf8mb4_general_ci
MySQL user with full data access to database
Privileges of MySQL users

MySQL server name	Enter name or IP address of MySQL server. For MySQL servers on own computer ever use localhost.
Port	Enter port, default port for MySQL servers is 3306.
Username	Enter username for accessing database.
Passwort	Enter password for accessing database.
Button "Connect"	Click on "Connect" to connect to MySQL server all available databases will be loaded. Errors while accessing MySQL servers Can't connect to MySQL server on '<hostname>' (10061) => Check name of MySQL server and port. Access denied for user <username> (using password: YES/NO) => Username and/or password incorrect.
Database name	Select database for saving recipients data.
Table prefix	You can enter a table prefix optionally. A table prefix can be used for saving different recipients table to one database.
Timeouts	This settings should not be changed.

Privileges of MySQL user

MySQL user should have this privileges:

Select_priv	Insert_priv	Update_priv	Delete_priv	Create_priv	Drop_priv	File_priv	Index_priv	Alter_priv	Create_tmp_table_priv	Execute_priv	Create_view_priv
Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y

Show_view_priv	Create_routine_priv	Alter_routine_priv	Event_priv	Trigger_priv
Y	Y	Y	Y	Y