Debian Codegraph @

mysql-test/suite/rpl/r/rpl_ignore_revoke.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 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.
5 [connection master]
6 create user 'user_foo'@'%' identified by 'user_foopass';
7 grant select on *.* to 'user_foo'@'%';
8 revoke select on *.* from 'user_foo'@'%';
9 select select_priv from mysql.user where user='user_foo' /* master:must be N */;
10 select_priv
11 N
12 include/sync_slave_sql_with_master.inc
13 create user 'user_foo'@'%' identified by 'user_foopass';
14 grant select on *.* to 'user_foo'@'%';
15 revoke select on *.* from 'user_foo'@'%';
16 select select_priv from mysql.user where user='user_foo' /* slave:must be N */;
17 select_priv
18 N
19 grant select on *.* to 'user_foo'@'%';
20 select select_priv from mysql.user where user='user_foo' /* slave:must be Y */;
21 select_priv
22 Y
23 revoke select on *.* from 'user_foo';
24 select select_priv from mysql.user where user='user_foo' /* master:must be N */;
25 select_priv
26 N
27 include/sync_slave_sql_with_master.inc
28 select select_priv from mysql.user where user='user_foo' /* slave:must get Y */;
29 select_priv
30 Y
31 revoke select on *.* FROM 'user_foo';
32 delete from mysql.user where user="user_foo";
33 include/sync_slave_sql_with_master.inc
34 delete from mysql.user where user="user_foo";
35 include/rpl_end.inc