⚝
One Hat Cyber Team
⚝
Your IP:
216.73.216.124
Server IP:
50.28.103.30
Server:
Linux host.jcukjv-lwsites.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
Server Software:
nginx/1.28.0
PHP Version:
8.3.12
Buat File
|
Buat Folder
Eksekusi
Dir :
~
/
www
/
server
/
mysql
/
mysql-test
/
t
/
View File Name :
disconnect_on_expired_password_default.test
## WL6587 Test --disconnect-on-expired-passwords=default (on) --source include/not_embedded.inc SHOW VARIABLES LIKE 'disconnect_on_expired_password'; --echo ## Test mysql client in non-interactrive mode CREATE USER 'bernt'; ALTER USER 'bernt' IDENTIFIED BY 'secret'; ALTER USER 'bernt' PASSWORD EXPIRE; --echo # Attempt to login should fail --error 1 --exec $MYSQL -ubernt -psecret -e "EXIT" 2>&1 DROP USER 'bernt'; --echo ## Test mysqltest CREATE USER 'bernt'; ALTER USER 'bernt' IDENTIFIED BY 'secret'; ALTER USER 'bernt' PASSWORD EXPIRE; --echo # Login with mysqltest should work connect(con2,localhost,bernt,secret,,); --echo # But doing something should fail --error 1820 SELECT 1; --echo # Setting password should work ALTER USER 'bernt' IDENTIFIED BY 'secret'; disconnect con2; connection default; DROP USER 'bernt'; --echo ## Test mysqladmin CREATE USER 'bernt'; ALTER USER 'bernt' IDENTIFIED BY 'secret'; GRANT ALL ON *.* TO 'bernt' WITH GRANT OPTION; ALTER USER 'bernt' PASSWORD EXPIRE; --echo # Doing something should not connect --replace_result $MYSQLADMIN MYSQLADMIN --error 1 --exec $MYSQLADMIN --no-defaults -S $MASTER_MYSOCK -P $MASTER_MYPORT --user=bernt --password=secret reload 2>&1 --echo # Setting password should succeed --exec $MYSQLADMIN --no-defaults --user=bernt --password=secret -S $MASTER_MYSOCK -P $MASTER_MYPORT password newsecret --ssl-mode=REQUIRED 2>&1 DROP USER 'bernt';