EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 360+ Courses All in One Bundle
  • Login
Home Data Science Data Science Tutorials MySQL Tutorial MySQL ODBC Driver
Secondary Sidebar
MySQL Tutorial
  • Advanced
    • MySQL Formatter
    • MySQL TINYINT
    • MySQL Grant All Privileges
    • MySQL DROP TABLE
    • MySQL rename database
    • MySQL Flush Privileges
    • MySQL super Privilege
    • MySQL Character Set
    • MySQL Log File
    • MySQL Flush Log
    • Grant Privileges MySQL
    • MySQL WHILE LOOP
    • IF Statement in MySQL
    • MySQL CASE Statement
    • MySQL IF Function
    • MySQL IF EXISTS
    • MySQL UUID
    • Views in MySQL
    • MySQL Replication
    • MySQL Partition
    • Toad for MySQL
    • Navicat for MySQL
    • MySQL AES_Encrypt
    • MySQL Performance Tuning
    • MySQL Transaction
    • MySQL? sort_buffer_size
    • MySQL? Sync
    • MySQL? Query Cache
    • MySQL Collation
    • MySQL ODBC Driver
    • MySQL Partitioning
    • MySQL InnoDB
    • MySQL Float vs Decimal
    • MySQL Union vs Union All
  • Basic
    • MySQL floor
    • MySQL DESCRIBE table
    • MySQL encryption
    • Introduction to MySQL
    • Is SQL Server a Database?
    • What is MySQL
    • Is MySQL Programming Language
    • MySQL Server
    • MySQL AB
    • MySQL Community Server
    • How To Install MySQL
    • MySQL Versions
    • MySQL OpenSource
    • MySQL GUI Tools
    • MySQL Grant
    • MySQL Error 1064
    • MySQL Drop Database
    • MySQL not equal
    • MySQL SELECT INTO Variable
    • MySQL Commands
    • MySQL Operators
    • What is MySQL Schema
    • Wildcards in MySQL
    • MySQL Constraints
    • MySQL Administration
    • MySQL Data Type
    • MYSQL COMMIT
    • MySQL FORMAT
    • Timestamp to Date in MySQL
    • MySQL DATEDIFF
    • MySQL?Incremental Backup
    • MySQL JSON Data Type
    • MySQL ENUM
    • MySQL Default Port
    • Cheat Sheet MySQL
  • Queries
    • MySQL Queries
    • MySQL Query Commands
    • SELECT in MySQL
    • MySQL INSERT IGNORE
    • MySQL having
    • ORDER BY in MySQL
    • MySQL Cheat Sheet
    • MySQL ORDER BY Random
    • MySQL ORDER BY DESC
    • MySQL GROUP BY
    • MySQL GROUP BY Count
    • MySQL GROUP BY month
    • MySQL WHERE Clause
    • MySQL WITH
    • MySQL FETCH
    • MySQL DDL
    • MySQL DML
    • MySQL WHERE IN Array
    • MySQL Fetch Array
    • MySQL ISNULL
    • MySQL Index Types
    • Mysql? Export Schema
    • Amazon RDS for MySQL
    • MySQL greatest
  • Database
    • What is Data Modeling
    • What is Data Processing
    • DBMS Architecture
    • DBMS Keys
    • Careers in Database Administration
    • What is MySQL Database
    • MySQL Relational Database
    • How to Connect Database to MySQL
    • MySQL Database Repair
    • RDBMS Interview Questions
    • DBMS Interview Questions
  • Functions
    • MySQL Function
    • MySQL Aggregate Function
    • MySQL String functions
    • MySQL Date Functions
    • MySQL Window Functions
    • MySQL Math Functions
    • MySQL Boolean
    • Cursor in MySQL
    • Condition in MySQL
    • MySQL BETWEEN
    • Insert in MySQL
    • MySQL IFNULL()
    • MySQL TIMESTAMPDIFF()
    • MySQL COALESCE()
    • MySQL count()
    • MIN() in MySQL
    • MySQL Numeric
    • MySQL field()
    • MySQL FIND_IN_SET()
    • MySQL avg()
    • MySQL MAX() Function
    • MySQL BIN()
    • MySQL Concat
    • MySQL DECODE()
    • MySQL REGEXP_REPLACE()
    • MySQL Asynchronous
    • MySQL innodb_buffer_pool_size
    • MySQL key_buffer_size
    • MySQL TRUNCATE()
    • MySQL ROW_NUMBER()
    • NOT in MySQL
    • MySQL IN Operator
    • LIKE in MySQL
    • ANY in MySQL
    • MySQL NOT IN
    • MySQL CHECK Constraint
    • MySQL DISTINCT
    • MySQL ALL
    • MySQL Union
    • MySQL UNION ALL
    • MySQL EXISTS
    • MySQL ON DELETE CASCADE
    • MySQL REGEXP
    • MySQL Index
    • MySQL Add Index
    • MySQL REINDEX
    • MySQL UNIQUE INDEX
    • MySQL Clustered Index
    • MySQL? InnoDB Cluster
    • Table in MySQL
    • ALTER TABLE MySQL
    • MySQL Temporary Table
    • MySQL Clone Table
    • MySQL Repair Table
    • MySQL Lock Table
    • MySQL Optimize Table
    • TRUNCATE TABLE MySQL
    • MySQL Table Dump
    • MySQL Update Set
    • MySQL ALTER TABLE Add Column
    • MySQL RANK()
    • MySQL CTE
    • MySQL LAG()
    • MySQL GROUP_CONCAT()
    • MySQL EXTRACT()
    • MySQL REPLACE
    • MySQL AUTO_INCREMENT
    • MySQL SYSDATE()
    • MySQL NULLIF()
    • MySQL Substring
    • MySQL SUBSTRING_INDEX()
    • MySQL LOWERCASE
    • MySQL Row
    • MySQL NOW
    • MySQL CEIL
    • MySQL Alias
    • MySQL Trigger
    • MySQL SHOW Triggers
    • MySQL UPDATE Trigger
    • MySQL DELETE Trigger
    • MySQL AFTER UPDATE Trigger
    • MySQL Stored Procedure
    • ROLLUP in MySQL
    • MySQL? INSTR()
    • MySQL Subquery
    • MySQL Timestamp
    • MySQL? Hour()
    • MySQL MOD()
    • MySQL DATE_FORMAT()
    • ALTER Column in MySQL
    • MySQL Rename Column
    • MySQL Interval
    • MySQL CURDATE
    • MySQL BIT
    • MySQL Binlog
    • MySQL Average
    • MySQL TEXT
    • MySQL SHOW
    • MySQL Offset
    • MySQL Timezone
    • mysql_real_escape_string
    • MySQL Datetime
    • MySQL DATE_SUB()
    • MySQL FULLTEXT
    • MySQL DATE_ADD()
    • MySQL sum()
    • MySQL Merge
    • MySQL BigInt
    • MySQL ROUND
    • MySQL VARCHAR
    • MySQL Decimal
    • MySQL Limit
    • MySQL today()
    • MySQL WEEKDAY
    • MySQL Split
    • MySQL Create Function
    • MySQL BLOB
    • MySQL encode()
    • MySQL Primary Key
    • MySQL Foreign Key
    • Unique Key in MySQL
    • MySQL Drop Foreign Key
    • MySQL DROP TRIGGER
    • MYSQL Database
    • Delete Database MySQL
    • MySQL Root
    • MySQL Root Password
    • MySQL Client
    • MySQL Users
    • MySQL?User Permissions
    • MySQL add user
    • MySQL List User
    • MySQL Show Users
    • MySQL User Password
    • MySQL?Cardinality
    • MySQL Workbench
    • MySQL Backup
    • MySQL REVOKE
    • MySQL Dump
    • MySQL Cluster
    • MySQL Partitioning
    • MySQL Full Text Search
    • MySQL Admin Tool
    • MySQL Export Database
    • MySQL Export to CSV
  • Joins
    • Joins in MySQL
    • MySQL Outer Join
    • Left Outer Join in MySQL
    • MySQL Self Join
    • Natural Join in MySQL
    • MySQL DELETE JOIN
    • MySQL Update Join
    • MySQL Cross Join
  • Interview Questions
    • MySQL Interview Questions

