687 lines
21 KiB
Plaintext
687 lines
21 KiB
Plaintext
###############################################################################
|
|
# #
|
|
# Authorization and authentication using the MYSQL_NATIVE_PASSWORD pligin at #
|
|
# server and client side #
|
|
# #
|
|
# #
|
|
# #
|
|
# Creation Date: 2012-12-10 #
|
|
# Author : Tanjot Singh Uppal #
|
|
# #
|
|
# #
|
|
# Description:Test Cases of authenticating the hashed password using the #
|
|
# mysql_native_password plugin at the server side as well as the client side #
|
|
# #
|
|
# #
|
|
###############################################################################
|
|
|
|
--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 using the mysql_native_password plugin at the client and mysql_native_password plugin at the server side
|
|
--echo ===========================================================================================================================================
|
|
--echo
|
|
|
|
# Checking the password authentication with mysql_native_password plugin
|
|
# Creating 2 users and encrypting the server side password with the mysql_native_password plugin
|
|
|
|
CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED WITH 'mysql_native_password';
|
|
|
|
CREATE USER 'Tanjotuser2'@'127.0.0.1' IDENTIFIED WITH 'mysql_native_password';
|
|
|
|
# Verifying the server side plugin used to be mysql_native_password
|
|
|
|
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='Tanjotuser2' and Host='127.0.0.1')='mysql_native_password';
|
|
--echo 1 Expected
|
|
|
|
# Verifying the client connection using the same mysql_native_password plugin and NULL password
|
|
|
|
--replace_result "NO" "" "YES" ""
|
|
connect(con1,localhost,Tanjotuser1,,,);
|
|
--replace_result "NO" "" "YES" ""
|
|
connect(con2,127.0.0.1,Tanjotuser2,,,);
|
|
|
|
# Verifying the client connection using the same mysql_native_password plugin and junk password
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con3,localhost,Tanjotuser1," ",,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con4,127.0.0.1,Tanjotuser2," ",,);
|
|
--enable_query_log
|
|
|
|
# setting the password for the 2 users using the mysql_native_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 mysql_native_password plugin and NULL password
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con5,localhost,Tanjotuser1,,,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con6,127.0.0.1,Tanjotuser2,,,);
|
|
--enable_query_log
|
|
|
|
# Verifying the client connection using the mysql_native_password plugin and junk password
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con7,localhost,Tanjotuser1," ",,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con8,127.0.0.1,Tanjotuser2," ",,);
|
|
--enable_query_log
|
|
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con9,localhost,Tanjotuser1,"%",,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con10,127.0.0.1,Tanjotuser2,"%",,);
|
|
--enable_query_log
|
|
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con11,localhost,Tanjotuser1,"_",,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con12,127.0.0.1,Tanjotuser2,"_",,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con13,localhost,Tanjotuser1,"0",,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con14,127.0.0.1,Tanjotuser2,"0",,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con15,localhost,Tanjotuser1,"^",,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con16,127.0.0.1,Tanjotuser2,"^",,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con17,localhost,Tanjotuser1,'\$',,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con18,127.0.0.1,Tanjotuser2,'\$',,);
|
|
--enable_query_log
|
|
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con19,localhost,Tanjotuser1,"&",,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con20,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 mysql_native_password plugin
|
|
--echo ====================================================================================================
|
|
--echo
|
|
|
|
|
|
# Checking the password authentication with mysql_native_password plugin
|
|
# Creating 2 users and encrypting the server side password with the mysql_native_password plugin
|
|
|
|
CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED WITH 'mysql_native_password';
|
|
|
|
CREATE USER 'Tanjotuser2'@'127.0.0.1' IDENTIFIED WITH 'mysql_native_password';
|
|
|
|
# setting the password for the 2 users using the mysql_native_password plugin
|
|
|
|
SET PASSWORD FOR 'Tanjotuser1'@'localhost'='$$$$$$$$$$^^^^^^^^^^&&&&&&&&&&**********((((((((((##########!!!!!!!!!!@@@@@@@@@@ @@@@@@@@@@__________';
|
|
SET PASSWORD FOR 'Tanjotuser2'@'127.0.0.1'='$$$$$$$$$$^^^^^^^^^^&&&&&&&&&&**********((((((((((##########!!!!!!!!!!@@@@@@@@@@ @@@@@@@@@@__________';
|
|
|
|
|
|
# Verifying the client access denied passing null password
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con39,localhost,Tanjotuser1," ",,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con40,127.0.0.1,Tanjotuser2," ",,);
|
|
--enable_query_log
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con41,localhost,Tanjotuser1,,,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con42,127.0.0.1,Tanjotuser2,,,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con43,localhost,Tanjotuser1,"@_",,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con44,127.0.0.1,Tanjotuser2,"@_",,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con45,localhost,Tanjotuser1,"$_",,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con46,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 using the mysql_native_password plugin at the client and sha256_password plugin at the server side
|
|
--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
|
|
|
|
|
|
|
|
# Checking the password authentication with mysql_native_password plugin
|
|
# Creating 2 users and encrypting the server side password with the mysql_native_password plugin
|
|
|
|
CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED WITH 'mysql_native_password';
|
|
|
|
CREATE USER 'Tanjotuser2'@'127.0.0.1' IDENTIFIED WITH 'mysql_native_password';
|
|
|
|
# Verifying the server side plugin used to be mysql_native_password
|
|
|
|
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='Tanjotuser2' and Host='127.0.0.1')='mysql_native_password';
|
|
--echo 1 Expected
|
|
|
|
# Verifying the client connection using the same mysql_native_password plugin and NULL password
|
|
|
|
--replace_result "NO" "" "YES" ""
|
|
connect(con89,localhost,Tanjotuser1,,,);
|
|
--replace_result "NO" "" "YES" ""
|
|
connect(con90,127.0.0.1,Tanjotuser2,,,);
|
|
|
|
# Verifying the client connection using the same mysql_native_password plugin and junk password
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con91,localhost,Tanjotuser1," ",,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con92,127.0.0.1,Tanjotuser2," ",,);
|
|
--enable_query_log
|
|
|
|
# setting the password for the 2 users using the mysql_native_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 mysql_native_password plugin and NULL password
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con93,localhost,Tanjotuser1,,,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con94,127.0.0.1,Tanjotuser2,,,);
|
|
--enable_query_log
|
|
|
|
# Verifying the client connection using the same mysql_native_password plugin and junk password
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con95,localhost,Tanjotuser1," ",,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con96,127.0.0.1,Tanjotuser2," ",,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con97,localhost,Tanjotuser1,"%",,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con98,127.0.0.1,Tanjotuser2,"%",,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con99,localhost,Tanjotuser1,"_",,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con100,127.0.0.1,Tanjotuser2,"_",,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con101,localhost,Tanjotuser1,"0",,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con102,127.0.0.1,Tanjotuser2,"0",,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con103,localhost,Tanjotuser1,"^",,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con104,127.0.0.1,Tanjotuser2,"^",,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con105,localhost,Tanjotuser1,"\$",,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con106,127.0.0.1,Tanjotuser2,"\$",,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con107,localhost,Tanjotuser1,"&",,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con108,127.0.0.1,Tanjotuser2,"&",,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con117,localhost,Tanjotuser1,"0abc",,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con118,127.0.0.1,Tanjotuser2,"0abc",,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con119,localhost,Tanjotuser1,"abc0",,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con120,127.0.0.1,Tanjotuser2,"abc0",,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con121,localhost,Tanjotuser1,"@abc",,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con122,127.0.0.1,Tanjotuser2,"@abc",,);
|
|
--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 mysql_native_password plugin
|
|
--echo ====================================================================================================
|
|
--echo
|
|
|
|
|
|
# Checking the password authentication with mysql_native_password plugin
|
|
# Creating 2 users and encrypting the server side password with the mysql_native_password plugin
|
|
|
|
CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED WITH 'mysql_native_password';
|
|
|
|
CREATE USER 'Tanjotuser2'@'127.0.0.1' IDENTIFIED WITH 'mysql_native_password';
|
|
|
|
# setting the password for the 2 users using the mysql_native_password plugin
|
|
|
|
SET PASSWORD FOR 'Tanjotuser1'@'localhost'='$$$$$$$$$$^^^^^^^^^^&&&&&&&&&&**********((((((((((##########!!!!!!!!!!@@@@@@@@@@ @@@@@@@@@@__________';
|
|
SET PASSWORD FOR 'Tanjotuser2'@'127.0.0.1'='$$$$$$$$$$^^^^^^^^^^&&&&&&&&&&**********((((((((((##########!!!!!!!!!!@@@@@@@@@@ @@@@@@@@@@__________';
|
|
|
|
|
|
connection default;
|
|
|
|
--disable_warnings
|
|
--replace_result "NO" "" "YES" ""
|
|
connect(con125,localhost,Tanjotuser1,"\$\$\$\$\$\$\$\$\$\$^^^^^^^^^^&&&&&&&&&&**********((((((((((##########!!!!!!!!!!@@@@@@@@@@ @@@@@@@@@@__________",,);
|
|
--replace_result "NO" "" "YES" ""
|
|
connect(con126,127.0.0.1,Tanjotuser2,"\$\$\$\$\$\$\$\$\$\$^^^^^^^^^^&&&&&&&&&&**********((((((((((##########!!!!!!!!!!@@@@@@@@@@ @@@@@@@@@@__________",,);
|
|
--enable_warnings
|
|
|
|
# Verifying the client access denied passing null password
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con127,localhost,Tanjotuser1," ",,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con128,127.0.0.1,Tanjotuser2," ",,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con127,localhost,Tanjotuser1,,,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con128,127.0.0.1,Tanjotuser2,,,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con129,localhost,Tanjotuser1,"@_",,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con130,127.0.0.1,Tanjotuser2,"@_",,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con131,localhost,Tanjotuser1,"$_",,);
|
|
--enable_query_log
|
|
|
|
--replace_result $MASTER_MYSOCK MASTER_MYSOCK
|
|
--replace_result "NO" "" "YES" ""
|
|
--disable_query_log
|
|
--error ER_ACCESS_DENIED_ERROR
|
|
connect(con132,127.0.0.1,Tanjotuser2,"$_",,);
|
|
--enable_query_log
|
|
|
|
|
|
# Dropping the created users
|
|
|
|
disconnect con1;
|
|
disconnect con2;
|
|
#disconnect con3;
|
|
#disconnect con4;
|
|
#disconnect con5;
|
|
#disconnect con6;
|
|
#disconnect con7;
|
|
#disconnect con8;
|
|
#disconnect con9;
|
|
#disconnect con10;
|
|
#disconnect con11;
|
|
#disconnect con12;
|
|
#disconnect con13;
|
|
#disconnect con14;
|
|
#disconnect con15;
|
|
#disconnect con16;
|
|
#disconnect con17;
|
|
#disconnect con18;
|
|
#disconnect con19;
|
|
#disconnect con20;
|
|
#disconnect con39;
|
|
#disconnect con40;
|
|
#disconnect con41;
|
|
#disconnect con42;
|
|
#disconnect con43;
|
|
#disconnect con44;
|
|
#disconnect con45;
|
|
#disconnect con46;
|
|
disconnect con89;
|
|
disconnect con90;
|
|
#disconnect con91;
|
|
#disconnect con92;
|
|
#disconnect con93;
|
|
#disconnect con94;
|
|
#disconnect con95;
|
|
#disconnect con96;
|
|
#disconnect con97;
|
|
#disconnect con98;
|
|
#disconnect con99;
|
|
#disconnect con100;
|
|
#disconnect con101;
|
|
#disconnect con102;
|
|
#disconnect con103;
|
|
#disconnect con104;
|
|
#disconnect con105;
|
|
#disconnect con106;
|
|
#disconnect con107;
|
|
#disconnect con108;
|
|
#disconnect con113;
|
|
#disconnect con114;
|
|
#disconnect con115;
|
|
#disconnect con116;
|
|
#disconnect con117;
|
|
#disconnect con118;
|
|
#disconnect con119;
|
|
#disconnect con120;
|
|
#disconnect con121;
|
|
#disconnect con122;
|
|
disconnect con125;
|
|
disconnect con126;
|
|
#disconnect con127;
|
|
#disconnect con128;
|
|
#disconnect con129;
|
|
#disconnect con130;
|
|
#disconnect con131;
|
|
#disconnect con132;
|
|
|
|
|
|
connection default;
|
|
|
|
DROP USER 'Tanjotuser1'@'localhost';
|
|
DROP USER 'Tanjotuser2'@'127.0.0.1';
|