1CREATE DATABASE test_user_db;
2CREATE USER qa_test_11_user IDENTIFIED WITH qa_auth_server AS 'qa_test_11_dest';
3GRANT ALL PRIVILEGES ON test_user_db.* TO qa_test_11_dest identified by 'dest_passwd';
4GRANT PROXY ON qa_test_11_dest TO qa_test_11_user;
5exec MYSQL PLUGIN_AUTH_OPT --default_auth=qa_auth_client -h localhost -P MASTER_MYPORT -u qa_test_11_user --password=qa_test_11_dest test_user_db -e "SELECT current_user(),user(),@@local.proxy_user,@@local.external_user;" 2>&1
6Warning: Using a password on the command line interface can be insecure.
7current_user()	user()	@@local.proxy_user	@@local.external_user
8qa_test_11_dest@%	qa_test_11_user@localhost	'qa_test_11_user'@'%'	'qa_test_11_user'@'%'
9exec MYSQL PLUGIN_AUTH_OPT --default_auth=qa_auth_client -h localhost -P MASTER_MYPORT -u qa_test_2_user --password=qa_test_11_dest test_user_db -e "SELECT current_user(),user(),@@local.proxy_user,@@local.external_user;" 2>&1
10Warning: Using a password on the command line interface can be insecure.
11ERROR 1045 (28000): Access denied for user 'qa_test_2_user'@'localhost' (using password: YES)
12DROP USER qa_test_11_user, qa_test_11_dest;
13DROP DATABASE test_user_db;
14