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

remove scripts/mysql_to_mariadb.sql

    XMLWordPrintable

    Details

      Description

      This script is unused and unmaintained.

      The logic is implemented in scripts/mysql_system_tables_fix.sql that forms part of mysql_upgrade

      Its components

      alter table mysql.user drop column `password_last_changed`, drop column `password_lifetime`, drop column `account_locked`;
      

      has a friendlier migration path currrently in review in MDEV-24122

      -- Change existing columns
      alter table mysql.user change column `authentication_string` `auth_string` text COLLATE utf8_bin NOT NULL;
      

      Already part of scripts/mysql_system_tables_fix.sql

      -- Add new columns
      alter table mysql.user add column  `Password` char(41) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '' after `user`, add column  `is_role` enum('N','Y') CHARACTER SET utf8 NOT NULL DEFAULT 'N' after `auth_string`;
       
      alter table mysql.user add column `default_role` char(80) COLLATE utf8_bin NOT NULL DEFAULT '', add column `max_statement_time` decimal(12,6) NOT NULL DEFAULT '0.000000';
      

      corrected in MDEV-23201 to be in the right order.

      -- Fix passwords
      update mysql.user set `password`=`auth_string`, plugin='' where plugin="mysql_native_password";
      

      Handled in server under acl_load

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              danblack Daniel Black
              Reporter:
              danblack Daniel Black
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration