ERROR Index for table 'global priv' is corrupt; try to repair it while selecting MySQL user

Published: 08 May 2023
on channel: CodeIntro
349
0

In this video, solution for this error, ERROR: 1034 (HY000) Index for table 'global_priv' is corrupt; try to repair it while selecting MySQL user(s); MySQL phpmyadmin MariaDB command-line CMD
#dcl #mysql #phpmyadmin

Run query / command
1- REPAIR TABLE mysql.db;
2- REPAIR TABLE mysql.user;

select corrupt tables & then check all tables.
& then select "Repair table" from "Table Maintenance" Group.

To show all mysql user (localhost user)
Run command to show user:
SELECT host, user FROM mysql.user;


error 'mysql.user' is index table 'global priv is corrupt,
'mysql.user' is not of type 'base table' status operation failed,
mysql fix corrupt table,
#ERROR 1034 (HY000) can't find record in 'global_priv',
mysql repair corrupt index,
how to check corrupted tables in mysql,
SQL DCL command to show all user,


Watch video ERROR Index for table 'global priv' is corrupt; try to repair it while selecting MySQL user online without registration, duration hours minute second in high quality. This video was added by user CodeIntro 08 May 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 349 once and liked it 0 people.