mysql-router creates users with deprecated mysql_native_password plugin
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL Router Charm |
Triaged
|
Low
|
Unassigned |
Bug Description
The mysql-router charm creates users in mysql using the mysql_native_
+------
| host | user | plugin |
+------
| % | mysql_innodb_
| % | mysql_innodb_
| % | mysql_innodb_
| % | mysql_router1_
| % | mysql_router2_
| % | mysql_router3_
| % | mysql_router4_
| % | mysql_router5_
| % | mysql_router6_
| % | mysql_router7_
| % | mysql_router8_
| % | mysql_router9_
| 10.5.0.112 | clusteruser | caching_
| 10.5.0.129 | clusteruser | caching_
| 10.5.0.15 | cinder | caching_
| 10.5.0.15 | mysqlrouteruser | caching_
| 10.5.0.155 | horizon | caching_
| 10.5.0.155 | mysqlrouteruser | caching_
| 10.5.0.247 | clusteruser | caching_
| 10.5.0.40 | keystone | caching_
| 10.5.0.40 | mysqlrouteruser | caching_
| 10.5.1.13 | mysqlrouteruser | caching_
| 10.5.1.13 | vault | caching_
| 10.5.1.133 | heat | caching_
| 10.5.1.133 | mysqlrouteruser | caching_
| 10.5.1.66 | glance | caching_
| 10.5.1.66 | mysqlrouteruser | caching_
| 10.5.2.151 | mysqlrouteruser | caching_
| 10.5.2.151 | nova | caching_
| 10.5.2.172 | mysqlrouteruser | caching_
| 10.5.2.172 | neutron | caching_
| 10.5.3.255 | mysqlrouteruser | caching_
| 10.5.3.255 | nova | caching_
| 10.5.3.255 | placement | caching_
| localhost | clusteruser | caching_
| localhost | debian-sys-maint | caching_
| localhost | mysql.infoschema | caching_
| localhost | mysql.session | caching_
| localhost | mysql.sys | caching_
| localhost | root | caching_
+------
This plugin is deprecated in favor of caching_
2023-10-
Within minutes this creates tens of thousands of log lines and leads to an enormous log file if not pruned or configured to ignore these warnings.
This charm should force the routers to register with caching_
My test setup:
Ubuntu Focal 20.04
mysql-innodb-
*-mysql-router charms: 8.0.34 (8.0/stable, rev. 111)
Upstream doc on the subject: https:/ /dev.mysql. com/doc/ refman/ 8.0/en/ upgrading- from-previous- series. html#upgrade- caching- sha2-password