Related Courses

MS SQL Certification Courses

Oracle Certification Courses

PL/SQL Certification Courses

MySQL ODBC Driver

By Payal UdhaniPayal Udhani

MySQL ODBC Driver

Introduction to MySQL ODBC Driver

ODBC or MySQL connector represents the collection of the MySQL ODBC drivers. MySQL ODBC drivers were called as myODBC drivers in the early days. MySQL ODBC driver is responsible for making it possible to access the MySQL database with the help of open database connectivity API (ODBC API). The latest version of ODBC i.e. ODBC 8.0 comes with the facility of having Unicode and ANSI driver. We can use the native interface of driver-manager based interfaces to connect to the MySQL database when we use the MySQL ODBC driver. This driver provides complete support for all the MySQL functionalities such as transaction and stored procedures. If we use an ODBC driver with a 5.1 or higher version, we also get complete Unicode compliance with MySQL.

When we use the Windows platform on our machine, we need to install the ODBC driver to connect to MySQL from a certain application. While using the Mac or Linux/Unix platform, named pipes of native MySQL network can be used for communication between the applications and MySQL database. Sometimes, the application that you are using on Linux/Unix or Mac os demands the usage of the ODBC interface to communicate with the database, at that time it is required to install the MySQL ODBC driver on that platforms too. Applications such as Filemaker Pro, Microsoft office and ColdFusion require ODBC for communication with MySQL.

Start Your Free Data Science Course

Hadoop, Data Science, Statistics & others

All in One Data Science Bundle(360+ Courses, 50+ projects)
Python TutorialMachine LearningAWSArtificial Intelligence
TableauR ProgrammingPowerBIDeep Learning
Price
View Courses
360+ Online Courses | 50+ projects | 1500+ Hours | Verifiable Certificates | Lifetime Access
4.7 (86,768 ratings)

Downloading ODBC Connector/Driver

