title: phpMyAdmin error: I am seeing errors in user accounts
body: <p>This is my first xampp installation. In phpMyAdmin I am seeing following screen:</p>
  
  <p><a href="https://i.stack.imgur.com/kBfCd.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/kBfCd.jpg" alt="Here is screen shot"></a></p>
  
  <blockquote>
    <p>ave replication state from table mysql.gtid_slave_pos: 1146:</p>
    
    <p>@Z() mysqld.exe!?do_command@@YA_NPAVTHD@@@Z() mysqld.exe!?</p>
    
    <p>TIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYS</p>
    
    <p>see``, <code>Routine_name</code>, <code>Routine_type</code>) VALUES("ma_test_host"</p>
    
    <p>umm last_update in table "mysql"."innodb_table_stats" is BIN</p>
    
    <p>x_threads=501 thread_count=2 It is possible that mysql co</p>
    
    <p>exe!my_security_attr_free() mysql.exe!simple_key_cache_rea</p>
    
    <p>abort. Query (0x106e2f50): FLUSH PRIVILEGES Connection ID</p>
    
    <p>'ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CR</p>
    
    <p>iv<code>(</code>host<code>,</code>Db<code>,</code>User<code>,</code>Routine_name<code>,</code>Routine_type`) VA</p>
    
    <p>,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_c</p>
    
    <p>RROR] Missing system table mysql.roles_mapping; please run m</p>
    
    <p>b50 InnoDB: Error: Column last_update in table "mysql"."inno</p>
    
    <p>localhost</p>
    
    <p>or misconfigured. This error can also be caused by malfunc
    127.0.0.1 DB: Error: Column last_update in table "mysql"."innodb_table e '.\mysql\procs_priv.MYI'; try to repair it 151101 21:18:0
    md_resignal@@UBE?AW4enum_sql_command@@XZ() mysqld.exe!?ha_i</p>
  </blockquote>
  
  <p>I googled and found this <a href="http://forum.wampserver.com/read.php?2,45994,46038" rel="nofollow noreferrer">link</a> but when am going to mysql website then there I am seeing 5.7x version</p>
  
  <p><strong>UPDATE:</strong>
  I installed Xampp and I can see localhost. The Xampp starts apache + MySQL with no errors but when I click ==>phpMyAdmin ==> User Accounts then I was seeing aforementioned error.</p>
  
  <p>Today when I restarted my laptop and again gone to phpMyAdmin==> user accounts then I am seeing SQL error:</p>
  
  <pre><code>(SELECT DISTINCT `User`, `Host` FROM `mysql`.`user`) UNION (SELECT DISTINCT `User`, `Host` FROM `mysql`.`db`) UNION (SELECT DISTINCT `User`, `Host` FROM `mysql`.`tables_priv`) UNION (SELECT DISTINCT `User`, `Host` FROM `mysql`.`columns_priv`) UNION (SELECT DISTINCT `User`, `Host` FROM `mysql`.`procs_priv`) ORDER BY `User` ASC, `Host` ASCrr
  </code></pre>
  
  <blockquote>
    <p>Error
        Static analysis:</p>
  
  <pre><code>5 errors were found during analysis.
  
  Unexpected closing bracket. (near ")" at position 51)
  Unexpected closing bracket. (near ")" at position 108)
  Unexpected closing bracket. (near ")" at position 174)
  Unexpected closing bracket. (near ")" at position 241)
  Unexpected closing bracket. (near ")" at position 306)
  SQL query: Documentation
  
  (SELECT DISTINCT `User`, `Host` FROM `mysql`.`user`) UNION (SELECT DISTINCT `User`, `Host` FROM `mysql`.`db`) UNION (SELECT DISTINCT
  </code></pre>
    
    <p><code>User</code>, <code>Host</code> FROM <code>mysql</code>.<code>tables_priv</code>) UNION (SELECT DISTINCT
    <code>User</code>, <code>Host</code> FROM <code>mysql</code>.<code>columns_priv</code>) UNION (SELECT DISTINCT
    <code>User</code>, <code>Host</code> FROM <code>mysql</code>.<code>procs_priv</code>) ORDER BY <code>User</code> ASC, <code>Host</code>
    ASC LIMIT 0, 25</p>
  
  <pre><code>MySQL said: Documentation
  
  #126 - Incorrect key file for table '.\mysql\user.MYI'; try to repair it
  </code></pre>
  </blockquote>
  
  <p><strong>UPDATE-1:</strong>
  I again restarted and seeing the following:</p>
  
  <blockquote>
    <p>Warning in .\libraries\dbi\DBIMysqli.class.php#261  mysqli_query():
    (HY000/1030): Got error 9 &quot;Bad file descriptor&quot; from storage
    engine MyISAM</p>
    
    <p>Backtrace</p>
    
    <p>.\libraries\dbi\DBIMysqli.class.php#261: mysqli_query( object, string
    'SELECT * FROM <code>mysql</code>.<code>db</code> LIMIT 1', integer 0, )
    .\libraries\DatabaseInterface.class.php#246:
    PMA_DBI_Mysqli->realQuery( string 'SELECT * FROM <code>mysql</code>.<code>db</code> LIMIT
    1', object, integer 0, ) .\libraries\check_user_privileges.lib.php#46:
    PMA_DatabaseInterface->tryQuery(string 'SELECT * FROM <code>mysql</code>.<code>db</code>
    LIMIT 1') .\libraries\check_user_privileges.lib.php#395:
    PMA_checkRequiredPrivilgesForAdjust()
    .\libraries\List_Database.class.php#17:
    require_once(.\libraries\check_user_privileges.lib.php)
    .\libraries\PMA.php#17:
    require_once(.\libraries\List_Database.class.php)
    .\libraries\common.inc.php#1089: include_once(.\libraries\PMA.php)
    .\server_privileges.php#12: require_once(.\libraries\common.inc.php)
    Please advise</p>
  </blockquote>
  
  <p>Thanks in anticipation</p>