Fix regression on 'COM_CHANGE_USER' for 'mysql_native_password' - Closes #4589

sysown / proxysql

High-performance MySQL proxy with a GPL license.

http://www.proxysql.com

GNU General Public License v3.0

6.05k stars 983 forks source link

Fix regression on 'COM_CHANGE_USER' for 'mysql_native_password' - Closes #4589 #4623

Closed JavierJF closed 3 months ago

JavierJF commented 3 months ago

This PR fixes a regression introduced in v2.6.0 that breaks the handling of COM_CHANGE_USER for mysql_native_password when hashed passwords are used. This is, when passwords for users are set hashed on mysql_users table, for example, making use of MYSQL_NATIVE_PASSWORD() for hashed password generation.