Repair Table 'global_priv' is corrupt; In PHPMYADMIN

 Error : Warning in .\libraries\classes\Dbal\DbiMysqli.php#209 mysqli::query(): (HY000/1034): Index for table 'global_priv' is corrupt; try to repair it Backtrace DbiMysqli.php#209: mysqli->query( string 'SELECT 1 FROM mysql.user LIMIT 1', integer 0, ) DatabaseInterface.php#219: PhpMyAdmin\Dbal\DbiMysqli->realQuery( string 'SELECT 1 FROM mysql.user LIMIT 1', , integer 0, ) DatabaseInterface.php#1713: PhpMyAdmin\DatabaseInterface->tryQuery(string 'SELECT 1 FROM mysql.user LIMIT 1') Menu.php#464: PhpMyAdmin\DatabaseInterface->isSuperUser() Menu.php#97: PhpMyAdmin\Menu->getServerTabs() Menu.php#72: PhpMyAdmin\Menu->getMenu() ResponseRenderer.php#332: PhpMyAdmin\Menu->getDisplay() ResponseRenderer.php#409: PhpMyAdmin\ResponseRenderer->ajaxResponse() PhpMyAdmin\ResponseRenderer->response()


  • Select the mysql system database:

    sql
    USE mysql;
  • Check the global_priv table for corruption:


    CHECK TABLE global_priv;
  • Repair the table if it is corrupted:


    REPAIR TABLE global_priv;
  • No comments:

    Post a Comment

    Pages