1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
|
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 connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
[connection master]
CALL mtr.add_suppression(".*Access denied. you need .at least one of. the SYSTEM_USER.*");
CALL mtr.add_suppression(".*The replica coordinator and worker threads are stopped.*");
SET sql_log_bin = 0;
CREATE USER 'u2'@'localhost';
GRANT CREATE ROUTINE ON *.* TO 'u2'@'localhost';
SET sql_log_bin = 1;
[connection slave]
CREATE USER 'u2'@'localhost';
CREATE PROCEDURE simpleproc1 (OUT param1 INT)
BEGIN
SELECT COUNT(*) INTO param1 FROM t;
END@
[connection master]
include/sync_slave_sql_with_master.inc
include/assert.inc [Procedure simpleproc1 does exist]
GRANT SYSTEM_USER ON *.* TO 'u2'@'localhost';
CREATE PROCEDURE simpleproc2 (OUT param1 INT)
BEGIN
SELECT COUNT(*) INTO param1 FROM t;
END@
[connection slave]
include/wait_for_slave_sql_error.inc [errno=1227]
GRANT SYSTEM_USER ON *.* TO 'u1'@'localhost';
include/start_slave.inc
[connection master]
DROP PROCEDURE simpleproc1;
DROP PROCEDURE simpleproc2;
DROP USER 'u2'@'localhost';
include/rpl_end.inc
|
