signed

QiShunwang

“诚信为本、客户至上”

MySQL | MySQL Connector/ODBC zip安装

2021/5/14 22:40:11   来源:

下载

进到MySQL官网下载对应平台和位版本的驱动程序
https://dev.mysql.com/downloads/connector/odbc/
在这里插入图片描述
解压到对应文件夹

环境配置

1、配置环境变量
系统-高级系统设置-环境变量-Path-新建
将bin文件目录加入到环境变量
在这里插入图片描述

安装

以管理员身份打开CMD

##进入到驱动程序解压的文件夹
C:\WINDOWS\system32>cd F:\MYSQL\mysql-connector-odbc-noinstall-8.0.25-winx64\lib
C:\WINDOWS\system32>f:

## 复制相应文件到c:\Windows\System32
F:\MYSQL\mysql-connector-odbc-noinstall-8.0.25-winx64\lib>copy   myodbc8S.dll    c:\Windows\System32
已复制         1 个文件。
F:\MYSQL\mysql-connector-odbc-noinstall-8.0.25-winx64\lib>copy   myodbc8S.lib    c:\Windows\System32
已复制         1 个文件。
## Registering Unicode driver
F:\MYSQL\mysql-connector-odbc-noinstall-8.0.25-winx64\lib>copy   myodbc8w.dll   c:\Windows\System32
已复制         1 个文件。
F:\MYSQL\mysql-connector-odbc-noinstall-8.0.25-winx64\lib>copy   myodbc8w.lib   c:\Windows\System32
已复制         1 个文件。
## Registering ANSI driver
F:\MYSQL\mysql-connector-odbc-noinstall-8.0.25-winx64\lib>copy   myodbc8a.dll   c:\Windows\System32
已复制         1 个文件。
F:\MYSQL\mysql-connector-odbc-noinstall-8.0.25-winx64\lib>copy   myodbc8a.lib   c:\Windows\System32
已复制         1 个文件。
F:\MYSQL\mysql-connector-odbc-noinstall-8.0.25-winx64\lib>cd ..

F:\MYSQL\mysql-connector-odbc-noinstall-8.0.25-winx64>install.bat
Registering Unicode driver
Checking if "MySQL ODBC 8.0 Unicode Driver" is not already registered
Registering "MySQL ODBC 8.0 Unicode Driver"
Success: Usage count is 1
Registering ANSI driver
Checking if "MySQL ODBC 8.0 ANSI Driver" is not already registered
Registering "MySQL ODBC 8.0 ANSI Driver"
Success: Usage count is 1
+-----------------------------------------------------+
| DONE                                                |
+-----------------------------------------------------+
|                                                     |
| Hopefully things went well; the Connector/ODBC      |
| driver has been registered.                         |
|                                                     |
| Connector/ODBC is ready to use.                     |
|                                                     |
| The most common thing to do next is to go to the    |
| Control Panel and find the ODBC Administrator -     |
| then use it to create a Data Source Name (DSN)      |
| so you (and your application) can connect to a      |
| MySQL server.                                       |
|                                                     |
| Alternatively you can use the MyODBC Installer      |
| utility to define data sources.                     |
|                                                     |
+-----------------------------------------------------+

F:\MYSQL\mysql-connector-odbc-noinstall-8.0.25-winx64>