Server IP : 172.67.216.182 / Your IP : 172.68.164.10 Web Server : Apache System : Linux krdc-ubuntu-s-2vcpu-4gb-amd-blr1-01.localdomain 5.15.0-142-generic #152-Ubuntu SMP Mon May 19 10:54:31 UTC 2025 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 : ON Directory : /www/server/mysql/src/mysql-test/suite/rpl/r/ |
Upload File : |
include/master-slave.inc Warnings: Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. [connection master] [connection slave] ####################################################################### # SHOW SLAVE STATUS NONBLOCKING is not allowed within a function. CREATE FUNCTION func1(arg TEXT) RETURNS TEXT BEGIN SHOW SLAVE STATUS NONBLOCKING; RETURN arg; END| ERROR 0A000: Not allowed to return a result set from a function ####################################################################### # Testing if a user without REPLICATION CLIENT and SUPER privilege can # execute SHOW SLAVE STATUS NONBLOCKING. CREATE USER mysqltest_1@localhost; SHOW GRANTS FOR mysqltest_1@localhost; Grants for mysqltest_1@localhost GRANT USAGE ON *.* TO 'mysqltest_1'@'localhost' SHOW SLAVE STATUS NONBLOCKING; ERROR 42000: Access denied; you need (at least one of) the SUPER, REPLICATION CLIENT privilege(s) for this operation DROP USER 'mysqltest_1'@'localhost'; ####################################################################### # Testing if a user with REPLICATION CLIENT privilege can execute # SHOW SLAVE STATUS NONBLOCKING. CREATE USER mysqltest_2@localhost; GRANT REPLICATION CLIENT ON *.* TO 'mysqltest_2'@'localhost'; SHOW GRANTS FOR mysqltest_2@localhost; Grants for mysqltest_2@localhost GRANT REPLICATION CLIENT ON *.* TO 'mysqltest_2'@'localhost' SHOW SLAVE STATUS NONBLOCKING; DROP USER 'mysqltest_2'@'localhost'; ####################################################################### # Stress test that executes nearly in parallel SSS NONBLOCKING and STOP # SLAVE. include/rpl_end.inc