The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Error when updating MySQL

Discussion in 'Database Discussions' started by eashop, May 9, 2016.

  1. eashop

    eashop Registered

    Joined:
    Jun 18, 2011
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    # mysql_upgrade

    Code:
    Phase 1/6: Checking and upgrading mysql database
    
    Processing databases
    
    mysql
    
    mysql.column_stats                                 OK
    
    mysql.columns_priv                                 OK
    
    mysql.db                                           OK
    
    mysql.event                                        OK
    
    mysql.func                                         OK
    
    mysql.help_category                                OK
    
    mysql.help_keyword                                 OK
    
    mysql.help_relation                                OK
    
    mysql.help_topic                                   OK
    
    mysql.host                                         OK
    
    mysql.index_stats                                  OK
    
    mysql.ndb_binlog_index                             OK
    
    mysql.plugin                                       OK
    
    mysql.proc                                         OK
    
    mysql.procs_priv                                   OK
    
    mysql.proxies_priv                                 OK
    
    mysql.roles_mapping                                OK
    
    mysql.servers                                      OK
    
    mysql.table_stats                                  OK
    
    mysql.tables_priv                                  OK
    
    mysql.time_zone                                    OK
    
    mysql.time_zone_leap_second                        OK
    
    mysql.time_zone_name                               OK
    
    mysql.time_zone_transition                         OK
    
    mysql.time_zone_transition_type                    OK
    
    mysql.user                                         OK
    
    Phase 2/6: Fixing views
    
    Phase 3/6: Running 'mysql_fix_privilege_tables'
    
    ERROR 1005 (HY000) at line 64: Can't create table `mysql`.`innodb_table_stats` (errno: 165 "Table is read only")
    
    ERROR 1005 (HY000) at line 68: Can't create table `mysql`.`innodb_index_stats` (errno: 165 "Table is read only")
    
    ERROR 1005 (HY000) at line 136: Can't create table `mysql`.`gtid_slave_pos` (errno: 165 "Table is read only")
    
    ERROR 1146 (42S02) at line 581: Table 'mysql.innodb_index_stats' doesn't exist
    
    ERROR 1146 (42S02) at line 584: Table 'mysql.innodb_table_stats' doesn't exist
    
    FATAL ERROR: Upgrade failed
    
    
    
    Use :
    cloudlunux 7
    MySQL Governor and mariadb101
    
    
     
    #1 eashop, May 9, 2016
    Last edited by a moderator: May 9, 2016
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,689
    Likes Received:
    654
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page