Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-26925

Failure when using mysql_upgrade if 'root'@'localhost' does not exist

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 10.6.4
    • 10.6.6
    • Upgrades
    • None

    Description

      mysql> mysql_upgrade -u*** -p --socket=/tmp/mysql.sock1 --force -s
      Enter password:
      The --upgrade-system-tables option was used, user tables won't be touched.
      Phase 1/7: Checking and upgrading mysql database
      Processing databases
      mysql
      mysql.column_stats OK
      mysql.columns_priv OK
      ...
      mysql.transaction_registry OK
      Phase 2/7: Installing used storage engines... Skipped
      Phase 3/7: Fixing views... Skipped
      Phase 4/7: Running 'mysql_fix_privilege_tables'
      ERROR 1449 (HY000) at line 832: The user specified as a definer ('root'@'localhost') does not exist
      FATAL ERROR: Upgrade failed
      

      If you do not use "force", the upgrade runs, but then setting a new value in SYS_CONFIG gives an error:

      MariaDB [sys]> update sys_config set value = 128 where variable = 'statement_truncate_len';
      ERROR 1449 (HY000): The user specified as a definer ('root'@'localhost') does not exist
      

      Attachments

        Activity

          People

            wlad Vladislav Vaintroub
            mpflaum Maria M Pflaum
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.