“MySqlException: Table ‘mysql.proc’ doesn’t exist” when running stored procedures from .NET Core

1.10K views
0

I am using ADO.NET data provider MySql.Data.MySqlClient to do database access in .NET Core and most things work, but whenever I try to access a stored procedure I see the following exception message:

MySql.Data.MySqlClient.MySqlException : Table ‘mysql.proc’ doesn’t exist
All of the articles I can find recommend running mysql_upgrade to fix the system tables, but this finds no problems.

And in fact the database does not contain a mysql.proc table – but it is not supposed to since it is MySQL 8.0!

I’ve installed the latest version of Connector/NET (8.0.15) using MySQL Installer.

What am I doing wrong?