Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
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
- relates to
-
MDEV-24122 Minor updates to MariaDB 10.2/10.3 seems to be adding a DEFAULT ROLE to the show grants command that is invalid.
-
- Closed
-