Forum Stats

  • 3,733,367 Users
  • 2,246,748 Discussions
  • 7,856,668 Comments

Discussions

Is it possible to manually set or update "mysql_router_*" login in mysql router configuration file

MySQL_Checkpoint
MySQL_Checkpoint Member Posts: 7
edited March 2019 in MySQL Community Space

When configuring / bootstrapping the mysql router the mysql_router login is automatically created (The generated username follows this pattern: mysql_router_[0-9]{1,6}_[0-9a-z]{12}, where [0-9]{1,6} is the numeric router id and [0-9a-z]{12} is 12 random lowercase alphanumeric characters.). 

Is it possible set or update this to custom login, so it can be easily identified from which server the call is coming to the server? And this is will also help in faster troubleshooting process?

Below is the section from MySQL router configuration file,

[metadata_cache:mycluster]

router_id=5

bootstrap_server_addresses=mysql://localhost:3310,mysql://localhost:3320,mysql://localhost:3330

user=mysql_router5_6owf3spq1c6n

metadata_cluster=mycluster

ttl=5

Best Answer

Answers

Sign In or Register to comment.