mysql> CREATE USER 'erika'@'localhost' IDENTIFIED BY 'first#1Pass' PASSWORD EXPIRE; mysql -u erika -pfirst#1Pass -hlocalhost mysql> use db1; ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql> show variables;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.