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:
Category:MySQL Server: Security: Privileges Severity:S3 (Non-critical)
Version:8.0.19 OS:CentOS (7)
Assigned to: CPU Architecture:Any

[25 Feb 2020 10:46] mohsen davari
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

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


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:
GRANT ALL PRIVILEGES  ON `myuser%`.* TO  'myuser'@'192.168.51.%' ;
[25 Feb 2020 15:06] MySQL Verification Team
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.
[25 Feb 2020 16:48] mohsen davari
no i install a fresh mysql 8.0.19
it is fresh and new ( no upgrade )
[25 Feb 2020 16:58] mohsen davari
whene i covert this table to innodb it say table is crupted!
[26 Feb 2020 12:53] MySQL Verification Team
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 ????
[26 Feb 2020 14:00] mohsen davari
table mysql.db and  mysql.columns_priv

this query

alter table mysql.db ENGINE=InnoDB;
alter table mysql.columns_priv ENGINE=InnoDB;
[26 Feb 2020 14:03] MySQL Verification Team
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.
[26 Feb 2020 14:15] mohsen davari
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
[26 Feb 2020 14:22] MySQL Verification Team
Just follow the instructions found in chapter 2 of our 8.0 Reference Manual.