MySQL Forums
Forum List  »  Stored Procedures

Advanced Search
New Topic

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”.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
ERROR 1146 on first attempt to drop a stored procedure (MySQL 8.0.3)
4461
Homer White
January 02, 2018 08:40PM
Re: ERROR 1146 on first attempt to drop a stored procedure (MySQL 8.0.3)
996
Homer White
January 02, 2018 08:46PM
Re: ERROR 1146 on first attempt to drop a stored procedure (MySQL 8.0.3)
1376
Peter Brawley
January 02, 2018 10:35PM
Re: ERROR 1146 on first attempt to drop a stored procedure (MySQL 8.0.3)
1034
Homer White
January 03, 2018 06:54AM
ERROR 1146 (42S02): Table 'mysql.role_edges' doesn't exist
16546
no name zzzzz
January 08, 2018 07:05AM
Re: ERROR 1146 (42S02): Table 'mysql.role_edges' doesn't exist
8220
Homer White
January 08, 2018 08:48AM


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.