How to Set ODBC MySQL Driver

Follow this step by step tutorial to learn how to setup MySql ODBC driver for windows and how it is configured.

Don't forget to check out our site http://howtech.tv/ for more free how-to videos!
http://youtube.com/ithowtovids - our feed
http://www.facebook.com/howtechtv - join us on facebook
https://plus.google.com/103440382717658277879 - our group in Google+

ODBC stands for Open Database Connectivity. It is used to provide a connection for the database. It acts like a bridge between the database manager and the Operating System. With this driver installed and configured, we can use our database with various applications such as spreadsheets, reporting tools or various other software suits.
In this tutorial we will learn to set up the same my sql ODBC driver

Step 1- Download
First, let's download my sql ODBC driver. It can be downloaded from dev.mysql.com.
Over there, choose the version according to the operating system we are running. For this tutorial, we will be setting the ODBC MySQL driver in windows.

Step 2- Installation
After finishing with the download, run the setup for installation. Just follow the step by step process of the installation wizard to install the driver.

Step 3- System Settings
After the installation, we have to configure the connection.
For that, open up the Control panel and click on the System and Security option.

Step 4-Admin tools
A window will open up with several options in it, open up the Administrative Tools option from there.

Step 5-Data Source
All of the Administrative tools would be displayed in a separate window. We have to setup our database connection, so for that click ODBC Data Sources option.

Step 6- Adding System DSN
A window will open up having different tabs in it. Choose System DSN tab and then click Add button on right.

Step 7- Choosing ODBC option
A window will open up having the list of ODBC drivers in it. As we have to configure our ODBC driver for MySQL, choose My SQL ODBC Driver option and click on Finish.

Step 8-Configuring the Connection
With that done, the odbc mysql configuration window will open up. In that window, give the data source a name, if MySQL instance is installed in the same pc in which we are setting up the ODBC driver, give "localhost" as a name of TCP IP server and leave the port as default.
Give the appropriate user name for which you have granted access to your database, here let us assign "root" in user as it has access to all the databases by default and leave password field blank as root is configured with empty password by default.
After that, we have to choose the required database which we want to be linked through this connection from the databases drop down menu in the bottom.
After that, click OK button.

Step 9- Connection Appeared In List
The connection would appear in the System DSN Connections list. This connection basically contains the information of the server on which MySQL is installed and the database which has to be used.

And this is how MySQL ODBC driver is setup in windows.

---

Closed Caption:

in this tutorial we will teach you how
to set the odbc mysql driver odbc stands
for open database connectivity it is
used to provide a connection to your
database and acts like a bridge between
your database manager which in this case
would be mysql and the operating system
with this driver installed and
configured you can use your database
with various applications such as
spreadsheets reporting tools and
software etc
first let's download the odbc driver you
can download it from dev . mysql calm
over here you have to choose the version
according to the operating system you
are currently running for this tutorial
we will be setting the odbc mysql driver
in windows after finishing with the
download run the setup for installation
just follow the step-by-step process of
the installation wizard to install the
driver
with that done you will need to
configure the connection for that open
up the control panel and click on the
system and security option after that
move to the administrative tools option
and then click on the ODBC data sources
option with the new window opened up
move to the system DSN tab and click on
the Add button after that choose mysql
odbc driver from the list and click on
finish with that done the mysql
configuration window will open up in
that window
give your data source name if mysql
instances installed in the same pc in
which you are setting up the odbc driver
give local host as a name of your tcp/ip
server and leave the port as default
with that done give the appropriate user
name for which you have granted access
to your database here let us assign
route in user as it has access to all
the databases by default and leave
password field blank as root is
configured with empty passwords by
default after that's done click test
button below a message will pop up
confirming that the connection is
successful
now open up the drop-down menu from the
databases field and choose the required
database which you want to be linked
through this connection with that done
click on OK and the connection will
appear in the list of system data
sources and that's it
the odbc mysql driver is now configured
in windows