MySQL Configuration

Modified by Phil Loughhead on Jun 15, 2017

Step 1

MySQL is a relational database system and is commonly deployed on a server, being made available as a service or daemon running on that server (as opposed to a library based database system such as SQLite). The configuration settings required to connect to a MySQL server are implementation specific. In this example, the MySQL server is being hosted on the local PC (the same PC running the Ciiva Client application) and so the server is configured as localhost.

Step 2

To update the data source based on the profile configuration settings, click on the ODBC synchronise toolbar button.

Step 3

The ODBC data source will be added to the user DSN and be visible in the ODBC data source administrator tool (included as part of the Windows OS).

Step 4

Tools such as MySQL workbench can be used to connect to and inspect the data source.

 

You are reporting an issue with the following selected text and/or image within the active document: