mirror of
https://github.com/MariaDB/server.git
synced 2025-07-16 08:18:12 +02:00
41 lines
1.1 KiB
Text
41 lines
1.1 KiB
Text
include/master-slave.inc
|
|
[connection master]
|
|
connection master;
|
|
CREATE USER dummy@localhost;
|
|
CREATE USER dummy1@localhost, dummy2@localhost;
|
|
SELECT user, host FROM mysql.user WHERE user like 'dummy%';
|
|
user host
|
|
dummy localhost
|
|
dummy1 localhost
|
|
dummy2 localhost
|
|
SELECT COUNT(*) FROM mysql.user WHERE user like 'dummy%';
|
|
COUNT(*)
|
|
3
|
|
connection slave;
|
|
**** On Slave ****
|
|
SELECT user,host FROM mysql.user WHERE user like 'dummy%';
|
|
user host
|
|
dummy localhost
|
|
dummy1 localhost
|
|
dummy2 localhost
|
|
SELECT COUNT(*) FROM mysql.user WHERE user like 'dummy%';
|
|
COUNT(*)
|
|
3
|
|
connection master;
|
|
DROP USER nonexisting@localhost;
|
|
ERROR HY000: Operation DROP USER failed for 'nonexisting'@'localhost'
|
|
DROP USER nonexisting@localhost, dummy@localhost;
|
|
ERROR HY000: Operation DROP USER failed for 'nonexisting'@'localhost'
|
|
DROP USER dummy1@localhost, dummy2@localhost;
|
|
SELECT user, host FROM mysql.user WHERE user like 'dummy%';
|
|
user host
|
|
SELECT COUNT(*) FROM mysql.user WHERE user like 'dummy%';
|
|
COUNT(*)
|
|
0
|
|
connection slave;
|
|
SELECT user,host FROM mysql.user WHERE user like 'dummy%';
|
|
user host
|
|
SELECT COUNT(*) FROM mysql.user WHERE user like 'dummy%';
|
|
COUNT(*)
|
|
0
|
|
include/rpl_end.inc
|