[MDEV-24586] remove scripts/mysql_to_mariadb.sql Created: 2021-01-14  Updated: 2021-03-30  Resolved: 2021-03-30

Status: Closed
Project: MariaDB Server
Component/s: Scripts & Clients
Fix Version/s: 10.2.38, 10.3.29, 10.4.19, 10.5.10

Type: Task Priority: Major
Reporter: Daniel Black Assignee: Daniel Black
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-24122 Minor updates to MariaDB 10.2/10.3 se... Closed

 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

 Comments   
Comment by Daniel Black [ 2021-01-14 ]

cvicentiu, given high overlap with MDEV-24122 can you review bb-10.2-MDEV-24586-danielblack-remove-mysql_to_mariadb.sql too please.

Generated at Thu Feb 08 09:31:07 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.