These details are shown when logged in to an account:
Which set of statements would match the accounts shown?
A. mysql> CREATE USER ‘employee’@’localhost’ IDENTIFIED BY ‘more_secrets’;
mysql> CREATE USER ’’@’’ IDENTIFIED BY ‘valid_password’ WITH PROXY
‘employee’@’localhost’;
B. mysql> CREATE USER ‘employee’@’localhost’ IDENTIFIED BY ‘more_secrets’;
mysql> GRANT PROXY ON ‘employee’@’localhost’ TO ‘robert’@’localhost’;
C. mysql> CREATE USER ‘robert’@’localhost’ IDENTIFIED BY ‘secret_password’;
mysql>CREATE USER ‘employee’@’localhost’ IDENTIFIED BY ‘more_secrets’;
D. mysql> CREATE_USER ’’@’’ IDENTIFIED WITH authentication_pam ACCOUNT LOCK;
mysql> CREATE USER ‘employee’@’localhost’ IDENTIFIED BY ‘more_secrets’;
mysql> GRANT PROXY ON ‘employee’@’localhost’ TO ’’@’’;
Answer: D
版权声明:本文为博主原创文章,未经博主允许不得转载。
MYSQL
- 上一篇:Mysql OCP 69题
- 下一篇:Mysql OCP 71题