Debian Codegraph @

mysql-test/suite/rpl/r/rpl_create_database.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 DROP DATABASE IF EXISTS mysqltest_prometheus;
7 DROP DATABASE IF EXISTS mysqltest_sisyfos;
8 DROP DATABASE IF EXISTS mysqltest_bob;
9 include/sync_slave_sql_with_master.inc
10 DROP DATABASE IF EXISTS mysqltest_bob;
11 CREATE DATABASE mysqltest_prometheus;
12 CREATE DATABASE mysqltest_sisyfos;
13 CREATE DATABASE mysqltest_bob;
14 USE mysqltest_sisyfos;
15 CREATE TABLE t1 (b int);
16 INSERT INTO t1 VALUES(1);
17 USE mysqltest_bob;
18 CREATE TABLE t2 (b int);
19 INSERT INTO t2 VALUES(2);
20 ALTER DATABASE mysqltest_sisyfos CHARACTER SET latin1;
21 USE mysqltest_sisyfos;
22 ALTER DATABASE mysqltest_bob CHARACTER SET latin1;
23 SHOW DATABASES LIKE 'mysql%';
24 Database (mysql%)
25 mysql
26 mysqltest_bob
27 mysqltest_prometheus
28 mysqltest_sisyfos
29 include/sync_slave_sql_with_master.inc
30 SHOW DATABASES LIKE 'mysql%';
31 Database (mysql%)
32 mysql
33 mysqltest_prometheus
34 mysqltest_sisyfos
35 DROP DATABASE IF EXISTS mysqltest_sisyfos;
36 USE mysqltest_prometheus;
37 CREATE TABLE t1 (a INT);
38 INSERT INTO t1 VALUES (1);
39 CREATE DATABASE mysqltest_sisyfos;
40 USE mysqltest_sisyfos;
41 CREATE TABLE t2 (a INT);
42 SHOW DATABASES LIKE 'mysql%';
43 Database (mysql%)
44 mysql
45 mysqltest_bob
46 mysqltest_prometheus
47 mysqltest_sisyfos
48 include/sync_slave_sql_with_master.inc
49 SHOW DATABASES LIKE 'mysql%';
50 Database (mysql%)
51 mysql
52 mysqltest_prometheus
53 mysqltest_sisyfos
54 USE mysqltest_prometheus;
55 SHOW TABLES;
56 Tables_in_mysqltest_prometheus
57 t1
58 USE mysqltest_sisyfos;
59 SHOW TABLES;
60 Tables_in_mysqltest_sisyfos
61 t2
62 DROP DATABASE IF EXISTS mysqltest_prometheus;
63 DROP DATABASE IF EXISTS mysqltest_sisyfos;
64 DROP DATABASE IF EXISTS mysqltest_bob;
65 include/sync_slave_sql_with_master.inc
66 include/rpl_end.inc