How to connect to a MySQL database


#1

You can use the ODBC connector to connect to the MySQL server. The connection string should look as follows:

<add name="MySQL" connectionString="Driver={MySQL ODBC 5.1 Driver};Server=localhost;Database=test;uid=nativeuser;pwd=password;" providerName="System.Data.Odbc"/>

This connection string can be stored in the wfgen\web.config file in order to use it in multiple forms.

Make sure the ODBC connector is installed on your server: https://dev.mysql.com/downloads/connector/odbc/.

Note: In MySQL 8.x, you might experience an issue with the newly-added caching_sha2_password authentication type . If you want to use the standard authentication type, create a new user using the following query:

CREATE USER 'nativeuser'@'localhost'
IDENTIFIED WITH mysql_native_password BY 'password';

Also, make sure to give that user the proper read and write permissions.


How do i bind mysql table to global list?