How to install MySQL ODBC Driver

MyODBC is an interface that allows programming languages to support the ODBC interface to communicate with a MySQL database. This guide helps you to install MyODBC and make the first steps with it.

To install ODBC driver please follow the steps below.

First download the ODBC driver for the MySQL server from the official page of the MySQL webpage. Then click on the installer file (Figure 1).

odbs installer
Figure 1 - ODBC installer

On the next page by clicking on the Next button, the installation can be started (Figure 2).

start installation
Figure 2 - Start the installation

After, you need to accept the license agreement (Figure 3).

accept license agreement
Figure 3 - Accept license agreement

On the next page choose the setup type that best suits your needs (Figure 4).

setup type
Figure 4 - Setup type

After choosing the setup type and clicking on the next button, you need to wait for the end of the installation (Figure 5).

wait for end of installation
Figure 5 - Wait for the end of the installation

If the installation is finished, end the installation by clicking on the Finish button (Figure 6).

finish installation
Figure 6 - Finish installation

After the installation, open the ODBC Data Source Administrator software, and add a new User Data Source by clicking on the Add button (Figure 7).

odbc data source administrator
Figure 7 - ODBC Data Source Administrator

On the next page, select the MySQL ODBC driver (Figure 8).

select mysql odbc driver
Figure 8 - Select the MySQL ODBC driver

Then, give the Data Source Name, the IP address of your MySQL server, the username and the password and the database name for the MySQL server (Figure 9).

connection parameters
Figure 9 - Connection Parameters

Clicking on the Test button, check whether the given parameters are correct or not (Figure 10).

connection test
Figure 10 - Connection Test

If the test was successful, click on the Ok button. If the name of the given user data source is in the list, your MySQL server is ready to wait the connection of an SQL API (Figure 11).

click on ok button
Figure 11 - Click on the Ok button

Finally, you are free to use your MySQL and the latest installed MyODBC. As a result, now, you have the chance to customize your PBX.

If you have any questions or need assistance, please contact us at info@ozekiphone.com.

More information