| Server IP : 172.67.216.182 / Your IP : 172.69.176.72 Web Server : Apache System : Linux krdc-ubuntu-s-2vcpu-4gb-amd-blr1-01.localdomain 5.15.0-142-generic #152-Ubuntu SMP Mon May 19 10:54:31 UTC 2025 x86_64 User : www ( 1000) PHP Version : 7.4.33 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /www/server/mysql/src/mysql-test/suite/auth_sec/r/ |
Upload File : |
=======================================================================
Checking the password authentication with mysql_native_password plugin
=======================================================================
CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED BY 'abc';
CREATE USER 'Tanjotuser2'@'127.0.0.1' IDENTIFIED BY 'abc';
select (select plugin from mysql.user where User='Tanjotuser1' and Host='localhost')='mysql_native_password';
(select plugin from mysql.user where User='Tanjotuser1' and Host='localhost')='mysql_native_password'
1
1 Expected
select (select plugin from mysql.user where User='Tanjotuser2' and Host='127.0.0.1')='mysql_native_password';
(select plugin from mysql.user where User='Tanjotuser2' and Host='127.0.0.1')='mysql_native_password'
1
1 Expected
SET @@global.old_passwords=0;
Warnings:
Warning 1681 'old_passwords' is deprecated and will be removed in a future release.
SET @@session.old_passwords=0;
Warnings:
Warning 1681 'old_passwords' is deprecated and will be removed in a future release.
select (select authentication_string from mysql.user where User='Tanjotuser1' and Host='localhost')=password('abc');
(select authentication_string from mysql.user where User='Tanjotuser1' and Host='localhost')=password('abc')
1
Warnings:
Warning 1681 'PASSWORD' is deprecated and will be removed in a future release.
1 Expected
select (select authentication_string from mysql.user where User='Tanjotuser2' and Host='127.0.0.1')=password('abc');
(select authentication_string from mysql.user where User='Tanjotuser2' and Host='127.0.0.1')=password('abc')
1
Warnings:
Warning 1681 'PASSWORD' is deprecated and will be removed in a future release.
1 Expected
ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: NO)
ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: NO)
ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: NO)
ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: NO)
DROP USER 'Tanjotuser1'@'localhost';
DROP USER 'Tanjotuser2'@'127.0.0.1';
=======================================================================
Checking the password authentication with sha256_password plugin
=======================================================================
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: YES)
ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: YES)
SET @@global.old_passwords=2;
Warnings:
Warning 1681 'old_passwords' is deprecated and will be removed in a future release.
SET @@session.old_passwords=2;
Warnings:
Warning 1681 'old_passwords' is deprecated and will be removed in a future release.
SET PASSWORD FOR 'Tanjotuser1'@'localhost'='abc';
SET PASSWORD FOR 'Tanjotuser2'@'127.0.0.1'='abc';
ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: NO)
ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: NO)
ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: YES)
ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: YES)
DROP USER 'Tanjotuser1'@'localhost';
DROP USER 'Tanjotuser2'@'127.0.0.1';
====================================================================================================
checking the integrity of long password (more than 40 chars) using mysql_native_password plugin
====================================================================================================
CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED BY 'aaaaaaaaaabbbbbbbbbbccccccccccddddddddddeeeeeeeeeeaaaaaaaaaannnnnnnnnnaaaaaaaaaahhhhhhhhhh1111111111gggggggggg2222222222';
CREATE USER 'Tanjotuser2'@'127.0.0.1' IDENTIFIED BY 'aaaaaaaaaabbbbbbbbbbccccccccccddddddddddeeeeeeeeeeaaaaaaaaaannnnnnnnnnaaaaaaaaaahhhhhhhhhh1111111111gggggggggg2222222222';
ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: NO)
ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: NO)
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 @@global.old_passwords=2;
Warnings:
Warning 1681 'old_passwords' is deprecated and will be removed in a future release.
SET @@session.old_passwords=2;
Warnings:
Warning 1681 'old_passwords' is deprecated and will be removed in a future release.
SET PASSWORD FOR 'Tanjotuser1'@'localhost'='aaaaaaaaaabbbbbbbbbbccccccccccddddddddddeeeeeeeeeeaaaaaaaaaannnnnnnnnnaaaaaaaaaahhhhhhhhhh1111111111gggggggggg2222222222';
SET PASSWORD FOR 'Tanjotuser2'@'127.0.0.1'='aaaaaaaaaabbbbbbbbbbccccccccccddddddddddeeeeeeeeeeaaaaaaaaaannnnnnnnnnaaaaaaaaaahhhhhhhhhh1111111111gggggggggg2222222222';
ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: NO)
ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: NO)
DROP USER 'Tanjotuser1'@'localhost';
DROP USER 'Tanjotuser2'@'127.0.0.1';
====================================================================================================
checking the integrity of NULL password using mysql_native_password plugin
====================================================================================================
CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED BY '';
CREATE USER 'Tanjotuser2'@'127.0.0.1' IDENTIFIED BY '';
ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: YES)
ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: YES)
ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: YES)
ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: YES)
ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: YES)
ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: YES)
DROP USER 'Tanjotuser1'@'localhost';
DROP USER 'Tanjotuser2'@'127.0.0.1';
====================================================================================================
checking the integrity of NULL password using sha256_password plugin
====================================================================================================
CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED WITH 'sha256_password';
CREATE USER 'Tanjotuser2'@'127.0.0.1' IDENTIFIED WITH 'sha256_password';
SET @@global.old_passwords=2;
Warnings:
Warning 1681 'old_passwords' is deprecated and will be removed in a future release.
SET @@session.old_passwords=2;
Warnings:
Warning 1681 'old_passwords' is deprecated and will be removed in a future release.
SET PASSWORD FOR 'Tanjotuser1'@'localhost'='';
SET PASSWORD FOR 'Tanjotuser2'@'127.0.0.1'='';
ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: YES)
ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: YES)
ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: YES)
ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: YES)
DROP USER 'Tanjotuser1'@'localhost';
DROP USER 'Tanjotuser2'@'127.0.0.1';
=================================================================================================
checking the combination of Client default_auth=sha256_password and server default_auth=native
=================================================================================================
CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED WITH 'sha256_password';
CREATE USER 'Tanjotuser2'@'127.0.0.1' IDENTIFIED WITH 'sha256_password';
SET @@global.old_passwords=2;
Warnings:
Warning 1681 'old_passwords' is deprecated and will be removed in a future release.
SET @@session.old_passwords=2;
Warnings:
Warning 1681 'old_passwords' is deprecated and will be removed in a future release.
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';
**** Client default_auth=sha_256_password and server default auth=native
user() current_user()
Tanjotuser1@localhost Tanjotuser1@localhost
**** Client default_auth=native and server default auth=native
user() current_user()
Tanjotuser2@localhost [email protected]
**** Client default_auth=sha_256_password + public key on file.
user() current_user()
Tanjotuser1@localhost Tanjotuser1@localhost
DROP USER 'Tanjotuser1'@'localhost';
DROP USER 'Tanjotuser2'@'127.0.0.1';
=================================================================================================
Starting the server with the default authentication mysql_native_password
=================================================================================================
# Restart server with default-authentication-plugin=mysql_native_password;
Creating a user with mysql_native_password plugin
CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED BY 'abc';
Grant all on *.* to 'Tanjotuser1'@'localhost';
Creating a user with SHA256_password plugin
CREATE USER 'Tanjotuser3'@'localhost' IDENTIFIED WITH 'sha256_password';
set @@session.old_passwords=2;
Warnings:
Warning 1681 'old_passwords' is deprecated and will be removed in a future release.
set password for 'Tanjotuser3'@'localhost' ='abc';
Grant all on *.* to 'Tanjotuser3'@'localhost';
select (select plugin from mysql.user where User='Tanjotuser1' and Host='localhost')='mysql_native_password';
(select plugin from mysql.user where User='Tanjotuser1' and Host='localhost')='mysql_native_password'
1
1 Expected
select (select plugin from mysql.user where User='Tanjotuser3' and Host='localhost')='sha256_password';
(select plugin from mysql.user where User='Tanjotuser3' and Host='localhost')='sha256_password'
1
1 Expected
select @@global.old_passwords;
@@global.old_passwords
0
0 Expected
**** connecting Tanjotuser1 with Client default_auth=mysql_native_password
@@session.old_passwords
0
0 Expected
**** connecting Tanjotuser1 with Client default_auth=sha256_password
@@session.old_passwords
0
0 Expected
**** connecting Tanjotuser3 with Client default_auth=mysql_native_password
@@session.old_passwords
2
2 Expected
**** connecting Tanjotuser3 with Client default_auth=sha256_password
@@session.old_passwords
2
2 Expected
DROP USER 'Tanjotuser1'@'localhost';
DROP USER 'Tanjotuser3'@'localhost';
=================================================================================================
Starting the server with the default authentication sha256_password
=================================================================================================
# Restart server with default-authentication-plugin=sha256_password;
Creating a user with mysql_native_password plugin
CREATE USER 'Tanjotuser2'@'localhost' IDENTIFIED WITH 'mysql_native_password';
set @@session.old_passwords=0;
Warnings:
Warning 1681 'old_passwords' is deprecated and will be removed in a future release.
set password for 'Tanjotuser2'@'localhost' ='abc';
Grant all on *.* to 'Tanjotuser2'@'localhost';
Creating a user with SHA256_password plugin
CREATE USER 'Tanjotuser3'@'localhost' IDENTIFIED by 'abc';
Grant all on *.* to 'Tanjotuser3'@'localhost';
select (select plugin from mysql.user where User='Tanjotuser2' and Host='localhost')='mysql_native_password';
(select plugin from mysql.user where User='Tanjotuser2' and Host='localhost')='mysql_native_password'
1
1 Expected
select (select plugin from mysql.user where User='Tanjotuser3' and Host='localhost')='sha256_password';
(select plugin from mysql.user where User='Tanjotuser3' and Host='localhost')='sha256_password'
1
1 Expected
select @@global.old_passwords;
@@global.old_passwords
2
2 Expected
**** connecting Tanjotuser2 with Client default_auth=mysql_native_password
@@session.old_passwords
0
0 Expected
**** connecting Tanjotuser2 with Client default_auth=sha256_password
@@session.old_passwords
0
0 Expected
**** connecting Tanjotuser3 with Client default_auth=mysql_native_password
@@session.old_passwords
2
2 Expected
**** connecting Tanjotuser3 with Client default_auth=sha256_password
@@session.old_passwords
2
2 Expected
DROP USER 'Tanjotuser2'@'localhost';
DROP USER 'Tanjotuser3'@'localhost';
SET GLOBAL old_passwords= default;
Warnings:
Warning 1681 'old_passwords' is deprecated and will be removed in a future release.