⚝
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
/
suite
/
x
/
r
/
View File Name :
connection_skip_grant_table.result
install plugin mysqlx soname "mysqlx.so"; call mtr.add_suppression("Plugin mysqlx reported: .Failed at SSL configuration: .SSL context is not usable without certificate and private key.."); call mtr.add_suppression("Plugin mysqlx reported: .SSL_CTX_load_verify_locations failed."); call mtr.add_suppression("Plugin 'mysqlx' will be forced to shutdown"); call mtr.add_suppression("Unsuccessful login attempt: Invalid user or password"); call mtr.add_suppression("Internal account mysqlxsys@localhost can't be removed because server is running without user privileges ..skip-grant-tables. switch"); SELECT PLUGIN_NAME,PLUGIN_VERSION,PLUGIN_STATUS,PLUGIN_TYPE,PLUGIN_TYPE_VERSION,PLUGIN_LIBRARY,PLUGIN_LIBRARY_VERSION,PLUGIN_AUTHOR,PLUGIN_DESCRIPTION,PLUGIN_LICENSE,LOAD_OPTION from information_schema.plugins where PLUGIN_NAME LIKE '%xplugin%'; PLUGIN_NAME PLUGIN_VERSION PLUGIN_STATUS PLUGIN_TYPE PLUGIN_TYPE_VERSION PLUGIN_LIBRARY PLUGIN_LIBRARY_VERSION PLUGIN_AUTHOR PLUGIN_DESCRIPTION PLUGIN_LICENSE LOAD_OPTION create user nonblank@localhost identified by 'nonblank'; Test starts here RUN select user(),current_user(),@@bind_address user() current_user() @@bind_address nonblank@localhost nonblank@localhost * 0 rows affected Mysqlx.Ok { msg: "bye!" } ok try login with valid user when server started with skip-grant-tables and mysqlx loaded # restart: --skip-grant-tables --plugin-load=mysqlx.so Connection should success with valid password RUN select user(),current_user(),@@bind_address user() current_user() @@bind_address nonblank@ skip-grants user@skip-grants host * 0 rows affected Mysqlx.Ok { msg: "bye!" } ok Connection should success with invalid password RUN select user(),current_user(),@@bind_address user() current_user() @@bind_address nonblank@ skip-grants user@skip-grants host * 0 rows affected Mysqlx.Ok { msg: "bye!" } ok FLUSH PRIVILEGES; Application terminated with expected error: Invalid user or password (code 1045) not ok # restart: --skip-grant-tables --plugin-load=mysqlx.so RUN uninstall plugin mysqlx While executing uninstall plugin mysqlx: Got expected error: Command not supported by pluggable protocols (code 3130) Mysqlx.Ok { msg: "bye!" } ok UNINSTALL PLUGIN mysqlx; # restart: --plugin-load=mysqlx.so drop user nonblank@localhost; UNINSTALL PLUGIN mysqlx;