Admin: MariaDB Configuration

This section describes how to create and configure a MariaDB Data Source Name (DSN).  

1. In a web browser, navigate to https://mariadb.com/downloads/#connectors to download the driver.  

2. In the download page, set product to ‘ODBC Connector’ and OS to ‘MS Windows 64-bit’. Click Download.

   

3. After downloading the file, go to the downloads folder. Locate and double-click the mlsqlodbc-1.4-6-amd64.msi file.  

4. In the MariaDB ODBC Driver 64-bit Setup Window, click Next and follow the required steps to install the driver.

   

5. Once you have successfully installed the ODBC driver, go to Control Panel\All Control Panel Items\Administrative Tools and click ODBC Data Sources (64-bit).

6. In the ODBC Data Source Administrator Window, click the System DSN tab.

7. Click the Add...button to create a new Data Source.

8. Find and select MariaDB ODBC 3.1 Driver and click Finish. 

   

9. In the MariaDB ODBC Data Source Wizard, provide a descriptive name for the Data Source and click the Next button. 

   

10. Provide the connection parameter details (Server Name, Port, Username, Password and Database).  The TCP/IP option must always be selected.  The default port is 4006; however, the port might change during configuration of your MariaDB cluster.  Click Test DSN to test the connection. Once the connection has been verified, click Next. 

    

11. The Enable automatic reconnect option must always be selected. The other options remain as is. Click Next. 

    

12. The Allow multiple statements option must always be selected. Click Next and click Finish.