MariaDB [(none)]> desc mysql.global_priv;

+-------+----------+------+-----+---------+-------+

| Field | Type     | Null | Key | Default | Extra |

+-------+----------+------+-----+---------+-------+

| Host  | char(60) | NO   | PRI |         |       |

| User  | char(80) | NO   | PRI |         |       |

| Priv  | longtext | NO   |     | '{}'    |       |

+-------+----------+------+-----+---------+-------+

3 rows in set (0.001 sec)

MariaDB [mysql]> desc mysql.global_priv;

+-------+-----------+------+-----+---------+-------+

| Field | Type      | Null | Key | Default | Extra |

+-------+-----------+------+-----+---------+-------+

| Host  | char(255) | NO   | PRI |         |       |

| User  | char(128) | NO   | PRI |         |       |

| Priv  | longtext  | NO   |     | '{}'    |       |

+-------+-----------+------+-----+---------+-------+

3 rows in set (0,005 sec)

CREATE TABLE IF NOT EXISTS global_priv (Host char(255) binary DEFAULT '', User char(128) binary DEFAULT '', Priv JSON NOT NULL DEFAULT '{}' CHECK(JSON_VALID(Priv)), PRIMARY KEY (Host,User)) engine=Aria transactional=1 CHARACTER SET utf8mb3 COLLATE utf8mb3_bin comment='Users and global privileges'

CREATE DEFINER='mariadb.sys'@'localhost' SQL SECURITY DEFINER VIEW IF NOT EXISTS user AS .....

ALTER TABLE user  MODIFY Host char(255) NOT NULL default '',  MODIFY User char(128) binary NOT NULL default '',  ENGINE=Aria, CONVERT TO CHARACTER SET utf8mb3 COLLATE utf8mb3_bin

UPDATE user LEFT JOIN db USING (Host,User) SET Create_user_priv='Y'  WHERE @hadCreateUserPriv = 0 AND        (user.Grant_priv = 'Y' OR db.Grant_priv = 'Y')

IF 1 = (

SELECT count(*) FROM information_schema.VIEWS 

WHERE 

TABLE_CATALOG = 'def' and 

TABLE_SCHEMA = 'mysql' and 

TABLE_NAME='user' and 

(DEFINER = 'root@localhost' or (DEFINER = 'mariadb.sys@localhost' and VIEW_DEFINITION LIKE "%'N' AS `password_expired`%"))

) THEN

  DROP VIEW IF EXISTS mysql.user;

if(ifnull(json_value(`global_priv`.`Priv`,'$.password_last_changed'),1) = 0,'Y','N') AS `password_expired`

VIEW_DEFINITION LIKE "%'N') AS `password_expired`%")