• Vicențiu Ciorbaru's avatar
    MDEV-11170: MariaDB 10.2 cannot start on MySQL 5.7 datadir: · fdfdea40
    Vicențiu Ciorbaru authored
    Fatal error: mysql.user table is damaged or in unsupported 3.20 format
    
    The problem stems from MySQL 5.7.6. According to MySQL documentation:
    In MySQL 5.7.6, the Password column was removed and all credentials are
    stored in the authentication_string column.
    
    If opening a MySQL 5.7.6 (and up) datadir with MariaDB 10.2, the user table
    appears corrupted. In order to fix this, the server must be started with
    --skip-grant-tables and then a subsequent mysql_upgrade command must be
    issued.
    
    This patch updates the mysql_upgrade command to also add the removed
    Password column. The password column is necessary, otherwise
    the mysql_upgrade script fails due to the Event_scheduler not being able
    to start, as it can't find Event_priv in the table where it ought to be.
    MySQL's version has column position 28 (0 index) vs our datadir version
    expects position 29.
    fdfdea40
mysql_system_tables_fix.sql 34 KB