[ Avaa Bypassed ]

Upload:

Command:

hmhc3928@18.219.242.213: ~ $ 

===========================================================================================================================================
Checking the password authentication using the sha256_password plugin at the client and mysql_native_password plugin at the server side
===========================================================================================================================================

select @@Global.old_passwords;
@@Global.old_passwords
0
0 Expected
select @@session.old_passwords;
@@session.old_passwords
0
0 Expected
CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED WITH 'sha256_password';
CREATE USER 'Tanjotuser2'@'127.0.0.1' IDENTIFIED WITH 'sha256_password';
select (select plugin from mysql.user where User='Tanjotuser1' and Host='localhost')='sha256_password';
(select plugin from mysql.user where User='Tanjotuser1' and Host='localhost')='sha256_password'
1
1 Expected
select (select plugin from mysql.user where User='Tanjotuser2' and Host='127.0.0.1')='sha256_password';
(select plugin from mysql.user where User='Tanjotuser2' and Host='127.0.0.1')='sha256_password'
1
1 Expected
ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
set @@session.old_passwords=2;
SET PASSWORD FOR 'Tanjotuser1'@'localhost'=PASSWORD('abc');
SET PASSWORD FOR 'Tanjotuser2'@'127.0.0.1'=PASSWORD('abc');
**** connecting Tanjotuser1 with server 
@@session.old_passwords
2
2 Expected
**** connecting Tanjotuser2 with server 
@@session.old_passwords
2
2 Expected
**** connecting Tanjotuser1 with server 
@@session.old_passwords
2
2 Expected
**** connecting Tanjotuser2 with server 
@@session.old_passwords
2
2 Expected
**** connecting Tanjotuser1 with server 
@@session.old_passwords
2
2 Expected
**** connecting Tanjotuser2 with server 
@@session.old_passwords
2
2 Expected
**** connecting Tanjotuser1 with server 
@@session.old_passwords
2
2 Expected
**** connecting Tanjotuser2 with server 
@@session.old_passwords
2
2 Expected
ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
select @@global.secure_auth;
@@global.secure_auth
1
1 Expected
set @@global.secure_auth=0;
ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
DROP USER 'Tanjotuser1'@'localhost';
DROP USER 'Tanjotuser2'@'127.0.0.1';


====================================================================================================
checking the integrity of long password (more than 40 chars) using sha256_password plugin
====================================================================================================

CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED WITH 'sha256_password';
CREATE USER 'Tanjotuser2'@'127.0.0.1' IDENTIFIED WITH 'sha256_password';
SET @@session.old_passwords=2;
SET PASSWORD FOR 'Tanjotuser1'@'localhost'=PASSWORD('$$$$$$$$$$^^^^^^^^^^&&&&&&&&&&**********((((((((((##########!!!!!!!!!!@@@@@@@@@@          @@@@@@@@@@__________');
SET PASSWORD FOR 'Tanjotuser2'@'127.0.0.1'=PASSWORD('$$$$$$$$$$^^^^^^^^^^&&&&&&&&&&**********((((((((((##########!!!!!!!!!!@@@@@@@@@@          @@@@@@@@@@__________');
set @@global.secure_auth=0;
set @@global.secure_auth=1;
ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
DROP USER 'Tanjotuser1'@'localhost';
DROP USER 'Tanjotuser2'@'127.0.0.1';


============================================================================================================================================
Checking the password authentication using the sha256_password plugin at the client and sha256_password plugin at the server side
============================================================================================================================================

# Restart server with default-authentication-plugin=sha256_password;
select @@Global.old_passwords;
@@Global.old_passwords
2
2 Expected
select @@session.old_passwords;
@@session.old_passwords
0
0 Expected
CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED WITH 'sha256_password';
CREATE USER 'Tanjotuser2'@'127.0.0.1' IDENTIFIED WITH 'sha256_password';
select (select plugin from mysql.user where User='Tanjotuser1' and Host='localhost')='sha256_password';
(select plugin from mysql.user where User='Tanjotuser1' and Host='localhost')='sha256_password'
1
1 Expected
select (select plugin from mysql.user where User='Tanjotuser2' and Host='127.0.0.1')='sha256_password';
(select plugin from mysql.user where User='Tanjotuser2' and Host='127.0.0.1')='sha256_password'
1
1 Expected
ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
SET @@session.old_passwords=2;
SET PASSWORD FOR 'Tanjotuser1'@'localhost'=PASSWORD('abc');
SET PASSWORD FOR 'Tanjotuser2'@'127.0.0.1'=PASSWORD('abc');
**** connecting Tanjotuser1 with server 
@@session.old_passwords
2
2 Expected
**** connecting Tanjotuser2 with server 
@@session.old_passwords
2
2 Expected
**** connecting Tanjotuser1 with server 
@@session.old_passwords
2
2 Expected
**** connecting Tanjotuser2 with server 
@@session.old_passwords
2
2 Expected
**** connecting Tanjotuser1 with server 
@@session.old_passwords
2
2 Expected
**** connecting Tanjotuser2 with server 
@@session.old_passwords
2
2 Expected
**** connecting Tanjotuser1 with server 
@@session.old_passwords
2
2 Expected
**** connecting Tanjotuser2 with server 
@@session.old_passwords
2
2 Expected
ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
select @@global.secure_auth;
@@global.secure_auth
1
1 Expected
set @@global.secure_auth=0;
ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
DROP USER 'Tanjotuser1'@'localhost';
DROP USER 'Tanjotuser2'@'127.0.0.1';


====================================================================================================
checking the integrity of long password (more than 40 chars) using sha256_password plugin
====================================================================================================

CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED WITH 'sha256_password';
CREATE USER 'Tanjotuser2'@'127.0.0.1' IDENTIFIED WITH 'sha256_password';
SET @@session.old_passwords=2;
SET PASSWORD FOR 'Tanjotuser1'@'localhost'=PASSWORD('$$$$$$$$$$^^^^^^^^^^&&&&&&&&&&**********((((((((((##########!!!!!!!!!!@@@@@@@@@@          @@@@@@@@@@__________');
SET PASSWORD FOR 'Tanjotuser2'@'127.0.0.1'=PASSWORD('$$$$$$$$$$^^^^^^^^^^&&&&&&&&&&**********((((((((((##########!!!!!!!!!!@@@@@@@@@@          @@@@@@@@@@__________');
set @@global.secure_auth=0;
set @@global.secure_auth=1;
ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: )
ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: )
DROP USER 'Tanjotuser1'@'localhost';
DROP USER 'Tanjotuser2'@'127.0.0.1';
SET @@global.secure_auth=default;
SET @@global.old_passwords=default;
SET @@session.old_passwords=default;

Filemanager

DIR : / usr/ share/ mysql-test/ suite/ auth_sec/ r/
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