Description:
The official manual misses the step "User Credentials" from old manual (http://mysqlhighavailability.com/gr/doc/getting_started.html) when creating the first node that is used to bootstrap the cluster.
This link http://dev.mysql.com/doc/refman/5.7/en/group-replication-launching.html is missing the section:
SET SQL_LOG_BIN=0;
CREATE USER rpl_user@'%';
GRANT REPLICATION SLAVE ON *.* TO rpl_user@'%' IDENTIFIED BY 'rpl_pass';
FLUSH PRIVILEGES;
SET SQL_LOG_BIN=1;
CHANGE MASTER TO MASTER_USER='rpl_user', MASTER_PASSWORD='rpl_pass' FOR CHANNEL 'group_replication_recovery';
This was included in old manual http://mysqlhighavailability.com/gr/doc/getting_started.html under section "User Credentials"
If you do not execute these commands the first node where you bootstraped your cluster will not have credentials/users to recover.
How to repeat:
N/A
Suggested fix:
On page http://dev.mysql.com/doc/refman/5.7/en/group-replication-launching.html
insert the same commands/text as is written at page "Adding Instances to the Group" before installing the plugin, see missing commands/text below.
Commands/text that is missing:
mysql> SET SQL_LOG_BIN=0;
Query OK, 0 rows affected (0,00 sec)
mysql> CREATE USER rpl_user@'%';
Query OK, 0 rows affected (0,00 sec)
mysql> GRANT REPLICATION SLAVE ON *.* TO rpl_user@'%' IDENTIFIED BY 'rpl_pass';
Query OK, 0 rows affected, 1 warning (0,00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0,00 sec)
mysql> SET SQL_LOG_BIN=1;
Query OK, 0 rows affected (0,00 sec)
mysql> CHANGE MASTER TO MASTER_USER='rpl_user', MASTER_PASSWORD='rpl_pass' \\
FOR CHANNEL 'group_replication_recovery';
Query OK, 0 rows affected, 2 warnings (0,01 sec)
