Use Access to log on to the Mysql database

Access Version: 2007-2010,64-bit

Mysql version: Ver 14.14 Distrib 5.6.12, for Win64 (x86_64)

1. Download the windows 64-bit Mysql driver

Official http://p2s.newhua.com/down/mysql-essential-5.1.40-win32.msi

Csdn resource http://download.csdn.net/detail/svap1/7212797

2. Install it by default.

3. Open access and select the external data menu-> ODBC database

4. Select "connect to the data source by creating a connection table" <Strong? Http: www.bkjia.com kf ware vc "target =" _ blank "class =" keylink "> VcD4KPHA + NaGi1NrOxLz + yv2 + 3dS00aHP7r + oyc/Qwr2o0ru49sGsvdM8L3A + cjxwpjxpbwcgc3jjjpq = "http://www.2cto.com/uploadfile/Collfiles/20140419/2014041909004029.jpg" alt = "\">

6. Select the connected Driver as Mysql ODBC5.3 Unicode Driver, click Next, and select the location and name of the DSN to be saved.

7. In the displayed dialog box, enter the connection information of the mysql database, such as the IP address, port, user name and password, and the name of the database to be selected.

8. After the configuration is successful, click OK. In the pop-up dialog box, select the data table to be connected. If you still want to configure the connection information, configure it again.

9. Click tablename in your database to view the data in the table.