You have created a new user with this statement:
CREATE USER ‘erika’@’localhost’ IDENTIFIED BY ‘first#1Pass’ PASSWORD EXPIRE;
What is the outcome?
A. When ‘erika’@’localhost’ tries to log in with the MySQL command-line client, the user will have to change the password before seeing the mysql> prompt.
B. When ‘erika’@’localhost’ tries to log in with the MySQL command-line client, the user will not be permitted to log in because the password is expired.
C. When ‘erika’@’localhost’ tries to log in with the MySQL command-line client, the user will be permitted to log in but will not be able to issue ant statements until the user changes the password.
D. You receive a syntax error that indicates that you cannot set a password and expire it at the same time.
Answer: C

你使用下面语句创建了一个新用户：
CREATE USER ‘erika’@’localhost’ IDENTIFIED BY ‘first#1Pass’ PASSWORD EXPIRE;
它会有怎样的影响？
A． 当‘erika’@’localhost’用户试图使用mysql命令行工具连接MySQL时，用户在进入”mysql>”提示符界面前，必须修改密码
B． 当‘erika’@’localhost’用户试图使用mysql命令行工具连接MySQL时，用户的登录请求将被拒绝，因为密码已经过期
C． 当‘erika’@’localhost’用户试图使用mysql命令行工具连接MySQL时，用户可以登录到”mysql>”提示符界面，但不允许执行其它语句，直到他修改了密码为止
D． 执行创建用户的语句时会报语法错误http://www.cndba.cn/hbhe0316/article/22777http://www.cndba.cn/hbhe0316/article/22777

版权声明：本文为博主原创文章，未经博主允许不得转载。

MYSQL