Can't change root pw in mysql

Question

When I try to change the root pw in mysql with ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'myPassword';, I got the error message:

Storage engine 'MyISAM' does not support system tables.

So I used

alter table mysql.db ENGINE=InnoDB;

and

alter table mysql.columns_priv ENGINE=InnoDB;

as mentioned Here

Now I get the error

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

And repair table mysql.db can't fix it, cause the storage engine for the table doesn't support repair.

https://stackoverflow.com/questions/52867030/how-can-i-set-the-mysqls-password-in-the-mysqld-safe-is-running-scenario/52868910#52868910, use this link and don't forget to give upvote. — yusuf hayırsever, Jan 19 '21 at 09:53

score -1 · Accepted Answer · answered Jan 19 '21 at 09:52

-1

I just removed and re-installed mysql server. It's not a nice solution but it worked.

answered Jan 19 '21 at 09:52

why me

301
1
2
15

Can't change root pw in mysql

1 Answers1