错误:“表'mysql.proc'不存在"将MySQL数据源添加到Visual Studio项目时 [英] Error: "Table 'mysql.proc' doesn't exist" when adding MySQL-Data Source to Visual Studio project

问题描述

我试图将MySQL数据源添加到我的Visual Studio项目中.

我正在使用MySQL Server 8.0.12和8.0.12 Connector/MySql.data.
在数据源配置向导"中，选择数据库对象时弹出错误:
从数据库检索信息时发生错误:表'mysql.proc'不存在"

I am trying to add a MySQL-Data Source to my Visual Studio project.

I am using MySQL Server 8.0.12 and also the 8.0.12 Connector/MySql.data.
In the Data Source Configuration Wizard an error pops up when choosing the database objects:
"An error occurred while retrieving the information from the database: Table 'mysql.proc' doesn't exist"

我已经尝试按照其他解决方案中的建议执行'mysql_upgrade.exe'，但是此特定表未受影响.然后我找到了这个博客文章:

I already tried executing the 'mysql_upgrade.exe' as suggested in other solutions but this specific table wasnt affected. Then i found this blogpost:

在MySQL 8.0中不再有mysql.proc

除了降级MySQL Server版本以外，是否有其他解决方法?

Is there any work-around for this except down-grading the MySQL Server version?

提前谢谢！

推荐答案

只需放 .c连接字符串中的CheckParameters=False;，即配置文件中的CheckParameters=False;.

Just put CheckParameters=False; in your .NET connection string i.e. in your config file.

无需降级MySQL服务器， 我想这是来自MySQL .NET连接器的错误.

No need to downgrade the MySQL server, I guess it is bug from MySQL .NET connector.

这篇关于错误:“表'mysql.proc'不存在"将MySQL数据源添加到Visual Studio项目时的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！