126 lines
4.4 KiB
Plaintext
126 lines
4.4 KiB
Plaintext
|
|
|
|
======================================================================================
|
|
Checking the user access with SSL through user created with mysql_native_password plugin
|
|
======================================================================================
|
|
|
|
Creating a user with the mysql_native_plugin
|
|
CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED WITH 'mysql_native_password';
|
|
set password for 'Tanjotuser1'@'localhost' = 'abc';
|
|
GRANT ALL on *.* to 'Tanjotuser1'@'localhost';
|
|
**** connecting client using the ssl credentials
|
|
current_user()
|
|
Tanjotuser1@localhost
|
|
**** connecting client using the ssl credentials
|
|
current_user()
|
|
Tanjotuser1@localhost
|
|
**** connecting client using the ssl credentials
|
|
current_user()
|
|
Tanjotuser1@localhost
|
|
**** connecting client using the ssl credentials
|
|
current_user()
|
|
Tanjotuser1@localhost
|
|
**** connecting client using the ssl credentials
|
|
current_user()
|
|
Tanjotuser1@localhost
|
|
**** connecting client using the ssl credentials
|
|
current_user()
|
|
Tanjotuser1@localhost
|
|
DROP USER 'Tanjotuser1'@'localhost';
|
|
|
|
|
|
======================================================================================
|
|
Checking the user access with SSL through user created with sha256_password plugin
|
|
======================================================================================
|
|
|
|
Creating a user with the sha256_password plugin
|
|
CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED WITH 'sha256_password';
|
|
set password for 'Tanjotuser1'@'localhost' = 'abc';
|
|
GRANT ALL on *.* to 'Tanjotuser1'@'localhost';
|
|
**** connecting client using the ssl credentials
|
|
current_user()
|
|
Tanjotuser1@localhost
|
|
**** connecting client using the ssl credentials
|
|
current_user()
|
|
Tanjotuser1@localhost
|
|
**** connecting client using the ssl credentials
|
|
current_user()
|
|
Tanjotuser1@localhost
|
|
**** connecting client using the ssl credentials
|
|
current_user()
|
|
Tanjotuser1@localhost
|
|
**** connecting client using the ssl credentials
|
|
current_user()
|
|
Tanjotuser1@localhost
|
|
**** connecting client using the ssl credentials
|
|
current_user()
|
|
Tanjotuser1@localhost
|
|
DROP USER 'Tanjotuser1'@'localhost';
|
|
|
|
|
|
=================================================================================================
|
|
Starting the server with the default authentication sha256_password
|
|
=================================================================================================
|
|
|
|
# Restart server with default-authentication-plugin=sha256_password;
|
|
|
|
|
|
======================================================================================
|
|
Checking the user access with SSL through user created with mysql_native_password plugin
|
|
======================================================================================
|
|
|
|
Creating a user with the mysql_old_plugin
|
|
CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED WITH 'mysql_native_password';
|
|
set password for 'Tanjotuser1'@'localhost' = 'abc';
|
|
GRANT ALL on *.* to 'Tanjotuser1'@'localhost';
|
|
**** connecting client using the ssl credentials
|
|
current_user()
|
|
Tanjotuser1@localhost
|
|
**** connecting client using the ssl credentials
|
|
current_user()
|
|
Tanjotuser1@localhost
|
|
**** connecting client using the ssl credentials
|
|
current_user()
|
|
Tanjotuser1@localhost
|
|
**** connecting client using the ssl credentials
|
|
current_user()
|
|
Tanjotuser1@localhost
|
|
**** connecting client using the ssl credentials
|
|
current_user()
|
|
Tanjotuser1@localhost
|
|
**** connecting client using the ssl credentials
|
|
current_user()
|
|
Tanjotuser1@localhost
|
|
DROP USER 'Tanjotuser1'@'localhost';
|
|
|
|
|
|
======================================================================================
|
|
Checking the user access with SSL through user created with sha256_password plugin
|
|
======================================================================================
|
|
|
|
Creating a user with the sha256_plugin
|
|
CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED WITH 'sha256_password';
|
|
set password for 'Tanjotuser1'@'localhost' = 'abc';
|
|
GRANT ALL on *.* to 'Tanjotuser1'@'localhost';
|
|
**** connecting client using the ssl credentials
|
|
current_user()
|
|
Tanjotuser1@localhost
|
|
2 for GLOBAL Expected
|
|
2 for SESSION Expected
|
|
**** connecting client using the ssl credentials
|
|
current_user()
|
|
Tanjotuser1@localhost
|
|
2 for GLOBAL Expected
|
|
2 for SESSION Expected
|
|
**** connecting client using the ssl credentials
|
|
current_user()
|
|
Tanjotuser1@localhost
|
|
2 for GLOBAL Expected
|
|
2 for SESSION Expected
|
|
**** connecting client using the ssl credentials
|
|
current_user()
|
|
Tanjotuser1@localhost
|
|
2 for GLOBAL Expected
|
|
2 for SESSION Expected
|
|
DROP USER 'Tanjotuser1'@'localhost';
|