⚝
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
/
binlog
/
t
/
View File Name :
binlog_grant.test
# Test grants for various objects (especially variables) related to # the binary log source include/have_log_bin.inc; connection default; --disable_warnings reset master; --enable_warnings set @saved_binlog_format = @@global.binlog_format; create user mysqltest_1@localhost; show grants for mysqltest_1@localhost; connect (plain,localhost,mysqltest_1,,test); connect (root,localhost,root,,test); # Testing setting session SQL_LOG_BIN variable both as # root and as plain user. --echo **** Variable SQL_LOG_BIN **** connection root; --echo [root] set session sql_log_bin = 1; connection plain; --echo [plain] --error ER_SPECIFIC_ACCESS_DENIED_ERROR set session sql_log_bin = 1; # Testing setting both session and global BINLOG_FORMAT variable both # as root and as plain user. --echo **** Variable BINLOG_FORMAT **** connection root; --echo [root] set global binlog_format = row; set session binlog_format = row; connection plain; --echo [plain] --error ER_SPECIFIC_ACCESS_DENIED_ERROR set global binlog_format = row; --error ER_SPECIFIC_ACCESS_DENIED_ERROR set session binlog_format = row; --echo **** Clean up **** disconnect plain; disconnect root; connection default; set global binlog_format = @saved_binlog_format; drop user mysqltest_1@localhost; # Testing if REPLICATION CLIENT privilege is enough to execute # SHOW MASTER LOGS and SHOW BINARY. set @orig_sql_mode= @@sql_mode; set sql_mode= (select replace(@@sql_mode,'NO_AUTO_CREATE_USER','')); GRANT REPLICATION CLIENT ON *.* TO 'mysqltest_1'@'localhost'; set sql_mode= @orig_sql_mode; --connect(rpl,localhost,mysqltest_1,,) --connection rpl # We are only interested if the following commands succeed and not on # their output. --disable_result_log SHOW MASTER LOGS; SHOW BINARY LOGS; --enable_result_log # clean up --disconnect rpl connection default; DROP USER 'mysqltest_1'@'localhost';