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?