MySQL ODBC creation

One. Create MySQL ODBC:

1. Start menu, Control Panel, and management tools:

Attention:

1). Data Source Name: This is the name of the code that accesses ODBC later. The specific use reference is later analyzed.

2). TCP/IP server: If you have a database server, enter the server IP, if it is native, enter: 127.0.0.1

3). Port: default is 3306 (but may change when MySQL is installed)

4). User:root (My SQL account)

5). Password: is the password to log in to MySQL

6. Database: MySQL databases created above, such as the test database

Two. Frequently asked questions:

If you are a 64-bit operating system, the default installation of Mysql-installer-community-5.6.26.0.msi is not to install Win32 ODBC, but I am in an ODBC data source (64-bit), when I create MySQL ODBC, I can't connect to MySQL, Therefore, you need to install Mysql-connector-odbc-5.3.4-win32.msi ODBC. Here's how:

Method One: Download the space download from my csdn:

1): http://download.csdn.net/detail/u013354805/9024697

Method Two: Download Win32 ODBC from the official website:

1): http://dev.mysql.com/downloads/connector/odbc/

Method Three: Download Win32 ODBC by installation:

1) Double-click the Mysql-installer-community-5.6.25.0.msi installation package

2) Select Mysql-connector-odbc-5.3.4-win32.msi ODBC for installation:

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

MySQL ODBC creation