How to use MySQL ODBC Connector via localhost on Windows
by: Revengsky Joseph D. Reyes (a.k.a.rjdreyes)
Recently, I work with a special project, making a customer/client database system, using Visual Basic and MySQL Database Server. To connect within Visual Basic to MySQL Database Server, you need an MySQL ODBC Connector, which is a database driver for Windows, Linux, Mac OS X, and Unix platforms. It also allows you to connect and managed your database.
( Note : I’m using WAMP Server and Navicat Lite as my Database Administrator Tools. If you don’t have yet a MySQL Database Server, you can used WAMP, easy to install and Navicat Lite for easy to import and export databases.)
Instructions on How to Install WAMP on Windows click here
Instructions on How to Install Navicat Lite on Windows click here
Instructions on How to use Navicat Lite for MySQL Connection via localhost click here
Instructions on How to setup / install MySQL ODBC Connector on Windows click here
Here’s the steps on How to use MySQL ODBC Connector via localhost to use it on your Data Source.
(Note : Procedures my vary, depends on the version of MySQL ODBC Connector)
1. On Windows, click Start, the Settings, click to Control Panel.
2. On Control Panel, double click Administrative Tools.
3. On Administrative Tools, double click Data Sources (ODBC).
4. On Data Sources (ODBC), click Add…
5. On Create New Data Source, choose MySQL ODBC 5.1 Driver, click Finish .
6. On MySQL Connector/ODBC, you need to fill the connection parameters information. (1), Data Source Name, (this will be the name to be invoke, by your particular programming syntax, sql query, etc… meaning this will be your connection name).
(2), is the Description, (brief information about particular database / project).
(3), TCP/IP – (will be the hostname of your MySQL server, usually by default it is localhost), the Port – 3306, if you didn’t change it on your MySQL server port (again, usually this is the default value).
(4), is the User, the username used to connect on MySQL Server / database. (by default you can used root, but in production side, you should add a particular user on a particular database, for security reason).
(5), is the Password, the password of the particular user. (if so happen you didn’t put any password on your root or username just leave it blank. In production sense, again, you should have a password, or else, there is a big hole security risk).
(6) If you put the correct connection parameters on previous, you should now see your Database(s), were in, this will be the database you will goin to select and use on your project.
(7) After all set, Test your connection by clicking Test. (You should see connection successful). If not repeat the process until you got it right. (click ok after the test connection)
7. Click OK to Add the New Data Source, then from there, you will able to see newly created Data Source.
I hope this helps you out. 🙂 Cheers!
100% FREE, Freeware and an open source database driver for your DBMS development.
Related References:
MySQL Official Site
Download MySQL Connector/ODBC Official Site
MySQL ODBC CONNECTOR – an open source database driver by Jcyberinux
How to setup / install MySQL ODBC Connector by Jcyberinux
How to Install WAMP on Windows by Jcyberinux
How to Install Navicat Lite on Windows by Jcyberinux
How to use Navicat Lite for MySQL Connection via localhost by Jcyberinux
WAMP Official Site
Download WAMP
WAMP – Superb Web Development Tools by Jcyberinux
How to Install WAMP on Windows by Jcyberinux
Download Navicat Lite Official Site

Hi I stumbled upon your webpage by mistake when i was searching AOL for this issue, I need to say your site is quite helpful I also really like the layout, it is beautiful!
Its such as you learn my thoughts! You appear to understand so much about this, such as you wrote the guide in it or something. I feel that you just could do with a few % to force the message house a bit, however other than that, that is excellent blog. A great read. I’ll certainly be back.