下载
进到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>