======================================================================================
Checking the user access with SSL through user created with mysql_old_password plugin
======================================================================================
Creating a user with the mysql_old_plugin
CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED WITH 'mysql_old_password';
set @@session.old_passwords=1;
set password for 'Tanjotuser1'@'localhost' = password('abc');
Warnings:
Warning 1287 'pre-4.1 password hash' is deprecated and will be removed in a future release. Please use post-4.1 password hash instead
GRANT ALL on *.* to 'Tanjotuser1'@'localhost';
The client should not connect with secure auth enabled.
select @@global.secure_auth;
@@global.secure_auth
1
1 Expected
**** connecting client using the ssl credentials
**** connecting client using the ssl credentials
**** connecting client using the ssl credentials
**** connecting client using the ssl credentials
The client should connect with secure auth disabled.
set @@global.secure_auth=0;
**** connecting client using the ssl credentials
@@Global.old_passwords
0
@@session.old_passwords
1
0 for GLOBAL Expected
1 for SESSION Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
0
@@session.old_passwords
1
0 for GLOBAL Expected
1 for SESSION Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
0
@@session.old_passwords
1
0 for GLOBAL Expected
1 for SESSION Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
0
@@session.old_passwords
1
0 for GLOBAL Expected
1 for SESSION Expected
The mysql_old_password plugin client should not connect with secure auth enabled at the client side.
select @@global.secure_auth;
@@global.secure_auth
0
0 Expected
**** connecting client using the ssl credentials
**** connecting client using the ssl credentials
**** connecting client using the ssl credentials
**** connecting client using the ssl credentials
DROP USER 'Tanjotuser1'@'localhost';
======================================================================================
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 @@session.old_passwords=0;
set password for 'Tanjotuser1'@'localhost' = password('abc');
GRANT ALL on *.* to 'Tanjotuser1'@'localhost';
The client should connect with secure auth enabled.
select @@global.secure_auth;
@@global.secure_auth
0
0 Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
0
@@session.old_passwords
0
0 for GLOBAL Expected
0 for SESSION Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
0
@@session.old_passwords
0
0 for GLOBAL Expected
0 for SESSION Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
0
@@session.old_passwords
0
0 for GLOBAL Expected
0 for SESSION Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
0
@@session.old_passwords
0
0 for GLOBAL Expected
0 for SESSION Expected
The client should connect with secure auth disabled.
set @@global.secure_auth=0;
**** connecting client using the ssl credentials
@@Global.old_passwords
0
@@session.old_passwords
0
0 for GLOBAL Expected
0 for SESSION Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
0
@@session.old_passwords
0
0 for GLOBAL Expected
0 for SESSION Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
0
@@session.old_passwords
0
0 for GLOBAL Expected
0 for SESSION Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
0
@@session.old_passwords
0
0 for GLOBAL Expected
0 for SESSION Expected
The mysql_native_password plugin client should connect with secure auth enabled at the client side.
select @@global.secure_auth;
@@global.secure_auth
0
0 Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
0
@@session.old_passwords
0
0 for GLOBAL Expected
0 for SESSION Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
0
@@session.old_passwords
0
0 for GLOBAL Expected
0 for SESSION Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
0
@@session.old_passwords
0
0 for GLOBAL Expected
0 for SESSION Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
0
@@session.old_passwords
0
0 for GLOBAL Expected
0 for SESSION Expected
DROP USER 'Tanjotuser1'@'localhost';
======================================================================================
Checking the user access with SSL through user created with sha256_password plugin
======================================================================================
Creating a user with the mysql_old_plugin
CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED WITH 'sha256_password';
set @@session.old_passwords=2;
set password for 'Tanjotuser1'@'localhost' = password('abc');
GRANT ALL on *.* to 'Tanjotuser1'@'localhost';
The client should connect with secure auth enabled.
select @@global.secure_auth;
@@global.secure_auth
0
0 Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
0
@@session.old_passwords
2
0 for GLOBAL Expected
2 for SESSION Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
0
@@session.old_passwords
2
0 for GLOBAL Expected
2 for SESSION Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
0
@@session.old_passwords
2
0 for GLOBAL Expected
2 for SESSION Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
0
@@session.old_passwords
2
0 for GLOBAL Expected
2 for SESSION Expected
The client should connect with secure auth disabled.
set @@global.secure_auth=0;
**** connecting client using the ssl credentials
@@Global.old_passwords
0
@@session.old_passwords
2
0 for GLOBAL Expected
2 for SESSION Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
0
@@session.old_passwords
2
0 for GLOBAL Expected
2 for SESSION Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
0
@@session.old_passwords
2
0 for GLOBAL Expected
2 for SESSION Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
0
@@session.old_passwords
2
0 for GLOBAL Expected
2 for SESSION Expected
The mysql_native_password plugin client should connect with secure auth enabled at the client side.
select @@global.secure_auth;
@@global.secure_auth
0
0 Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
0
@@session.old_passwords
2
0 for GLOBAL Expected
2 for SESSION Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
0
@@session.old_passwords
2
0 for GLOBAL Expected
2 for SESSION Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
0
@@session.old_passwords
2
0 for GLOBAL Expected
2 for SESSION Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
0
@@session.old_passwords
2
0 for GLOBAL Expected
2 for SESSION Expected
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_old_password plugin
======================================================================================
Creating a user with the mysql_old_plugin
CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED WITH 'mysql_old_password';
set @@session.old_passwords=1;
set password for 'Tanjotuser1'@'localhost' = password('abc');
Warnings:
Warning 1287 'pre-4.1 password hash' is deprecated and will be removed in a future release. Please use post-4.1 password hash instead
GRANT ALL on *.* to 'Tanjotuser1'@'localhost';
The client should not connect with secure auth enabled.
select @@global.secure_auth;
@@global.secure_auth
1
1 Expected
**** connecting client using the ssl credentials
**** connecting client using the ssl credentials
**** connecting client using the ssl credentials
**** connecting client using the ssl credentials
The client should connect with secure auth disabled.
set @@global.secure_auth=0;
**** connecting client using the ssl credentials
@@Global.old_passwords
2
@@session.old_passwords
1
2 for GLOBAL Expected
1 for SESSION Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
2
@@session.old_passwords
1
2 for GLOBAL Expected
1 for SESSION Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
2
@@session.old_passwords
1
2 for GLOBAL Expected
1 for SESSION Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
2
@@session.old_passwords
1
2 for GLOBAL Expected
1 for SESSION Expected
The mysql_old_password plugin client should not connect with secure auth enabled at the client side.
select @@global.secure_auth;
@@global.secure_auth
0
0 Expected
**** connecting client using the ssl credentials
**** connecting client using the ssl credentials
**** connecting client using the ssl credentials
**** connecting client using the ssl credentials
DROP USER 'Tanjotuser1'@'localhost';
======================================================================================
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 @@session.old_passwords=0;
set password for 'Tanjotuser1'@'localhost' = password('abc');
GRANT ALL on *.* to 'Tanjotuser1'@'localhost';
The client should connect with secure auth enabled.
select @@global.secure_auth;
@@global.secure_auth
0
0 Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
2
@@session.old_passwords
0
2 for GLOBAL Expected
0 for SESSION Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
2
@@session.old_passwords
0
2 for GLOBAL Expected
0 for SESSION Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
2
@@session.old_passwords
0
2 for GLOBAL Expected
0 for SESSION Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
2
@@session.old_passwords
0
2 for GLOBAL Expected
0 for SESSION Expected
The client should connect with secure auth disabled.
set @@global.secure_auth=0;
**** connecting client using the ssl credentials
@@Global.old_passwords
2
@@session.old_passwords
0
2 for GLOBAL Expected
0 for SESSION Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
2
@@session.old_passwords
0
2 for GLOBAL Expected
0 for SESSION Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
2
@@session.old_passwords
0
2 for GLOBAL Expected
0 for SESSION Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
2
@@session.old_passwords
0
2 for GLOBAL Expected
0 for SESSION Expected
The mysql_native_password plugin client should connect with secure auth enabled at the client side.
select @@global.secure_auth;
@@global.secure_auth
0
0 Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
2
@@session.old_passwords
0
2 for GLOBAL Expected
0 for SESSION Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
2
@@session.old_passwords
0
2 for GLOBAL Expected
0 for SESSION Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
2
@@session.old_passwords
0
2 for GLOBAL Expected
0 for SESSION Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
2
@@session.old_passwords
0
2 for GLOBAL Expected
0 for SESSION Expected
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 @@session.old_passwords=2;
set password for 'Tanjotuser1'@'localhost' = password('abc');
GRANT ALL on *.* to 'Tanjotuser1'@'localhost';
The client should connect with secure auth enabled.
select @@global.secure_auth;
@@global.secure_auth
0
0 Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
2
@@session.old_passwords
2
2 for GLOBAL Expected
2 for SESSION Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
2
@@session.old_passwords
2
2 for GLOBAL Expected
2 for SESSION Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
2
@@session.old_passwords
2
2 for GLOBAL Expected
2 for SESSION Expected
The client should connect with secure auth disabled.
set @@global.secure_auth=0;
**** connecting client using the ssl credentials
@@Global.old_passwords
2
@@session.old_passwords
2
2 for GLOBAL Expected
2 for SESSION Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
2
@@session.old_passwords
2
2 for GLOBAL Expected
2 for SESSION Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
2
@@session.old_passwords
2
2 for GLOBAL Expected
2 for SESSION Expected
The mysql_native_password plugin client should connect with secure auth enabled at the client side.
select @@global.secure_auth;
@@global.secure_auth
0
0 Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
2
@@session.old_passwords
2
2 for GLOBAL Expected
2 for SESSION Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
2
@@session.old_passwords
2
2 for GLOBAL Expected
2 for SESSION Expected
**** connecting client using the ssl credentials
@@Global.old_passwords
2
@@session.old_passwords
2
2 for GLOBAL Expected
2 for SESSION Expected
DROP USER 'Tanjotuser1'@'localhost';
set @@global.secure_auth=default;
set @@session.old_passwords=default;
| Name | Type | Size | Permission | Actions |
|---|---|---|---|---|
| access_credential_control.result | File | 30.47 KB | 0644 |
|
| cert_verify.result | File | 304 B | 0644 |
|
| have_mysql_upgrade.result | File | 21 B | 0644 |
|
| have_ssl.require | File | 33 B | 0644 |
|
| key_value_auth.result | File | 21.85 KB | 0644 |
|
| mysql_native_plugin.result | File | 11.18 KB | 0644 |
|
| mysql_no_login.result | File | 1.75 KB | 0644 |
|
| mysql_old_passwords.result | File | 19.09 KB | 0644 |
|
| mysql_old_plugin.result | File | 15.43 KB | 0644 |
|
| mysql_sha256_plugin.result | File | 11.1 KB | 0644 |
|
| not_embedded.require | File | 16 B | 0644 |
|
| not_openssl.require | File | 36 B | 0644 |
|
| not_ssl.require | File | 32 B | 0644 |
|
| openssl.require | File | 37 B | 0644 |
|
| password_expired.result | File | 27.84 KB | 0644 |
|
| secure_file_priv_error.result | File | 358 B | 0644 |
|
| secure_file_priv_null.result | File | 1.08 KB | 0644 |
|
| secure_file_priv_warnings.result | File | 876 B | 0644 |
|
| secure_file_priv_warnings_not_win.result | File | 582 B | 0644 |
|
| secure_file_priv_warnings_win.result | File | 454 B | 0644 |
|
| server_withssl_client_withoutssl.result | File | 14.53 KB | 0644 |
|
| server_withssl_client_withssl.result | File | 14.33 KB | 0644 |
|