Re: Connexion to database interrupted at router bootstrap

[Fred Milonni]

Same error with the rpm mysql-router-community-8.0.33-1.el8.x86_64

I tried to build the mysqlrouter with mysql 8.0.33 sources : cmake etc ... + make mysqlrouter

It works!

So there is a bug in the rpm.

# ./runtime_output_directory/mysqlrouter --bootstrap myuser@dpb01:3306 --conf-bind-address 127.0.0.1 --account myuser --user mysqlrouter --account-create never --force
Please enter MySQL password for routeur_monis_user:
# Bootstrapping system MySQL Router instance...

Please enter MySQL password for routeur_monis_user:
- Verifying account (using it to run SQL queries that would be run by Router)
- Storing account in keyring
- Adjusting permissions of generated files
- Creating configuration /logs/fred/mysql-8.0.33/build/mysqlrouter.conf

# MySQL Router configured for the InnoDB ReplicaSet 'dbreplica1'

After this MySQL Router has been started with the generated configuration

$ /etc/init.d/mysqlrouter restart
or
$ systemctl start mysqlrouter
or
$ ./runtime_output_directory/mysqlrouter -c /logs/fred/mysql-8.0.33/build/mysqlrouter.conf

InnoDB ReplicaSet 'dbreplica1' can be reached by connecting to:

## MySQL Classic protocol

- Read/Write Connections: localhost:6446
- Read/Only Connections: localhost:6447

## MySQL X protocol

- Read/Write Connections: localhost:6448
- Read/Only Connections: localhost:6449

#