Bug #115225 | mysql_native_password: internal users not always migrated on upgrade | ||
---|---|---|---|
Submitted: | 5 Jun 9:52 | Modified: | 26 Sep 9:05 |
Reporter: | Bernd Wahlen | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: Installing | Severity: | S3 (Non-critical) |
Version: | 8.4 9.0 | OS: | Any |
Assigned to: | CPU Architecture: | Any | |
Tags: | caching_sha2_password, mysql_native_password, mysql.session, mysql.sys, plugin dir |
[5 Jun 9:52]
Bernd Wahlen
[5 Jun 10:02]
MySQL Verification Team
Hi Mr. Wahlen, Thank you for your bug report. We have created users on 8.3.0 with native password and upgraded to 8.4.0 and noticed the same behaviour. This is now a verified bug for 8.4 only. Thank you for your contribution.
[1 Jul 14:51]
Bernd Wahlen
any workaround to recreate these users with the same password? 8.4 causes warning: 024-07-01T07:15:16.177194Z 0 [Warning] [MY-010312] [Server] The plugin 'mysql_native_password' used to authenticate user 'mysql.session'@'localhost' is not loaded. Nobody can currently login using this account. 2024-07-01T07:15:16.177241Z 0 [Warning] [MY-010312] [Server] The plugin 'mysql_native_password' used to authenticate user 'mysql.sys'@'localhost' is not loaded. Nobody can currently login using this account. and with 9.0 the plugin seems to be removed and cannot be activated via settings.
[1 Jul 14:58]
MySQL Verification Team
Thank you, Mr. Wahlen ..........
[26 Sep 9:05]
Bernd Wahlen
still not solved in 9.0.1