MariaDB 10.4.11 (GA)的变化和改进

ALTER USER 'hechunyang'@'%' ACCOUNT LOCK;

# Mysql -h227.0.0.1 -uhechunyang -p -P3312

Enter passWord:

ERROR 4151 (HY000): Access denied, this account is locked

ALTER USER 'hechunyang'@'%' ACCOUNT UNLOCK;

> show create user hechunyang@'%'\G;

*************************** 1. row ***************************

CREATE USER for hechunyang@%: CREATE USER 'hechunyang'@'%'

IDENTIFIED BY PASSWORD

'*1DA3AF2348DE66F7554E816DEDC1F1340814842E' ACCOUNT LOCK

> select * from mysql.global_priv where user='hechunyang'\G;

*************************** 1. row ***************************

Host: %

User: hechunyang

Priv:

{"access":1073740799,"plugin":"mysql_native_password","authentication_string":"*

1DA3AF2348DE66F7554E816DEDC1F1340814842E","password_last_changed":15

76823835,"account_locked":true}

>CREATE USER 'hechunyang'@'%' PASSWORD EXPIRE INTERVAL 1 DAY;

>ALTER USER 'hechunyang'@'%' PASSWORD EXPIRE INTERVAL 1 DAY;

hechunyang@127.0.0.1[(none)]>show processlist;

ERROR 1820 (HY000): You must SET PASSWORD before executing this statement

ERROR 1820 (HY000): You must SET PASSWORD before executing this statement

ERROR 1820 (HY000): You must SET PASSWORD before executing this statement

>ALTER USER 'hechunyang'@'%' PASSWORD EXPIRE NEVER;

CREATE TABLE t1 (

  id int(11) DEFAULT NULL,

  cid int(11) DEFAULT NULL,

  name varchar(60) DEFAULT NULL,

  KEY IX_cid (cid)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

alter table t1 modify name varchar(60) charset utf8mb4, ALGORITHM=INSTANT;

CREATE TABLE t1 (

  id int(11) DEFAULT NULL,

  cid int(11) DEFAULT NULL,

  name varchar(60) DEFAULT NULL,

  KEY IX_cid (cid)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

alter table t1 modify name varchar(80) DEFAULT NULL, ALGORITHM=INSTANT;