⚝
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 :
plugin_auth_user_lock.test
# # Test account lock / unlock of the proxy and proxied users # --source include/have_plugin_auth.inc --source include/not_embedded.inc --echo # Create proxy and proxied users CREATE USER 'empl_external'@'localhost' IDENTIFIED WITH test_plugin_server AS 'employee'; CREATE USER 'employee'@'localhost' IDENTIFIED BY 'passkey'; GRANT PROXY ON 'employee'@'localhost' TO 'empl_external'@'localhost'; --echo # Lock proxied user - proxy user login should work connection default; ALTER USER employee@localhost ACCOUNT LOCK; --connect(employee_con, localhost, empl_external, employee) SELECT USER(), CURRENT_USER(); disconnect employee_con; --echo # Lock proxy user - login should fail connection default; ALTER USER empl_external@localhost ACCOUNT LOCK; --replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT --error ER_ACCOUNT_HAS_BEEN_LOCKED --connect(employee_con, localhost, empl_external, employee) --echo # Unlocking proxied user should not change anything - login should fail connection default; ALTER USER employee@localhost ACCOUNT UNLOCK; --replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT --error ER_ACCOUNT_HAS_BEEN_LOCKED --connect(employee_con, localhost, empl_external, employee) #Cleanup DROP USER 'empl_external'@'localhost', 'employee'@'localhost';