You can download the latest version of the ODBC driver that will support your MySQL version for the platform you are using by going to the following link – https://downloads.MySQL.com/archives/c-ODBC/.

You need to specify the version of the ODBC driver you want to download and mention the operating system you are using and the version of the operating system. After choosing all these parameters, your file will be ready for download. All you need to do is to click on the download button. MySQL ODBC driver is licensed under GPL and is completely open-source. For windows machine, we have entered the following details as per my platform.

MySQL ODBC Driver 1

Installation Methods

You can install MySQL ODBC driver on your platform by using any one of the methods from the two methods mentioned below:

  • Binary Installation: This method is the most preferable and used most of the time because it is easy. All the libraries that are necessary for ODBC driver and other related files are pre-built. Along with that, there is a program for installation and scripts of the batch that can help to copy and configure the files and stuff automatically.
  • Source Installation: This method is used when you want to install the ODBC driver on the platform for which binary package for installation is not available or in some other case, suppose you want to make some changes into the installation process and customize the MySQL ODBC driver before installation.

Installation Steps

Given below are the installation steps:

Step #1 – Double-click on the file that is downloaded in MSI format. In my case, the file that got downloaded is named MySQL-connector-ODBC-5.3.2-win32.msi. The output that can be seen after double-clicking is as follows – Click on run.

MySQL ODBC Driver 2

Step #2 – Next, you will see setup of wizard for ODBC driver as shown below. Click on next.

MySQL ODBC Driver 3

Step #3 – Agree the license agreement and click on next.

MySQL ODBC Driver 4

Step #4 – You can choose any of the option as per your need – typical, custom or complete. Select Typical option and click on next.

MySQL ODBC Driver 5

Step #5 – There you go. Program is ready for installation. Click on the install button.

MySQL ODBC Driver 6

Step #6 – Now, click on the finish button to complete installation.

MySQL ODBC Driver 7

Configuration of ODBC Driver

After completing the installation, we will need to configure the ODBC driver and its related connections.

For this, we will need to follow the following steps:

Step #1

My platform is Windows 7, so to configure ODBC connections, Got to start button, click on it, and then choose Control Panel option. After that select System and Security option that further opens to a list from which we need to select Administrative Tools and then finally click Data Sources (ODBC). This will lead to pop up of the following window.

MySQL ODBC Driver 8

Step #2

Now, you will need to click on the Add button and select the ODBC 5.3 option from the list as shown below.

MySQL ODBC Driver 9

Step #3

After clicking on the finish button, you will need to specify the fields that will be needed for configuring the DSN connection using the window of connection parameters as shown below.

you will need to specify the fields that will be needed for configuring the DSN

  • Data Source Name: To access the data source with a particular name you will have to provide the name in the data source name field.
  • Description: In order to identify the connection for future use, you can add some descriptions in this input field.
  • TCP/IP Server: By default, localhost is used for accessing the database server. In case, you want to use some other host, then you can specify the server host of MySQL in this field.
  • User: This field is used to specify which user should be used while trying to connect with the database server of MySQL.
  • Password: You can enter the password for the MySQL database connection in this field.
  • Database: This field will display all the databases that will be allowed for access for the user that you have entered above. You can select the name of the database to which you want to connect in this field.
  • Port: 3306 is the default port that is used for the connection. For the port other than this you can mention the TCP/IP port in this field.

Step #4

Now, click on the test button after entering the above details to check whether the database connection is getting pinged properly as shown below.

to check whether the database connection is getting pinged properly

Step #5

If you want to enter other DSN details click on the details button located below as shown below.

want to enter other DSN details click on the details button

Step #6

You can even specify other network details related to secure socket layer by clicking on the ssl button shown below.

You can even specify other network details

The connection is now ready. You can use the connection in different applications such as Microsoft Excel, Word to connect the database and retrieve data and manipulate the same.

Conclusion

We can use the ODBC driver of MySQL to establish a connection with MySQL database from any many applications. You can easily install it when you want to use it by following the above steps in the windows platform.

Recommended Articles

This is a guide to MySQL ODBC Driver. Here we discuss how to download ODBC connector/driver, with installation methods, steps and configuration of ODBC driver. You may also have a look at the following articles to learn more –

  1. MySQL CTE
  2. MySQL CHECK Constraint
  3. MySQL Index
  4. MySQL Date Functions
Popular Course in this category
MySQL Training Program (12 Courses, 10 Projects)
  12 Online Courses |  10 Hands-on Projects |  92+ Hours |  Verifiable Certificate of Completion
4.5
Price

View Course

Related Courses

MS SQL Training (16 Courses, 11+ Projects)4.9
Oracle Training (14 Courses, 8+ Projects)4.8
PL SQL Training (4 Courses, 2+ Projects)4.7
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Database Management
  • Machine Learning
  • All Tutorials
Certification Courses
  • All Courses
  • Data Science Course - All in One Bundle
  • Machine Learning Course
  • Hadoop Certification Training
  • Cloud Computing Training Course
  • R Programming Course
  • AWS Training Course
  • SAS Training Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Data Science Course

SPSS, Data visualization with Python, Matplotlib Library, Seaborn Package

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more