How to repaire global_priv mysql

Question

When I try to add User account in phpmyadmin then the error appear

Error Message: Index for table 'global_priv' is corrupt; try to repair it

Answer 1

select table mysql and then type this query CHECK TABLE global_priv

Answer 2

I had to reinstall the XAMPP and the problem has been solved

Answer 3

I´m using HeidiSQL. Select mysql Database. Right Click, Click on Maintenance Select Operation = Repair. Click on Execute.

That solved the problem for me.

Answer 4

In my case, mysql doesn't start because of this table corruption, so one cannot run any query on it.

Try to copy table files from initial backup.

Table files are \data\mysql\global_priv.*, move them aside.

Table files backup are \backup\mysql\global_priv.*, copy them to data\mysql.

This should be enough to start mysql service, but all custom global privileges will be lost.