search

docker-library / mysql

Docker Official Image packaging for MySQL Community Server
https://dev.mysql.com/
GNU General Public License v2.0
2.42k stars 2.18k forks source link

internal users authentication plugin method #1063

Closed qeepcologne closed 3 weeks ago

qeepcologne commented 1 month ago

i upgraded some mysql installations to 8.4.0 (non docker) and always the plugin of the internal users (mysql.*) are upgraded to caching_sha2_password. strangely this is not done for our docker installation:

mysql> select user,host,plugin from mysql.user;

upgraded docker image: | healthchecker | localhost | mysql_native_password | | mysql.infoschema | localhost | caching_sha2_password | | mysql.session | localhost | mysql_native_password | | mysql.sys | localhost | caching_sha2_password | | root | localhost | caching_sha2_password |

fresh docker image: | root | % | caching_sha2_password | | mysql.infoschema | localhost | caching_sha2_password | | mysql.session | localhost | caching_sha2_password | | mysql.sys | localhost | caching_sha2_password | | root | localhost | caching_sha2_password |

(the mysql.session user is still mysql_native_password) i know how to change authentication method for our and the root user, but i no idea for the mysql.* users password. https://dba.stackexchange.com/questions/330384/how-do-i-change-the-authentication-plugin-for-users-mysql-sys-mysql-session-et

tianon commented 1 month ago

This seems like really strange behavior -- however, I think it's more of a question about upstream behavior than it is anything particular to this image? You might have better luck in a MySQL support forum. :bow:

qeepcologne commented 3 weeks ago

you're right, i first had 3 non dockerized installations without this issue, it first happed on docker container, but now i have another non-dockerized setup with that issue https://bugs.mysql.com/bug.php?id=115225