20
20
CREATE DATABASE mysqltest1;
23
# Section 1 test anonymous user
24
24
CREATE USER tester IDENTIFIED BY 'test';
25
25
GRANT ALL ON mysqltest1.* TO 'tester'@'%' IDENTIFIED BY 'test';
26
26
GRANT ALL ON mysqltest1.* TO ''@'localhost%';
31
31
CREATE TABLE mysqltest1.t1 (a INT, users VARCHAR(255), PRIMARY KEY(a));
32
32
INSERT INTO mysqltest1.t1 VALUES(1,USER());
33
33
INSERT INTO mysqltest1.t1 VALUES(2,CURRENT_USER());
35
create procedure mysqltest1.p1()
35
CREATE PROCEDURE mysqltest1.p1()
37
37
INSERT INTO mysqltest1.t1 VALUES(3,USER());
38
38
INSERT INTO mysqltest1.t1 VALUES(4,CURRENT_USER());
42
42
CALL mysqltest1.p1();
58
59
--source include/sync_slave_sql_with_master.inc
61
# Begin clean up test section
64
DROP DATABASE IF EXISTS mysqltest1;
65
CREATE DATABASE mysqltest1;
68
# Section 2 test anonymous host
69
CREATE USER 'tester1'@'' IDENTIFIED BY 'test';
70
GRANT ALL ON mysqltest1.* TO 'tester1'@'' IDENTIFIED BY 'test';
72
connect (m_2,localhost,tester1,test,mysqltest1);
75
CREATE TABLE mysqltest1.t1 (a INT, users VARCHAR(255), PRIMARY KEY(a));
76
INSERT INTO mysqltest1.t1 VALUES(1,USER());
77
INSERT INTO mysqltest1.t1 VALUES(2,CURRENT_USER());
79
CREATE PROCEDURE mysqltest1.p1()
81
INSERT INTO mysqltest1.t1 VALUES(3,USER());
82
INSERT INTO mysqltest1.t1 VALUES(4,CURRENT_USER());
88
SELECT * FROM mysqltest1.t1 ORDER BY a;
89
--source include/sync_slave_sql_with_master.inc
90
SELECT * FROM mysqltest1.t1 ORDER BY a;
96
DROP DATABASE mysqltest1;
97
REVOKE ALL ON mysqltest1.* FROM 'tester1'@'';
100
--source include/sync_slave_sql_with_master.inc
60
102
# End of 5.0 test case
61
103
--source include/rpl_end.inc