Introduction to MySQL ODBC driver

ODBC or MySQL Connector representation MySQL ODBC A collection of drivers .MySQL ODBC Drivers were called in the early days myODBC The driver .MySQL ODBC The driver is responsible for connecting to the open database API (ODBC API) With the help of MySQL database . Latest version ODBC namely ODBC 8.0 with Unicode and ANSI The driver . When we use MySQL ODBC Driver , We can connect to... Using a native interface based on the driver manager interface MySQL database . The driver is for all MySQL Function provides complete support , For example, transactions and stored procedures . If we use 5.1 Or later ODBC The driver , We can also fully meet MySQL Of Unicode.

When we use on our machines Windows Platform time , We need to install ODBC Drivers can connect from an application to MySQL. In the use of Mac or Linux/Unix Platform time , Local MySQL Named pipes for networks can be used for applications and MySQL Communication between databases . Sometimes , You are in Linux/Unix or Mac os Applications used on need to use ODBC Interface and database communication , At this time, you also need to install... On the platform MySQL ODBC The driver .Filemaker Pro、Microsoft office and ColdFusion And other applications need ODBC Talent and MySQL communicate .

download ODBC The connector / The driver

You can download the latest version of ODBC The driver , The driver will support the platform you are using MySQL edition – https://downloads.MySQL.com/archives/c-ODBC/.

You need to specify what to download ODBC The version of the driver , And mention the operating system you are using and the version of the operating system . After selecting all these parameters , Your file can be downloaded . All you need to do is click the download button .MySQL ODBC Driver in GPL Get permission under , And it's completely open source . about windows machine , We entered the following details according to my platform .

Installation method

You can use either of the following two methods to install... On your platform MySQL ODBC The driver ：

• Binary installation ： This method is the most desirable , And use it most of the time , Because it's easy .ODBC All libraries required for drivers and other related files are pre built . besides , There is also an installer and batch script , Can help automatically copy and configure files and content .
• Source code installation ： When you want to install on a platform without binary packages ODBC Drive or other circumstances , Suppose you want to make some changes to the installation process , Customize MySQL ODBC Before drive installation .

install step

Here are the installation steps ：

step #1 – Double click to MSI File downloaded in format . As far as I'm concerned , The downloaded file is called MySQL-connector-ODBC-5.3.2-win32.msi. After double clicking, you can see the output as follows —— Click on the run .

step #2 – Next , You will see ODBC Driver wizard settings , As shown below . Click next .

step #3 – Agree to the license agreement , Then click next .

step #4 – You can choose any option you want - Typical 、 Custom or complete . Choose typical options , Then click next .

step #5 - You go . The program is ready to install . Click the Install button .

step #6 – Now? , Click the finish button to complete the installation .

ODBC Driver configuration

After installation , We need to configure ODBC Drivers and their associated connections .

So , We need to perform the following steps ：

The first 1 Step

My platform is Windows 7, So configure ODBC Connect , Need start button , Click it , Then select control panel options . Then select system and security options , Further open a list , We need to choose management tools , Then, finally, click data source (ODBC). This will cause the following window to pop up .

The first 2 Step

Now? , You need to click the Add button and select... From the list ODBC 5.3 Options , As shown below .

step #3

When you click the finish button , You need to specify the configuration using the connection parameters window shown below DSN Fields required for connection .

• Data source name ： To access a data source with a specific name , You must provide a name in the data source name field .
• describe ： To identify connections for future use , You can add some descriptions in this input field .
• TCP/IP The server ： By default ,localhost Used to access the database server . If you want to use another host , You can specify... In this field MySQL Server host for .
• user ： This field is used to specify when trying to connect MySQL Which user should be used for the database server of .
• password ： You can enter... In this field MySQL Password for database connection .
• database ： This field will display all databases that the user you entered above is allowed to access . You can select the name of the database to connect to in this field .
• port ： 3306 Is the default port for connection . For other ports , You can mention... In this field TCP/IP port .

The first 4 Step

Now? , After entering the above details, click the test button , Check whether the database connection is correct ping , As shown below .

step #5

If you want to enter another DSN Details , Please click the details button below , As shown below .

step #6

You can even click the... Shown below ssl Button to specify other network details related to the secure socket layer .

The connection is now ready . You can go to Microsoft Excel、Word And other different applications use connections to connect to the database, retrieve data and operate on it .

Conclusion

We can use MySQL Of ODBC Drivers are built from any number of applications MySQL Database connection . stay windows Follow the above steps on the platform , You can easily install it when you want to use it .