mysql 8.0
1、
Choose the best answer.
Examine these statements and output:
mysql> GRANT PROXY ON accounting@localhost TO ' '@'%' ;
mysql> SELECT USER(), CURRENT_USER(), @@proxy_user;
Which statement is true?
A) The user failed to define a username and the connecting username defaulted to ' '@'%'.
B) The user is authorized as the rsmith@localhost user.
C) The user is authenticated as the anonymous proxy user ' '@'%'.
D) The user is logged in with --user=accounting as an option.
E) The user is authorized as the accounting@localhost user.
Answer：E
分析：proxy 用户创建构成
-- create proxy account
CREATE USER 'employee_proxy'@'%' identified by '123456';
-- create proxied account and grant its privileges;
CREATE USER 'employee'@'localhost' identified by '123456';
GRANT ALL ON *.* TO 'employee'@'localhost';
-- grant to proxy account the
GRANT PROXY ON 'employee'@'localhost' TO 'employee_proxy'@'%';
- 1
- 2
前往页