Server IP : 185.86.78.101 / Your IP : 216.73.216.213 Web Server : Apache System : Linux 675867-vds-valikoshka1996.gmhost.pp.ua 5.4.0-150-generic #167-Ubuntu SMP Mon May 15 17:35:05 UTC 2023 x86_64 User : www ( 1000) PHP Version : 7.4.33 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : OFF Directory : /www/server/mysql/mysql-test/r/ |
Upload File : |
TRUNCATE TABLE mysql.slow_log; SET @old_log_output= @@global.log_output; SET @old_slow_query_log= @@global.slow_query_log; SET @old_slow_query_log_file= @@global.slow_query_log_file; SET @old_long_query_time= @@global.long_query_time; SET GLOBAL slow_query_log_file= '.../log/rewrite_slow.log'; SET GLOBAL log_output = 'FILE,TABLE'; SET GLOBAL slow_query_log= 'ON'; SET SESSION long_query_time= 0; GRANT ALL on *.* TO test_user1 IDENTIFIED BY 'azundris1'; Warnings: Warning 1287 Using GRANT for creating new user is deprecated and will be removed in future release. Create new user with CREATE USER statement. CREATE USER test_user2 IDENTIFIED BY 'azundris2'; CHANGE MASTER TO MASTER_PASSWORD='azundris3'; CHANGE MASTER TO MASTER_CONNECT_RETRY = 1, MASTER_HEARTBEAT_PERIOD = 1.01, MASTER_LOG_FILE = 'master_log_name', MASTER_LOG_POS = 0, MASTER_SSL = 0, MASTER_SSL_CA = 'ca_file_name', MASTER_SSL_CAPATH = 'ca_directory_name', MASTER_SSL_CERT = 'cert_file_name', MASTER_SSL_KEY = 'key_file_name', MASTER_SSL_CIPHER = 'cipher_list', MASTER_SSL_VERIFY_SERVER_CERT = 0, IGNORE_SERVER_IDS = (99,100); CHANGE MASTER TO MASTER_CONNECT_RETRY = 1, MASTER_HEARTBEAT_PERIOD = 1.01, MASTER_LOG_FILE = '', MASTER_LOG_POS = 0, MASTER_SSL = 0, MASTER_SSL_CA = '', MASTER_SSL_CAPATH = '', MASTER_SSL_CERT = '', MASTER_SSL_KEY = '', MASTER_SSL_CIPHER = '', MASTER_SSL_VERIFY_SERVER_CERT = 0, IGNORE_SERVER_IDS = ( ); CREATE USER 'test_user4'@'localhost'; SET PASSWORD FOR 'test_user4'@'localhost' = 'azundris4'; SET SESSION long_query_time= @old_long_query_time; SET GLOBAL slow_query_log='OFF'; DROP USER 'test_user4'@'localhost'; DROP USER test_user2; DROP USER test_user1; CREATE TABLE test_log (sql_text TEXT); LOAD DATA LOCAL INFILE '.../log/rewrite_slow.log' INTO TABLE test_log FIELDS TERMINATED BY '\n' LINES TERMINATED BY '\n'; This line should be followed by two SELECTs with empty result sets SELECT sql_text FROM test_log WHERE sql_text LIKE CONCAT('%azun','dris%'); sql_text SELECT sql_text FROM mysql.slow_log WHERE sql_text LIKE CONCAT('%azun','dris%'); sql_text ------ from file ------ SELECT sql_text FROM test_log WHERE sql_text like '%AS %'; sql_text GRANT ALL PRIVILEGES ON *.* TO 'test_user1'@'%' IDENTIFIED WITH 'mysql_native_password' AS '*8D15E74BC850D11573A52BE84B504DD0BA40C1E3'; CREATE USER 'test_user2'@'%' IDENTIFIED WITH 'mysql_native_password' AS '*A142844DBF024D282D88FE19CB4D3FA13B1E96E0'; SELECT sql_text FROM test_log WHERE sql_text like 'CHANGE MASTER TO MASTER_PASSWORD %'; sql_text CHANGE MASTER TO MASTER_PASSWORD = <secret>; SELECT sql_text FROM test_log WHERE sql_text like '%SET PASSWORD %'; sql_text SET PASSWORD FOR `test_user4`@`localhost`=<secret>; ------ from table ------ SELECT sql_text FROM mysql.slow_log WHERE sql_text like '%AS %'; sql_text GRANT ALL PRIVILEGES ON *.* TO 'test_user1'@'%' IDENTIFIED WITH 'mysql_native_password' AS '*8D15E74BC850D11573A52BE84B504DD0BA40C1E3' CREATE USER 'test_user2'@'%' IDENTIFIED WITH 'mysql_native_password' AS '*A142844DBF024D282D88FE19CB4D3FA13B1E96E0' SELECT sql_text FROM test_log WHERE sql_text like 'CHANGE MASTER TO MASTER_PASSWORD %'; sql_text CHANGE MASTER TO MASTER_PASSWORD = <secret>; SELECT sql_text FROM test_log WHERE sql_text like '%SET PASSWORD %'; sql_text SET PASSWORD FOR `test_user4`@`localhost`=<secret>; ------ done ------ DROP TABLE test_log; End of 5.6 tests! # # Bug#16467055: GRANT STATEMENTS LOGGED TWICE IN SLOW QUERY LOG # SET SESSION long_query_time= 0; SET GLOBAL slow_query_log = 1; SET GLOBAL log_output = 'TABLE'; TRUNCATE mysql.slow_log; DROP USER u16467055; End of 5.7 tests! SET SESSION long_query_time= @old_long_query_time; SET GLOBAL slow_query_log_file=@old_slow_query_log_file; SET GLOBAL slow_query_log= @old_slow_query_log; SET GLOBAL log_output= @old_log_output;