MySQL Bugs: #98733: ERROR 1726 (HY000): Storage engine 'MyISAM' does not support system tables. [mys

Bug #98733	ERROR 1726 (HY000): Storage engine 'MyISAM' does not support system tables. [mys
Submitted:	25 Feb 2020 10:46	Modified:	26 Feb 2020 14:15
Reporter:	mohsen davari	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Security: Privileges	Severity:	S3 (Non-critical)
Version:	8.0.19	OS:	CentOS (7)
Assigned to:		CPU Architecture:	Any

Description:
hi
whene i want to set PRIVILEGES   it with command
GRANT ALL PRIVILEGES  ON `myuser%`.* TO  'myuser'@'192.168.51.%' ;

say error :

ERROR 1726 (HY000): Storage engine 'MyISAM' does not support system tables. [mysql.db]

=========================

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 601428
Server version: 8.0.19 MySQL Community Server - GPL

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Reading history-file /root/.mysql_history
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> FLUSH PRIVILEGES;
--------------
FLUSH PRIVILEGES
--------------

Query OK, 0 rows affected, 2 warnings (0.03 sec)

mysql>  GRANT ALL PRIVILEGES  ON `myuser%`.* TO  'myuser'@'192.168.51.%' ;
--------------
GRANT ALL PRIVILEGES  ON `myuser%`.* TO  'myuser'@'192.168.51.%'
--------------

ERROR 1726 (HY000): Storage engine 'MyISAM' does not support system tables. [mysql.db]

How to repeat:
run 
GRANT ALL PRIVILEGES  ON `myuser%`.* TO  'myuser'@'192.168.51.%' ;

Hi Mr. davari,

Thank you for your bug report.

Indeed, the error message is correct.

In 8.0 we have replaced all privilege tables, so those are now InnoDB tables in its tablespace.

Hence, this leads to the question on how have you upgraded from 5.7 to 8.0 and have you initialised data dictionary properly.

If you have not done that, please follow detailed instructions from our Reference Manual.

no i install a fresh mysql 8.0.19
it is fresh and new ( no upgrade )

whene i covert this table to innodb it say table is crupted!

Hi Mr. davari,

When you wrote that you converted a table to InnoDB, which table are you writing about ???

Also, how did you convert it ????

table mysql.db and  mysql.columns_priv

this query

alter table mysql.db ENGINE=InnoDB;
alter table mysql.columns_priv ENGINE=InnoDB;

Hi Mr. davari,

You simply are trying to run 8.0 over 5.7.

You must first pass the entire upgrade procedure that is described in our Reference Manual.

Those privilege tables that you are using simply do not exist any more in that form, in any 8.0.

can you send me a link . how can i fix it?
i install 5.7 and then  i remove 5.7 and then install 8.0.19 .
i can not understand why when i remove 5.7  and thene install 8.0.19 my privilage table is still from 5.7

Just follow the instructions found in chapter 2 of our 8.0 Reference Manual.