Infolinks

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.
MySQL ODBC Connector used by Jcyberinux
2. On Control Panel, double click Administrative Tools.
MySQL ODBC Connector used by Jcyberinux
3. On Administrative Tools, double click Data Sources (ODBC).
MySQL ODBC Connector used by Jcyberinux
4. On Data Sources (ODBC), click Add…
MySQL ODBC Connector used by Jcyberinux
5. On Create New Data Source, choose MySQL ODBC 5.1 Driver, click Finish .
MySQL ODBC Connector used by Jcyberinux
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.
MySQL ODBC Connector used by Jcyberinux
(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)
MySQL ODBC Connector used by Jcyberinux

 

7. Click OK to Add the New Data Source, then from there, you will able to see newly created Data Source.
MySQL ODBC Connector used by Jcyberinux

 

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

Related Posts Plugin for WordPress, Blogger...
Share
2 thoughts on “How to use MySQL ODBC Connector via localhost on Windows”
  1. 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!

  2. 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.

Comments are closed.