4493d40a-92aa-4162-9dfc-bfc4ec0996e6
/
polardbxengine
2
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
polardbxengine/mysql-test/suite/xengine_auth_sec/r/multiple_passwords.result

283 lines
14 KiB
Plaintext
Raw Permalink Blame History

#-----------------------------------------------------------------------
#-----------------------------------------------------------------------
# Setup : Create users
CREATE USER arthurdent@localhost IDENTIFIED WITH 'mysql_native_password' BY 'abcd';
#-----------------------------------------------------------------------
# Second password tests
ALTER USER arthurdent@localhost IDENTIFIED BY 'efgh' RETAIN CURRENT PASSWORD;
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
ALTER USER arthurdent@localhost DISCARD OLD PASSWORD;
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'arthurdent'@'localhost' (using password: YES)
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'arthurdent'@'localhost' (using password: YES)
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
ALTER USER arthurdent@localhost IDENTIFIED BY 'ijkl' RETAIN CURRENT PASSWORD;
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
ALTER USER arthurdent@localhost IDENTIFIED BY 'mnop';
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
ALTER USER arthurdent@localhost DISCARD OLD PASSWORD;
SET PASSWORD FOR arthurdent@localhost = 'qrst' RETAIN CURRENT PASSWORD;
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
ALTER USER arthurdent@localhost DISCARD OLD PASSWORD;
ALTER USER arthurdent@localhost IDENTIFIED BY 'abcd';
ALTER USER arthurdent@localhost IDENTIFIED BY 'efgh' RETAIN CURRENT PASSWORD;
ALTER USER arthurdent@localhost PASSWORD EXPIRE;
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1820 (HY000) at line 1: You must reset your password using ALTER USER statement before executing this statement.
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1820 (HY000) at line 1: You must reset your password using ALTER USER statement before executing this statement.
ALTER USER arthurdent@localhost IDENTIFIED BY 'abcd';
GRANT APPLICATION_PASSWORD_ADMIN ON *.* TO arthurdent@localhost;
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
1
1
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'arthurdent'@'localhost' (using password: YES)
mysql: [Warning] Using a password on the command line interface can be insecure.
1
1
#-----------------------------------------------------------------------
# Cleanup
DROP USER arthurdent@localhost;
#-----------------------------------------------------------------------
#-----------------------------------------------------------------------
# Setup : Create users
CREATE USER arthurdent@localhost IDENTIFIED WITH 'caching_sha2_password' BY 'abcd';
#-----------------------------------------------------------------------
# Second password tests
ALTER USER arthurdent@localhost IDENTIFIED BY 'efgh' RETAIN CURRENT PASSWORD;
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
ALTER USER arthurdent@localhost DISCARD OLD PASSWORD;
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'arthurdent'@'localhost' (using password: YES)
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2061 (HY000): Authentication plugin 'caching_sha2_password' reported error: Authentication requires secure connection.
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
ALTER USER arthurdent@localhost IDENTIFIED BY 'ijkl' RETAIN CURRENT PASSWORD;
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
ALTER USER arthurdent@localhost IDENTIFIED BY 'mnop';
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
ALTER USER arthurdent@localhost DISCARD OLD PASSWORD;
SET PASSWORD FOR arthurdent@localhost = 'qrst' RETAIN CURRENT PASSWORD;
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
ALTER USER arthurdent@localhost DISCARD OLD PASSWORD;
ALTER USER arthurdent@localhost IDENTIFIED BY 'abcd';
ALTER USER arthurdent@localhost IDENTIFIED BY 'efgh' RETAIN CURRENT PASSWORD;
ALTER USER arthurdent@localhost PASSWORD EXPIRE;
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1820 (HY000) at line 1: You must reset your password using ALTER USER statement before executing this statement.
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1820 (HY000) at line 1: You must reset your password using ALTER USER statement before executing this statement.
ALTER USER arthurdent@localhost IDENTIFIED BY 'abcd';
GRANT APPLICATION_PASSWORD_ADMIN ON *.* TO arthurdent@localhost;
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
1
1
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'arthurdent'@'localhost' (using password: YES)
mysql: [Warning] Using a password on the command line interface can be insecure.
1
1
#-----------------------------------------------------------------------
# Cleanup
DROP USER arthurdent@localhost;
#-----------------------------------------------------------------------
#-----------------------------------------------------------------------
# Setup : Create users
CREATE USER arthurdent@localhost IDENTIFIED WITH 'sha256_password' BY 'abcd';
#-----------------------------------------------------------------------
# Second password tests
ALTER USER arthurdent@localhost IDENTIFIED BY 'efgh' RETAIN CURRENT PASSWORD;
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
ALTER USER arthurdent@localhost DISCARD OLD PASSWORD;
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'arthurdent'@'localhost' (using password: YES)
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'arthurdent'@'localhost' (using password: YES)
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
ALTER USER arthurdent@localhost IDENTIFIED BY 'ijkl' RETAIN CURRENT PASSWORD;
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
ALTER USER arthurdent@localhost IDENTIFIED BY 'mnop';
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
ALTER USER arthurdent@localhost DISCARD OLD PASSWORD;
SET PASSWORD FOR arthurdent@localhost = 'qrst' RETAIN CURRENT PASSWORD;
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
CURRENT_USER()
arthurdent@localhost
ALTER USER arthurdent@localhost DISCARD OLD PASSWORD;
ALTER USER arthurdent@localhost IDENTIFIED BY 'abcd';
ALTER USER arthurdent@localhost IDENTIFIED BY 'efgh' RETAIN CURRENT PASSWORD;
ALTER USER arthurdent@localhost PASSWORD EXPIRE;
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1820 (HY000) at line 1: You must reset your password using ALTER USER statement before executing this statement.
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1820 (HY000) at line 1: You must reset your password using ALTER USER statement before executing this statement.
ALTER USER arthurdent@localhost IDENTIFIED BY 'abcd';
GRANT APPLICATION_PASSWORD_ADMIN ON *.* TO arthurdent@localhost;
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
1
1
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'arthurdent'@'localhost' (using password: YES)
mysql: [Warning] Using a password on the command line interface can be insecure.
1
1
#-----------------------------------------------------------------------
# Cleanup
DROP USER arthurdent@localhost;
#-----------------------------------------------------------------------
#-----------------------------------------------------------------------
#-----------------------------------------------------------------------
Reference in New Issue View Git Blame Copy Permalink