SSIS与MySQL的连接 [英] SSIS connection to MySQL

问题描述

您好，  

寻找有关为MySQL数据库创建SSIS连接管理器的帮助。 我试过以下但没有运气：

https://smallbusiness.chron.com/connect-mysql-ssis-60851.html

错误消息为：

由于初始化提供程序时出错，测试连接失败。使用方法'caching_sha2_password'对主机''for user'进行身份验证失败，并显示以下消息：用户使用密码拒绝访问：否

我的设置为：

Windows 10x64

Microsoft Visual Studio Enterprise 2017  

VisualStudio.15.Release / 15.9.11 + 28307.586
$
MySQL for Visual工作室    1.2.8

SQL Server数据工具    15.1.61903.01040

Microsoft SQL Server集成服务设计器

版本15.0.1100.123

MySQL连接器/网络8.0.16

MySQL社区服务器8.0.16
$


谢谢你，
Mike

解决方案

嗨  Mike，

我知道你是否设置了你的
MySQL连接字符串是否正确？

Server = myServerAddress; Database = myDataBase; Uid = myUsername; Pwd = myPassword;

最好的问候，

Mona Lv <强>

Hello,  
Looking for some help with creating an SSIS connection manager to a MySQL database.  I have tried the following with no luck:

https://smallbusiness.chron.com/connect-mysql-ssis-60851.html

The error message is:

Test connection failed because of an error in initializing provider. Authentication to host '' for user '' using method 'caching_sha2_password' failed with message: Access denied for user using password: NO

My setup is:

Windows 10x64
Microsoft Visual Studio Enterprise 2017  
VisualStudio.15.Release/15.9.11+28307.586
MySQL for Visual Studio   1.2.8
SQL Server Data Tools   15.1.61903.01040
Microsoft SQL Server Integration Services Designer
Version 15.0.1100.123
MySQL connector/Net 8.0.16
MySQL Community Server 8.0.16

Thanks
Mike

解决方案

Hi Mike,

May I know if you set your MySQL connection string correctly?

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

Best Regards,

Mona Lv

这篇关于SSIS与MySQL的连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！