| 1 |
# |
| 2 |
# TC1. Upgrade from FILE to TABLE with PRIVILEGE_CHECKS_USER configured |
| 3 |
# --------------------------------------------------------------------- |
| 4 |
# |
| 5 |
include/master-slave.inc |
| 6 |
Warnings: |
| 7 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 8 |
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. |
| 9 |
[connection master] |
| 10 |
[connection slave] |
| 11 |
GRANT CREATE,INSERT,DROP ON *.* TO 'u1'@'localhost'; |
| 12 |
include/start_slave.inc |
| 13 |
[connection master] |
| 14 |
CREATE TABLE t (c INT); |
| 15 |
INSERT INTO t VALUES (1), (2); |
| 16 |
include/sync_slave_sql_with_master.inc |
| 17 |
include/stop_slave.inc |
| 18 |
ALTER TABLE mysql.slave_relay_log_info DROP COLUMN Privilege_checks_username; |
| 19 |
ALTER TABLE mysql.slave_relay_log_info DROP COLUMN Privilege_checks_hostname; |
| 20 |
include/assert.inc [Configured PRIVILEGE_CHECKS_USER appears in PFS table] |
| 21 |
include/assert.inc [Table mysql.slave_relay_log_info has no information since --relay-log-info-repository=FILE] |
| 22 |
include/assert.inc [Table mysql.slave_relay_log_info has no columns regarding PRIVILEGE_CHECKS_USER] |
| 23 |
include/rpl_stop_server.inc [server_number=2] |
| 24 |
include/rpl_start_server.inc [server_number=2 parameters: --relay-log-info-repository=TABLE --upgrade=FORCE] |
| 25 |
include/start_slave.inc |
| 26 |
[connection slave] |
| 27 |
include/assert.inc [Table mysql.slave_relay_log_info has columns for PRIVILEGE_CHECKS_USER] |
| 28 |
include/assert.inc [Table mysql.slave_relay_log_info has info for channel and PRIVILEGE_CHECKS_USER since --relay-log-info-repository=TABLE] |
| 29 |
include/stop_slave.inc |
| 30 |
CHANGE REPLICATION SOURCE TO PRIVILEGE_CHECKS_USER = NULL; |
| 31 |
include/start_slave.inc |
| 32 |
include/assert.inc [Table mysql.slave_relay_log_info has info for channel and PRIVILEGE_CHECKS_USER = NULL] |
| 33 |
[connection master] |
| 34 |
DROP TABLE t; |
| 35 |
include/sync_slave_sql_with_master.inc |
| 36 |
include/stop_slave.inc |
| 37 |
SET GLOBAL relay_log_info_repository="FILE"; |
| 38 |
Warnings: |
| 39 |
Warning 1287 '@@relay_log_info_repository' is deprecated and will be removed in a future release. |
| 40 |
include/start_slave.inc |
| 41 |
include/rpl_end.inc |