MySQL Forums
Forum List  »  MySQL Workbench

MySQL 8 on Ubuntu 20.04
Posted by: Mamadou Hady Diallo
Date: June 14, 2020 08:37PM

Hello I'm fan of MySQL.
I was using 5.7 on my Ubuntu 19.04 and previous.
And now I install the ubuntu 20.04 on a new machine and I installed MySQL 8 on it.
I exported all my db on my old old laptop by typing
"mysql -u ... -p ... > /path/to/export".
And I imported succesfuly the file in my MySQL 8.
But now when i tried to create new user i got an error :

"Storage engine 'MyISAM' does not support system tables. [mysql.db]"

I solved it by typing :

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

after that i retry creating user and i got an another error:

"Cannot load from mysql.db. The table is probably corrupted"

Please need help...

Options: ReplyQuote

Written By
MySQL 8 on Ubuntu 20.04
June 14, 2020 08:37PM
June 14, 2020 08:55PM

Sorry, only registered users may post in this forum.

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.