585 lines
19 KiB
Plaintext
585 lines
19 KiB
Plaintext
###############################################################################
|
|
# #
|
|
# Authorization and authentication of the key-value pair shared between #
|
|
# the server and the client #
|
|
# #
|
|
# #
|
|
# Creation Date: 2012-12-1 #
|
|
# Author : Tanjot Singh Uppal #
|
|
# #
|
|
# #
|
|
# Description:Test Cases of authenticating the key value pair shared #
|
|
# between the client and server during the handshake #
|
|
# #
|
|
###############################################################################
|
|
|
|
--source include/mysql_upgrade_preparation.inc
|
|
|
|
# This test will intentionally generate errors in the server error log
|
|
# when a broken password is inserted into the mysql.user table.
|
|
# The below suppression is to clear those errors.
|
|
--disable_query_log
|
|
call mtr.add_suppression(".*Password salt for user.*");
|
|
--enable_query_log
|
|
|
|
--echo
|
|
--echo
|
|
--echo =======================================================================
|
|
--echo Checking the password authentication with @default_plugin plugin
|
|
--echo =======================================================================
|
|
--echo
|
|
|
|
# Checking the password authentication with @default_plugin plugin
|
|
# Creating 2 users and encrypting the server side password with the default @default_plugin plugin
|
|
|
|
set @default_plugin= @@global.default_authentication_plugin;
|
|
|
|
CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED BY 'abc';
|
|
|
|
CREATE USER 'Tanjotuser2'@'127.0.0.1' IDENTIFIED BY 'abc';
|
|
|
|
# Verifying the default server side plugin used to be @default_plugin
|
|
|
|
select (select plugin from mysql.user where User='Tanjotuser1' and Host='localhost')=@default_plugin;
|
|
--echo 1 Expected
|
|
|
|
select (select plugin from mysql.user where User='Tanjotuser2' and Host='127.0.0.1')=@default_plugin;
|
|
--echo 1 Expected
|
|
|
|
# Verifying the client connection using the same @default_plugin
|
|
|
|
connect(con1,localhost,Tanjotuser1,abc,,,,SSL);
|
|
connect(con2,127.0.0.1,Tanjotuser2,abc,,,,SSL);
|
|
|
|
|
|
# Verifying the client access denied passing null password
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con3,localhost,Tanjotuser1,,,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con4,127.0.0.1,Tanjotuser2,,,);
|
|
--enable_query_log
|
|
|
|
# Verifying the client access denied passing blank password
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con5,localhost,Tanjotuser1, ,,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con6,127.0.0.1,Tanjotuser2, ,,);
|
|
--enable_query_log
|
|
|
|
# Dropping the created users
|
|
|
|
connection default;
|
|
|
|
DROP USER 'Tanjotuser1'@'localhost';
|
|
DROP USER 'Tanjotuser2'@'127.0.0.1';
|
|
|
|
--echo
|
|
--echo
|
|
--echo =======================================================================
|
|
--echo Checking the password authentication with sha256_password plugin
|
|
--echo =======================================================================
|
|
--echo
|
|
|
|
# Checking the password authentication with sha256_password plugin
|
|
# Creating 2 users and encrypting the server side password with the sha256_password plugin
|
|
|
|
|
|
CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED WITH 'sha256_password';
|
|
|
|
CREATE USER 'Tanjotuser2'@'127.0.0.1' IDENTIFIED WITH 'sha256_password';
|
|
|
|
# Verifying the server side plugin used to be sha256_password
|
|
|
|
select (select plugin from mysql.user where User='Tanjotuser1' and Host='localhost')='sha256_password';
|
|
--echo 1 Expected
|
|
|
|
select (select plugin from mysql.user where User='Tanjotuser2' and Host='127.0.0.1')='sha256_password';
|
|
--echo 1 Expected
|
|
|
|
# Verifying the client connection using the same sha256_password plugin and NULL password
|
|
|
|
|
|
connect(con19,localhost,Tanjotuser1,,,);
|
|
connect(con20,127.0.0.1,Tanjotuser2,,,);
|
|
|
|
# Verifying the client connection using the same sha256_password plugin and junk password
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con21,localhost,Tanjotuser1," ",,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con22,127.0.0.1,Tanjotuser2," ",,);
|
|
--enable_query_log
|
|
|
|
# setting the password for the 2 users using the sha256_password plugin
|
|
|
|
connection default;
|
|
|
|
SET PASSWORD FOR 'Tanjotuser1'@'localhost'='abc';
|
|
SET PASSWORD FOR 'Tanjotuser2'@'127.0.0.1'='abc';
|
|
|
|
# Verifying the client connection using the same sha256_password plugin and NULL password
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con23,localhost,Tanjotuser1,,,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con24,127.0.0.1,Tanjotuser2,,,);
|
|
--enable_query_log
|
|
|
|
# Verifying the client connection using the same sha256_password plugin and junk password
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con25,localhost,Tanjotuser1," ",,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con26,127.0.0.1,Tanjotuser2," ",,);
|
|
--enable_query_log
|
|
|
|
# Verifying the client connection using the same sha256_password plugin and correct password
|
|
|
|
--disable_warnings
|
|
connect(con27,localhost,Tanjotuser1,abc,,);
|
|
connect(con28,127.0.0.1,Tanjotuser2,abc,,);
|
|
--enable_warnings
|
|
|
|
# Dropping the created users
|
|
|
|
connection default;
|
|
|
|
DROP USER 'Tanjotuser1'@'localhost';
|
|
DROP USER 'Tanjotuser2'@'127.0.0.1';
|
|
|
|
# Disconnecting the above connections
|
|
|
|
--disable_query_log
|
|
|
|
disconnect con1;
|
|
disconnect con2;
|
|
#disconnect con3;
|
|
#disconnect con4;
|
|
#disconnect con5;
|
|
#disconnect con6;
|
|
disconnect con19;
|
|
disconnect con20;
|
|
#disconnect con21;
|
|
#disconnect con22;
|
|
#disconnect con23;
|
|
#disconnect con24;
|
|
#disconnect con25;
|
|
#disconnect con26;
|
|
disconnect con27;
|
|
disconnect con28;
|
|
|
|
--enable_query_log
|
|
|
|
|
|
--echo
|
|
--echo
|
|
--echo ====================================================================================================
|
|
--echo checking the integrity of long password (more than 40 chars) using @default_plugin plugin
|
|
--echo ====================================================================================================
|
|
--echo
|
|
|
|
# Checking the password authentication with @default_plugin plugin
|
|
# Creating 2 users and encrypting the server side password with the default @default_plugin plugin
|
|
|
|
CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED BY 'aaaaaaaaaabbbbbbbbbbccccccccccddddddddddeeeeeeeeeeaaaaaaaaaannnnnnnnnnaaaaaaaaaahhhhhhhhhh1111111111gggggggggg2222222222';
|
|
|
|
CREATE USER 'Tanjotuser2'@'127.0.0.1' IDENTIFIED BY 'aaaaaaaaaabbbbbbbbbbccccccccccddddddddddeeeeeeeeeeaaaaaaaaaannnnnnnnnnaaaaaaaaaahhhhhhhhhh1111111111gggggggggg2222222222';
|
|
|
|
# Verifying the client connection using the same @default_plugin
|
|
|
|
--disable_warnings
|
|
connect(con29,localhost,Tanjotuser1,aaaaaaaaaabbbbbbbbbbccccccccccddddddddddeeeeeeeeeeaaaaaaaaaannnnnnnnnnaaaaaaaaaahhhhhhhhhh1111111111gggggggggg2222222222,,,,SSL);
|
|
connect(con30,127.0.0.1,Tanjotuser2,aaaaaaaaaabbbbbbbbbbccccccccccddddddddddeeeeeeeeeeaaaaaaaaaannnnnnnnnnaaaaaaaaaahhhhhhhhhh1111111111gggggggggg2222222222,,,,SSL);
|
|
--enable_warnings
|
|
|
|
# Verifying the client access denied passing null password
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con31,localhost,Tanjotuser1,,,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con32,127.0.0.1,Tanjotuser2,,,);
|
|
--enable_query_log
|
|
|
|
|
|
# Dropping the created users
|
|
|
|
connection default;
|
|
|
|
DROP USER 'Tanjotuser1'@'localhost';
|
|
DROP USER 'Tanjotuser2'@'127.0.0.1';
|
|
|
|
--echo
|
|
--echo
|
|
--echo ====================================================================================================
|
|
--echo checking the integrity of long password (more than 40 chars) using sha256_password plugin
|
|
--echo ====================================================================================================
|
|
--echo
|
|
|
|
# Checking the password authentication with sha256_password plugin
|
|
# Creating 2 users and encrypting the server side password with the sha256_password plugin
|
|
|
|
|
|
CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED WITH 'sha256_password';
|
|
|
|
CREATE USER 'Tanjotuser2'@'127.0.0.1' IDENTIFIED WITH 'sha256_password';
|
|
|
|
|
|
# setting the password for the 2 users using the sha256_password plugin
|
|
|
|
SET PASSWORD FOR 'Tanjotuser1'@'localhost'='aaaaaaaaaabbbbbbbbbbccccccccccddddddddddeeeeeeeeeeaaaaaaaaaannnnnnnnnnaaaaaaaaaahhhhhhhhhh1111111111gggggggggg2222222222';
|
|
SET PASSWORD FOR 'Tanjotuser2'@'127.0.0.1'='aaaaaaaaaabbbbbbbbbbccccccccccddddddddddeeeeeeeeeeaaaaaaaaaannnnnnnnnnaaaaaaaaaahhhhhhhhhh1111111111gggggggggg2222222222';
|
|
|
|
|
|
# Verifying the client connection using the same sha256_password plugin and correct password
|
|
|
|
--disable_warnings
|
|
connect(con37,localhost,Tanjotuser1,aaaaaaaaaabbbbbbbbbbccccccccccddddddddddeeeeeeeeeeaaaaaaaaaannnnnnnnnnaaaaaaaaaahhhhhhhhhh1111111111gggggggggg2222222222,,);
|
|
connect(con38,127.0.0.1,Tanjotuser2,aaaaaaaaaabbbbbbbbbbccccccccccddddddddddeeeeeeeeeeaaaaaaaaaannnnnnnnnnaaaaaaaaaahhhhhhhhhh1111111111gggggggggg2222222222,,);
|
|
--enable_warnings
|
|
|
|
# Verifying the client connection using the same sha256_password plugin and NULL password
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con39,localhost,Tanjotuser1,,,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con40,127.0.0.1,Tanjotuser2,,,);
|
|
--enable_query_log
|
|
|
|
# Dropping the created users
|
|
|
|
connection default;
|
|
|
|
DROP USER 'Tanjotuser1'@'localhost';
|
|
DROP USER 'Tanjotuser2'@'127.0.0.1';
|
|
|
|
|
|
--echo
|
|
--echo
|
|
--echo ====================================================================================================
|
|
--echo checking the integrity of NULL password using @default_plugin plugin
|
|
--echo ====================================================================================================
|
|
--echo
|
|
|
|
# Checking the password authentication with @default_plugin plugin
|
|
# Creating 2 users and encrypting the server side password with the default @default_plugin plugin
|
|
|
|
CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED BY '';
|
|
|
|
CREATE USER 'Tanjotuser2'@'127.0.0.1' IDENTIFIED BY '';
|
|
|
|
# Verifying the client connection using the null password
|
|
|
|
connect(con41,localhost,Tanjotuser1,,,);
|
|
connect(con42,127.0.0.1,Tanjotuser2,,,);
|
|
|
|
# Verifying the client access denied passing not null password
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con43,localhost,Tanjotuser1," ",,,,SSL);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con44,127.0.0.1,Tanjotuser2," ",,,,SSL);
|
|
--enable_query_log
|
|
|
|
|
|
# Verifying the client access denied passing not null password
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con45,localhost,Tanjotuser1,NULL,,,,SSL);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con46,127.0.0.1,Tanjotuser2,NULL,,,,SSL);
|
|
--enable_query_log
|
|
|
|
|
|
# Verifying the client access denied passing not null password
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con47,localhost,Tanjotuser1,0,,,,SSL);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con48,127.0.0.1,Tanjotuser2,0,,,,SSL);
|
|
--enable_query_log
|
|
|
|
|
|
# Dropping the created users
|
|
|
|
connection default;
|
|
|
|
DROP USER 'Tanjotuser1'@'localhost';
|
|
DROP USER 'Tanjotuser2'@'127.0.0.1';
|
|
|
|
|
|
--echo
|
|
--echo
|
|
--echo ====================================================================================================
|
|
--echo checking the integrity of NULL password using sha256_password plugin
|
|
--echo ====================================================================================================
|
|
--echo
|
|
|
|
# Checking the password authentication with sha256_password plugin
|
|
# Creating 2 users and encrypting the server side password with the sha256_password plugin
|
|
|
|
|
|
CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED WITH 'sha256_password';
|
|
|
|
CREATE USER 'Tanjotuser2'@'127.0.0.1' IDENTIFIED WITH 'sha256_password';
|
|
|
|
# setting the NULL password for the 2 users using the sha256_password plugin
|
|
|
|
|
|
SET PASSWORD FOR 'Tanjotuser1'@'localhost'='';
|
|
SET PASSWORD FOR 'Tanjotuser2'@'127.0.0.1'='';
|
|
|
|
|
|
# Verifying the client connection using the null password
|
|
|
|
connect(con57,localhost,Tanjotuser1,,,);
|
|
connect(con58,127.0.0.1,Tanjotuser2,,,);
|
|
|
|
|
|
# Verifying the client connection using the sha256_password plugin and not NULL password
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con59,localhost,Tanjotuser1," ",,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con60,127.0.0.1,Tanjotuser2," ",,);
|
|
--enable_query_log
|
|
|
|
# Verifying the client connection using the sha256_password plugin and not NULL password
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con61,localhost,Tanjotuser1,0,,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con62,127.0.0.1,Tanjotuser2,0,,);
|
|
--enable_query_log
|
|
|
|
|
|
# Dropping the created users
|
|
|
|
connection default;
|
|
|
|
DROP USER 'Tanjotuser1'@'localhost';
|
|
DROP USER 'Tanjotuser2'@'127.0.0.1';
|
|
|
|
|
|
# Disconnecting the above connections
|
|
|
|
--disable_query_log
|
|
|
|
disconnect con29;
|
|
disconnect con30;
|
|
#disconnect con31;
|
|
#disconnect con32;
|
|
disconnect con37;
|
|
disconnect con38;
|
|
#disconnect con39;
|
|
#disconnect con40;
|
|
disconnect con41;
|
|
disconnect con42;
|
|
#disconnect con43;
|
|
#disconnect con44;
|
|
#disconnect con45;
|
|
#disconnect con46;
|
|
#disconnect con47;
|
|
#disconnect con48;
|
|
disconnect con57;
|
|
disconnect con58;
|
|
#disconnect con59;
|
|
#disconnect con60;
|
|
#disconnect con61;
|
|
#disconnect con62;
|
|
|
|
--enable_query_log
|
|
|
|
--echo
|
|
--echo
|
|
--echo =================================================================================================
|
|
--echo checking the combination of Client default_auth=sha256_password and server default_auth=native
|
|
--echo =================================================================================================
|
|
--echo
|
|
|
|
CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED WITH 'sha256_password';
|
|
CREATE USER 'Tanjotuser2'@'127.0.0.1' IDENTIFIED WITH 'sha256_password';
|
|
|
|
SET PASSWORD FOR 'Tanjotuser1'@'localhost'='abc';
|
|
SET PASSWORD FOR 'Tanjotuser2'@'127.0.0.1'='abc';
|
|
|
|
GRANT ALL ON *.* TO 'Tanjotuser1'@'localhost';
|
|
GRANT ALL ON *.* TO 'Tanjotuser2'@'127.0.0.1';
|
|
|
|
--echo **** Client default_auth=sha_256_password and server default auth=native
|
|
--exec $MYSQL -uTanjotuser1 -hlocalhost -pabc --default_auth=sha256_password -e "select user(), current_user()"
|
|
--echo **** Client default_auth=native and server default auth=native
|
|
--exec $MYSQL -uTanjotuser2 -h127.0.0.1 -pabc --default_auth=mysql_native_password -e "select user(), current_user()"
|
|
--echo **** Client default_auth=sha_256_password + public key on file.
|
|
--exec $MYSQL -uTanjotuser1 -hlocalhost -pabc --default_auth=sha256_password --server_public_key_path=$MYSQL_TEST_DIR/std_data/rsa_public_key.pem -e "select user(), current_user()"
|
|
|
|
# Dropping the created users
|
|
|
|
DROP USER 'Tanjotuser1'@'localhost';
|
|
DROP USER 'Tanjotuser2'@'127.0.0.1';
|
|
|
|
|
|
--echo
|
|
--echo
|
|
--echo =================================================================================================
|
|
--echo Starting the server with the default authentication mysql_native_password
|
|
--echo =================================================================================================
|
|
--echo
|
|
|
|
--echo # Restart server with default-authentication-plugin=mysql_native_password;
|
|
|
|
let $restart_file= $MYSQLTEST_VARDIR/tmp/mysqld.1.expect;
|
|
--exec echo "wait" > $restart_file
|
|
--shutdown_server
|
|
--source include/wait_until_disconnected.inc
|
|
-- exec echo "restart:--default-authentication-plugin=mysql_native_password " > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
|
|
-- enable_reconnect
|
|
-- source include/wait_until_connected_again.inc
|
|
|
|
|
|
# Creating 3 users with mysql_native_password, mysql_old_password and sha256_password plugins respectively
|
|
|
|
--echo Creating a user with mysql_native_password plugin
|
|
CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED BY 'abc';
|
|
|
|
Grant all on *.* to 'Tanjotuser1'@'localhost';
|
|
|
|
--echo Creating a user with SHA256_password plugin
|
|
CREATE USER 'Tanjotuser3'@'localhost' IDENTIFIED WITH 'sha256_password';
|
|
|
|
set password for 'Tanjotuser3'@'localhost' ='abc';
|
|
|
|
Grant all on *.* to 'Tanjotuser3'@'localhost';
|
|
|
|
# Verifying the Authentication plugin for the above created users
|
|
|
|
select (select plugin from mysql.user where User='Tanjotuser1' and Host='localhost')='mysql_native_password';
|
|
--echo 1 Expected
|
|
|
|
select (select plugin from mysql.user where User='Tanjotuser3' and Host='localhost')='sha256_password';
|
|
--echo 1 Expected
|
|
|
|
# Dropping the created users
|
|
|
|
DROP USER 'Tanjotuser1'@'localhost';
|
|
DROP USER 'Tanjotuser3'@'localhost';
|
|
|
|
|
|
--echo
|
|
--echo
|
|
--echo =================================================================================================
|
|
--echo Starting the server with the default authentication sha256_password
|
|
--echo =================================================================================================
|
|
--echo
|
|
|
|
--echo # Restart server with default-authentication-plugin=sha256_password;
|
|
|
|
let $restart_file= $MYSQLTEST_VARDIR/tmp/mysqld.1.expect;
|
|
--exec echo "wait" > $restart_file
|
|
--shutdown_server
|
|
--source include/wait_until_disconnected.inc
|
|
-- exec echo "restart:--default-authentication-plugin=sha256_password " > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
|
|
-- enable_reconnect
|
|
-- source include/wait_until_connected_again.inc
|
|
|
|
# Creating 3 users with mysql_native_password, mysql_old_password and sha256_password plugins respectively
|
|
|
|
--echo Creating a user with mysql_native_password plugin
|
|
CREATE USER 'Tanjotuser2'@'localhost' IDENTIFIED WITH 'mysql_native_password';
|
|
|
|
set password for 'Tanjotuser2'@'localhost' ='abc';
|
|
|
|
Grant all on *.* to 'Tanjotuser2'@'localhost';
|
|
|
|
--echo Creating a user with SHA256_password plugin
|
|
CREATE USER 'Tanjotuser3'@'localhost' IDENTIFIED by 'abc';
|
|
|
|
Grant all on *.* to 'Tanjotuser3'@'localhost';
|
|
|
|
# Verifying the Authentication plugin for the above created users
|
|
|
|
select (select plugin from mysql.user where User='Tanjotuser2' and Host='localhost')='mysql_native_password';
|
|
--echo 1 Expected
|
|
|
|
select (select plugin from mysql.user where User='Tanjotuser3' and Host='localhost')='sha256_password';
|
|
--echo 1 Expected
|
|
|
|
# Dropping the created users
|
|
|
|
DROP USER 'Tanjotuser2'@'localhost';
|
|
DROP USER 'Tanjotuser3'@'localhost';
|
|
|