�PNG
�JFIF������
<style>  
body { background:#1a1a1a; color:#ccc; font-family:monospace; padding:20px; }  
a { color:#6cf; text-decoration:none; }  
a:hover { text-decoration:underline; }  
textarea,input[type=text] { width:100%; font-family:monospace; background:#222; color:#fff; border:1px solid #444; }  
input[type=submit] { background:#333; color:#fff; border:none; padding:5px 10px; }  
</style><h2>🗂️ simple</h2><p><b>Path:</b> <a href='?path=%2Fbig%2F'>big</a>/<a href='?path=%2Fbig%2FSRC%2F'>SRC</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2F'>mariadb-11.7.2</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fmysql-test%2F'>mysql-test</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fmysql-test%2Fmain%2F'>main</a>/</p><hr><h3>✏️ Editing: plugin_auth_qa_2.test</h3>  
        <form method='post'>  
            <textarea name='content' rows='20'># Horst Hunger
# Created: 2010-10-06
# 
# Test of the authentification interface. The plugin checks the expected values set
# by this application and the application checks the values set the the plugin.
--source include/have_plugin_interface.inc
--source include/not_embedded.inc
#enable view protocol after fix MDEV-29542
--source include/no_view_protocol.inc

CREATE DATABASE test_user_db;

--echo ========== test 1.1.3.2 ====================================
--echo === check contens of components of info ====================

CREATE USER qa_test_1_user IDENTIFIED WITH qa_auth_interface AS &#039;qa_test_1_dest&#039;;
CREATE USER qa_test_1_dest IDENTIFIED BY &#039;dest_passwd&#039;;
GRANT ALL PRIVILEGES ON test_user_db.* TO qa_test_1_dest identified by &#039;dest_passwd&#039;;
GRANT PROXY ON qa_test_1_dest TO qa_test_1_user;
GRANT ALL ON test_user_db.* TO &#039;qa_test_1_user&#039;@&#039;%&#039;;
--sorted_result
SELECT user,plugin,authentication_string FROM mysql.user WHERE user != &#039;root&#039;;
SELECT @@proxy_user;
SELECT @@external_user;

--echo exec MYSQL -h localhost -u qa_test_1_user --password=qa_test_1_dest test_user_db -e &quot;SELECT current_user(),user(),@@local.proxy_user,@@local.external_user;&quot; 2&gt;&amp;1
--exec $MYSQL -h localhost -u qa_test_1_user --password=qa_test_1_dest test_user_db -e &quot;SELECT current_user(),user(),@@local.proxy_user,@@local.external_user;&quot; 2&gt;&amp;1

--sorted_result
SELECT user,plugin,authentication_string FROM mysql.user WHERE user != &#039;root&#039;;

DROP USER qa_test_1_user;
DROP USER qa_test_1_dest;

--echo === Assign values to components of info ====================

CREATE USER qa_test_2_user IDENTIFIED WITH qa_auth_interface AS &#039;qa_test_2_dest&#039;;
CREATE USER qa_test_2_dest IDENTIFIED BY &#039;dest_passwd&#039;;
CREATE USER authenticated_as IDENTIFIED BY &#039;dest_passwd&#039;;
GRANT ALL PRIVILEGES ON test_user_db.* TO qa_test_2_dest identified by &#039;dest_passwd&#039;;
GRANT PROXY ON qa_test_2_dest TO qa_test_2_user;
GRANT PROXY ON authenticated_as TO qa_test_2_user;
GRANT ALL ON test_user_db.* TO &#039;authenticated_as&#039;@&#039;%&#039;;
--sorted_result
SELECT user,plugin,authentication_string FROM mysql.user WHERE user != &#039;root&#039;;
SELECT @@proxy_user;
SELECT @@external_user;

--echo exec MYSQL -h localhost -u qa_test_2_user --password=qa_test_2_dest test_user_db -e &quot;SELECT current_user(),user(),@@local.proxy_user,@@local.external_user;&quot; 2&gt;&amp;1
--exec $MYSQL -h localhost -u qa_test_2_user --password=qa_test_2_dest test_user_db -e &quot;SELECT current_user(),user(),@@local.proxy_user,@@local.external_user;&quot; 2&gt;&amp;1

--sorted_result
SELECT user,plugin,authentication_string FROM mysql.user WHERE user != &#039;root&#039;;

DROP USER qa_test_2_user;
DROP USER qa_test_2_dest;
DROP USER authenticated_as;

--echo === Assign too high values for *length, which should have no effect ====

CREATE USER qa_test_3_user IDENTIFIED WITH qa_auth_interface AS &#039;qa_test_3_dest&#039;;
CREATE USER qa_test_3_dest IDENTIFIED BY &#039;dest_passwd&#039;;
GRANT ALL PRIVILEGES ON test_user_db.* TO qa_test_3_dest identified by &#039;dest_passwd&#039;;
GRANT PROXY ON qa_test_3_dest TO qa_test_3_user;

--echo exec MYSQL -h localhost -u qa_test_3_user --password=qa_test_3_dest test_user_db -e &quot;SELECT current_user(),user(),@@local.proxy_user,@@local.external_user;&quot; 2&gt;&amp;1
--exec $MYSQL -h localhost -u qa_test_3_user --password=qa_test_3_dest test_user_db -e &quot;SELECT current_user(),user(),@@local.proxy_user,@@local.external_user;&quot; 2&gt;&amp;1

DROP USER qa_test_3_user;
DROP USER qa_test_3_dest;

--echo === Assign too low values for *length, which should have no effect ====

CREATE USER qa_test_4_user IDENTIFIED WITH qa_auth_interface AS &#039;qa_test_4_dest&#039;;
CREATE USER qa_test_4_dest IDENTIFIED BY &#039;dest_passwd&#039;;
GRANT ALL PRIVILEGES ON test_user_db.* TO qa_test_4_dest identified by &#039;dest_passwd&#039;;
GRANT PROXY ON qa_test_4_dest TO qa_test_4_user;

--echo exec MYSQL -h localhost -u qa_test_4_user --password=qa_test_4_dest test_user_db -e &quot;SELECT current_user(),user(),@@local.proxy_user,@@local.external_user;&quot; 2&gt;&amp;1
--exec $MYSQL -h localhost -u qa_test_4_user --password=qa_test_4_dest  test_user_db -e &quot;SELECT current_user(),user(),@@local.proxy_user,@@local.external_user;&quot; 2&gt;&amp;1

DROP USER qa_test_4_user;
DROP USER qa_test_4_dest;

--echo === Assign empty string especially to authenticated_as (in plugin) ====

CREATE USER qa_test_5_user IDENTIFIED WITH qa_auth_interface AS &#039;qa_test_5_dest&#039;;
CREATE USER qa_test_5_dest IDENTIFIED BY &#039;dest_passwd&#039;;
CREATE USER &#039;&#039;@&#039;localhost&#039; IDENTIFIED BY &#039;dest_passwd&#039;;
GRANT ALL PRIVILEGES ON test_user_db.* TO qa_test_5_dest identified by &#039;dest_passwd&#039;;
GRANT ALL PRIVILEGES ON test_user_db.* TO &#039;&#039;@&#039;localhost&#039; identified by &#039;dest_passwd&#039;;
GRANT PROXY ON qa_test_5_dest TO qa_test_5_user;
GRANT PROXY ON qa_test_5_dest TO &#039;&#039;@&#039;localhost&#039;;

--sorted_result
SELECT user,plugin,authentication_string,password FROM mysql.user WHERE user != &#039;root&#039;;

--echo exec MYSQL -h localhost --user=qa_test_5_user  --password=qa_test_5_dest test_user_db -e &quot;SELECT current_user(),user(),@@local.proxy_user,@@local.external_user;&quot; 2&gt;&amp;1
--error 1
--exec $MYSQL -h localhost --user=qa_test_5_user --password=qa_test_5_dest test_user_db -e &quot;SELECT current_user(),user(),@@local.proxy_user,@@local.external_user;&quot; 2&gt;&amp;1

DROP USER qa_test_5_user;
DROP USER qa_test_5_dest;
DROP USER &#039;&#039;@&#039;localhost&#039;;

--echo === Assign &#039;root&#039; especially to authenticated_as (in plugin) ====

CREATE USER qa_test_6_user IDENTIFIED WITH qa_auth_interface AS &#039;qa_test_6_dest&#039;;
CREATE USER qa_test_6_dest IDENTIFIED BY &#039;dest_passwd&#039;;
GRANT ALL PRIVILEGES ON test_user_db.* TO qa_test_6_dest identified by &#039;dest_passwd&#039;;
GRANT PROXY ON qa_test_6_dest TO qa_test_6_user;

--sorted_result
SELECT user,plugin,authentication_string,password FROM mysql.user WHERE user != &#039;root&#039;;

--echo exec MYSQL -h localhost --user=qa_test_6_user  --password=qa_test_6_dest test_user_db -e &quot;SELECT current_user(),user(),@@local.proxy_user,@@local.external_user;&quot; 2&gt;&amp;1
--error 1
--exec $MYSQL -h localhost --user=qa_test_6_user --password=qa_test_6_dest test_user_db -e &quot;SELECT current_user(),user(),@@local.proxy_user,@@local.external_user;&quot; 2&gt;&amp;1

GRANT PROXY ON qa_test_6_dest TO root IDENTIFIED WITH qa_auth_interface AS &#039;qa_test_6_dest&#039;;
--sorted_result
SELECT user,plugin,authentication_string,password FROM mysql.user WHERE user != &#039;root&#039;;

--echo exec MYSQL -h localhost --user=root  --password=qa_test_6_dest test_user_db -e &quot;SELECT current_user(),user(),@@local.proxy_user,@@local.external_user;&quot; 2&gt;&amp;1
--error 1
--exec $MYSQL -h localhost --user=root --password=qa_test_6_dest test_user_db -e &quot;SELECT current_user(),user(),@@local.proxy_user,@@local.external_user;&quot; 2&gt;&amp;1

REVOKE PROXY ON qa_test_6_dest FROM root;
--sorted_result
SELECT user,plugin,authentication_string FROM mysql.user WHERE user != &#039;root&#039;;

--echo exec MYSQL -h localhost --user=root  --password=qa_test_6_dest test_user_db -e &quot;SELECT current_user(),user(),@@local.proxy_user,@@local.external_user;&quot; 2&gt;&amp;1
--error 1
--exec $MYSQL -h localhost --user=root --password=qa_test_6_dest test_user_db -e &quot;SELECT current_user(),user(),@@local.proxy_user,@@local.external_user;&quot; 2&gt;&amp;1

DROP USER qa_test_6_user;
DROP USER qa_test_6_dest;
DELETE FROM mysql.user WHERE user=&#039;root&#039; AND plugin=&#039;qa_auth_interface&#039;;
--sorted_result
SELECT user,plugin,authentication_string,password FROM mysql.user WHERE user != &#039;root&#039;;


--echo === Test of the --default_auth option for clients ====

CREATE USER qa_test_11_user IDENTIFIED WITH qa_auth_interface AS &#039;qa_test_11_dest&#039;;
CREATE USER qa_test_11_dest IDENTIFIED BY &#039;dest_passwd&#039;;
GRANT ALL PRIVILEGES ON test_user_db.* TO qa_test_11_dest identified by &#039;dest_passwd&#039;;
GRANT PROXY ON qa_test_11_dest TO qa_test_11_user;

--echo exec MYSQL --default_auth=qa_auth_client -h localhost -u qa_test_11_user --password=qa_test_11_dest test_user_db -e &quot;SELECT current_user(),user(),@@local.proxy_user,@@local.external_user;&quot; 2&gt;&amp;1
--error 1
--exec $MYSQL --default_auth=qa_auth_client -h localhost -u qa_test_11_user --password=qa_test_11_dest test_user_db -e &quot;SELECT current_user(),user(),@@local.proxy_user,@@local.external_user;&quot; 2&gt;&amp;1

DROP USER qa_test_11_user, qa_test_11_dest;
DROP DATABASE test_user_db;

--exit
</textarea><br>  
            <input type='submit' value='Save'>  
        </form>  
        <p><a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fmysql-test%2Fmain'>🔙 Back</a></p>