MySQL Forums
Forum List  »  Stored Procedures

Re: ERROR 1146 on first attempt to drop a stored procedure (MySQL 8.0.3)
Posted by: Peter Brawley
Date: January 02, 2018 10:35PM

MySQL can't find mysql.role_edges, which should exist. As https://dev.mysql.com/doc/refman/8.0/en/system-database.html says ...

If MySQL is upgraded from an older version but the grant tables have not been upgraded from MyISAM to InnoDB, the server considers them read only and account-management statements produce an error. For upgrade instructions, see Section 2.10.1, “Upgrading MySQL”.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: ERROR 1146 on first attempt to drop a stored procedure (MySQL 8.0.3)
1059
January 02, 2018 10:35PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.