| 1 |
include/group_replication.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 server1] |
| 6 |
SET GLOBAL group_replication_message_cache_size= -200; |
| 7 |
ERROR 42000: The value -200 is not within the range of accepted values for the option group_replication_message_cache_size. The value must be between 134217728 and 18446744073709551615 inclusive. |
| 8 |
SET GLOBAL group_replication_message_cache_size= 5.5; |
| 9 |
ERROR 42000: Incorrect argument type to variable 'group_replication_message_cache_size' |
| 10 |
SET GLOBAL group_replication_message_cache_size= 3221225472; |
| 11 |
[connection server1] |
| 12 |
include/start_and_bootstrap_group_replication.inc |
| 13 |
include/assert.inc [The value of group_replication_message_cache_size should be 3221225472] |
| 14 |
SET GLOBAL group_replication_message_cache_size= -100000000000000000; |
| 15 |
ERROR 42000: The value -100000000000000000 is not within the range of accepted values for the option group_replication_message_cache_size. The value must be between 134217728 and 18446744073709551615 inclusive. |
| 16 |
SET GLOBAL group_replication_message_cache_size= 0.5; |
| 17 |
ERROR 42000: Incorrect argument type to variable 'group_replication_message_cache_size' |
| 18 |
SET GLOBAL group_replication_message_cache_size = 134217727; |
| 19 |
ERROR 42000: The value 134217727 is not within the range of accepted values for the option group_replication_message_cache_size. The value must be between 134217728 and 18446744073709551615 inclusive. |
| 20 |
SET GLOBAL group_replication_message_cache_size= 9223372036854775808; |
| 21 |
include/assert.inc [The value of group_replication_message_cache_size should be 9223372036854775808] |
| 22 |
SET GLOBAL group_replication_message_cache_size= 18446744073709551615; |
| 23 |
include/assert.inc [The value of group_replication_message_cache_size should be 18446744073709551615] |
| 24 |
SET GLOBAL group_replication_message_cache_size= 18446744073709551616; |
| 25 |
ERROR 42000: Incorrect argument type to variable 'group_replication_message_cache_size' |
| 26 |
SET GLOBAL group_replication_message_cache_size= 2147483648; |
| 27 |
include/stop_group_replication.inc |
| 28 |
include/assert.inc [The value of group_replication_message_cache_size should be 2147483648] |
| 29 |
CREATE user 'group_rpl_user'@localhost; |
| 30 |
grant ALL on *.* to 'group_rpl_user'@localhost; |
| 31 |
revoke SUPER, SYSTEM_VARIABLES_ADMIN on *.* from 'group_rpl_user'@localhost; |
| 32 |
[connection group_rpl_user_con] |
| 33 |
SET GLOBAL group_replication_message_cache_size= default; |
| 34 |
ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation |
| 35 |
[connection server1] |
| 36 |
grant SYSTEM_VARIABLES_ADMIN on *.* to 'group_rpl_user'@localhost; |
| 37 |
[connection group_rpl_user_con] |
| 38 |
SET GLOBAL group_replication_message_cache_size= default; |
| 39 |
[connection server1] |
| 40 |
REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'group_rpl_user'@localhost; |
| 41 |
DROP USER 'group_rpl_user'@localhost; |
| 42 |
flush privileges; |
| 43 |
include/group_replication_end.inc |