1 2 3=========================================================================================================================================== 4Checking the password authentication using the sha256_password plugin at the client and mysql_native_password plugin at the server side 5=========================================================================================================================================== 6 7CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED WITH 'sha256_password'; 8CREATE USER 'Tanjotuser2'@'127.0.0.1' IDENTIFIED WITH 'sha256_password'; 9select (select plugin from mysql.user where User='Tanjotuser1' and Host='localhost')='sha256_password'; 10(select plugin from mysql.user where User='Tanjotuser1' and Host='localhost')='sha256_password' 111 121 Expected 13select (select plugin from mysql.user where User='Tanjotuser2' and Host='127.0.0.1')='sha256_password'; 14(select plugin from mysql.user where User='Tanjotuser2' and Host='127.0.0.1')='sha256_password' 151 161 Expected 17ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: ) 18ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: ) 19SET PASSWORD FOR 'Tanjotuser1'@'localhost'='abc'; 20SET PASSWORD FOR 'Tanjotuser2'@'127.0.0.1'='abc'; 21ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: ) 22ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: ) 23ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: ) 24ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: ) 25ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: ) 26ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: ) 27ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: ) 28ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: ) 29ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: ) 30ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: ) 31ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: ) 32ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: ) 33ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: ) 34ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: ) 35ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: ) 36ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: ) 37DROP USER 'Tanjotuser1'@'localhost'; 38DROP USER 'Tanjotuser2'@'127.0.0.1'; 39 40 41==================================================================================================== 42checking the integrity of long password (more than 40 chars) using sha256_password plugin 43==================================================================================================== 44 45CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED WITH 'sha256_password'; 46CREATE USER 'Tanjotuser2'@'127.0.0.1' IDENTIFIED WITH 'sha256_password'; 47SET PASSWORD FOR 'Tanjotuser1'@'localhost'='$$$$$$$$$$^^^^^^^^^^&&&&&&&&&&**********((((((((((##########!!!!!!!!!!@@@@@@@@@@ @@@@@@@@@@__________'; 48SET PASSWORD FOR 'Tanjotuser2'@'127.0.0.1'='$$$$$$$$$$^^^^^^^^^^&&&&&&&&&&**********((((((((((##########!!!!!!!!!!@@@@@@@@@@ @@@@@@@@@@__________'; 49ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: ) 50ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: ) 51ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: ) 52ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: ) 53ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: ) 54ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: ) 55ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: ) 56ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: ) 57DROP USER 'Tanjotuser1'@'localhost'; 58DROP USER 'Tanjotuser2'@'127.0.0.1'; 59 60 61============================================================================================================================================ 62Checking the password authentication using the sha256_password plugin at the client and sha256_password plugin at the server side 63============================================================================================================================================ 64 65# Restart server with default-authentication-plugin=sha256_password; 66CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED WITH 'sha256_password'; 67CREATE USER 'Tanjotuser2'@'127.0.0.1' IDENTIFIED WITH 'sha256_password'; 68select (select plugin from mysql.user where User='Tanjotuser1' and Host='localhost')='sha256_password'; 69(select plugin from mysql.user where User='Tanjotuser1' and Host='localhost')='sha256_password' 701 711 Expected 72select (select plugin from mysql.user where User='Tanjotuser2' and Host='127.0.0.1')='sha256_password'; 73(select plugin from mysql.user where User='Tanjotuser2' and Host='127.0.0.1')='sha256_password' 741 751 Expected 76ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: ) 77ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: ) 78SET PASSWORD FOR 'Tanjotuser1'@'localhost'='abc'; 79SET PASSWORD FOR 'Tanjotuser2'@'127.0.0.1'='abc'; 80ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: ) 81ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: ) 82ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: ) 83ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: ) 84ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: ) 85ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: ) 86ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: ) 87ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: ) 88ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: ) 89ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: ) 90ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: ) 91ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: ) 92ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: ) 93ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: ) 94ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: ) 95ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: ) 96DROP USER 'Tanjotuser1'@'localhost'; 97DROP USER 'Tanjotuser2'@'127.0.0.1'; 98 99 100==================================================================================================== 101checking the integrity of long password (more than 40 chars) using sha256_password plugin 102==================================================================================================== 103 104CREATE USER 'Tanjotuser1'@'localhost' IDENTIFIED WITH 'sha256_password'; 105CREATE USER 'Tanjotuser2'@'127.0.0.1' IDENTIFIED WITH 'sha256_password'; 106SET PASSWORD FOR 'Tanjotuser1'@'localhost'='$$$$$$$$$$^^^^^^^^^^&&&&&&&&&&**********((((((((((##########!!!!!!!!!!@@@@@@@@@@ @@@@@@@@@@__________'; 107SET PASSWORD FOR 'Tanjotuser2'@'127.0.0.1'='$$$$$$$$$$^^^^^^^^^^&&&&&&&&&&**********((((((((((##########!!!!!!!!!!@@@@@@@@@@ @@@@@@@@@@__________'; 108ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: ) 109ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: ) 110ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: ) 111ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: ) 112ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: ) 113ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: ) 114ERROR 28000: Access denied for user 'Tanjotuser1'@'localhost' (using password: ) 115ERROR 28000: Access denied for user 'Tanjotuser2'@'localhost' (using password: ) 116DROP USER 'Tanjotuser1'@'localhost'; 117DROP USER 'Tanjotuser2'@'127.0.0.1'; 118# restart: 119