Overview
Our software platform supports integration with MySQL via the MySQL Connector/NET or ODBC driver, allowing connectivity to the database. After installing the chosen driver, users can configure the connection in Datasets / DBs / ConnectionString.
Installation and Setup
The MySQL Integration requires the usage of either the MySQL Connector installation or the ODBC driver for MySQL.
You can download the MySQL Connector/NET here.
And alternatively, you can download the latest ODBC Driver for MySQL here.
MySQL Connection via MySQL Connector
After downloading the MySQL Connector, please follow these steps:
Open the MySQL Connector NET 9.2.0 installer (mysql-connector-net-9.2.0.msi).
- Choose the Destination Folder and click Next.
- Click Install and wait for the installation process to complete.
- Click Finish to complete the installation.
- After completing the installation, open the Solutions Manager and select a solution.
- Navigate to Datasets / DBs and click on the plus icon to create a new database connection.
- Next, choose the MySQL Data Provider from the available options.
- After creating the database connection, click on ConnectionString and fill in the required fields with the necessary parameters, such as Server, Port, Database, SslMode, and any Additional Parameters as needed.
MySQL Connection through ODBC
After downloading the latest ODBC Driver for MySQL, you can follow this step-by-step to properly install and use it on the software platform.
Open the .msi file - It is recommended to use the .msi installer over the .bin due to how much easier it is to use such file.
Click “Next >”.
- Accept the terms in the license agreement:
- Choose the complete installation:
- Lastly, make sure you agree with the Destination Folder and click to install the driver:
- After the driver is properly installed, head over to Datasets / DBs and click to add a new database:
- Change the data provider to “Odbc Data Provider” and choose MySql Database:
- Open the “ConnectionString” dropdown and add your server information:
The “Server” line is where you add your server IP;
The Port is where you select your server port, where it usually is 3306 for MySql Servers.
Database is where you choose which database will be retrieved from the server.
Make sure to add your user as an Additional Parameters with the syntax “User=<UserName>”
For the Driver line (in ConnectionString): Each version of the ODBC Driver you download will have a unique driver version string. To check your installed version, follow these steps:
Press Win + R and type “odbcad32” and head to the Drivers tab, then, you can check your full driver name:
You can type one of those two Drivers in the ConnectionString dropdown - they should both work. Lastly, you can set the password in the LogonPassword column. To do that however, you need Administrator permissions, which you can get by default by logging with the username “Administrator” and no password:
Finally, you can add the password as shown below and your database should be working perfectly.
This way, your connection to the MySQL database should be working fine. Now that you're successfully connected, you can start executing queries, managing your data, and optimizing your database operations.