CODEWITHSUNDEEP
c#mysqlvisual-studio
tojan001
tojan001

Reputation: 11

Error: "Table 'mysql.proc' doesn't exist" when adding MySQL-Data Source to Visual Studio project

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"

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

No more mysql.proc in MySQL 8.0

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

Thanks in advance!

Upvotes: 1

Views: 6673

Answers (1)

Rahul Kanaujia
Rahul Kanaujia

Reputation: 31

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

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

Upvotes: 3

Related Questions