I want to change the plugin for mysql user ERROR 1728 (HY000): Cannot load from mysql.user. The table is probably corrupted

Question

Answer 1

bobbyiliev March 20, 2021

Hi there,

You could check if this is indeed the case with the following query:

SHOW TABLE STATUS FROM `mysql`;

In case that you are using MyISAM, you could repair the table with the following command:

REPAIR TABLE mysql.user;

If you are using a DigitalOcean Managed Database Cluster, I could suggest raising a support ticket:

https://www.digitalocean.com/support/

Regards,
Bobby

Reply Report

Related