mysql user表重置_MySQL忘记密码，重置密码，mysql.user表为空的解决办法

mysql> REPAIR TABLE mysql.user;

+------------+--------+----------+-------------------------------------------------+

| Table | Op | Msg_type | Msg_text |

+------------+--------+----------+-------------------------------------------------+

| mysql.user | repair | info | Wrong bytesec: 113-108- 95 at 396; Skipped |

| mysql.user | repair | info | Found block that points outside data file at 32 |

| mysql.user | repair | info | Found block that points outside data file at 36 |

| mysql.user | repair | info | Found block that points outside data file at 40 |

| mysql.user | repair | info | Found block that points outside data file at 44 |

| mysql.user | repair | info | Found block that points outside data file at 48 |

| mysql.user | repair | info | Found block that points outside data file at 52 |

| mysql.user | repair | info | Found block that points outside data file at 56 |

| mysql.user | repair | info | Found block that points outside data file at 60 |

| mysql.user | repair | warning | Number of rows changed from 4 to 3 |

| mysql.user | repair | status | OK |

+------------+--------+----------+-------------------------------------------------+

11 rows in set (0.64 sec)

# 再次查询user表

mysql> select Host,User,authentication_string from mysql.user;

+-----------+---------------+-------------------------------------------+

| Host | User | authentication_string |

+-----------+---------------+-------------------------------------------+

| localhost | mysql.session | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |

| localhost | mysql.sys | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |

| % | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |

+-----------+---------------+-------------------------------------------+

3 rows in set (0.00 sec)