Add instructions/do command to switch mysql user auth to caching_sha2_password #1095
Assignees
Comments
Danyal-Faheem
added a commit
to edly-io/tutor
that referenced
this issue
Jul 15, 2024
closes overhangio#1095 MySQL users created in MySQL 5.7 used the mysql-native-password authentication plugin This plugin has been deprecated in MySQL 8.4 and onwards We therefore update the users to the caching_sha2_password plugin
Danyal-Faheem
added a commit
to edly-io/tutor
that referenced
this issue
Jul 18, 2024
closes overhangio#1095 - mysql_native_password is disabled in MySQL v8.4 - Users created in MySQL v5.7 use the mysql_native_password authentication plugin - This plugin is not updated when MySQL is upgraded - We therefore manually upgrade these users when upgrading to v8.4 - Upgrading directly from MySQL v5.7 -> v8.4 is also not allowed - We therefore first jump to v8.1, update the authentication plugin, then go to v8.4"
Danyal-Faheem
added a commit
to edly-io/tutor
that referenced
this issue
Jul 18, 2024
closes overhangio#1095 - mysql_native_password is disabled in MySQL v8.4 - Users created in MySQL v5.7 use the mysql_native_password authentication plugin - This plugin is not updated when MySQL is upgraded - We therefore manually upgrade these users when upgrading to v8.4 - Upgrading directly from MySQL v5.7 -> v8.4 is also not allowed - We therefore first jump to v8.1, update the authentication plugin, then go to v8.4
Danyal-Faheem
added a commit
to edly-io/tutor
that referenced
this issue
Aug 21, 2024
…rs to caching_sha2_password closes overhangio#1095
Danyal-Faheem
added a commit
to edly-io/tutor
that referenced
this issue
Aug 21, 2024
…rs to caching_sha2_password closes overhangio#1095
Danyal-Faheem
added a commit
to edly-io/tutor
that referenced
this issue
Aug 21, 2024
…rs to caching_sha2_password closes overhangio#1095
Danyal-Faheem
added a commit
to edly-io/tutor
that referenced
this issue
Nov 24, 2024
…rs to caching_sha2_password closes overhangio#1095
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
MySQL was upgraded to v8.4.0 in redwood (#1071). The upgrade broke Tutor for users upgrading from Tutor 15 or earlier. MySQL 8.4 removes mysql-native-password (https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-0.html) because the option has been deprecated. If any user plugin is authenticating via native-password, MySQL server needs to provide --mysql-native-password=ON as an argument.
A quick fix was added at #1090. However, when MySQL is upgraded from 8.4, the flows will break because native-password will no longer exist. Therefore, we need to either document how to move a user from native-password to caching_sha2_password or provide a capability in tutor to do this.
The text was updated successfully, but these errors were encountered: