Error c# and Mysql: Authentication with old password no longer supported, use 4.1 style passwords

Question

Context: We have an application built a few years ago in ASP 6 that accesses a Mysql database, there on Localweb. To make the connection, the application uses the Mysql ODBC 5.1 driver. and works perfectly.

Goal: We are building a new c# mvc system that should use the same database, but this time we are using the Mysql driver.Data version 6.10.4.

Problem: When we try to connect to the same bank, we get the error Message: Authentication with old password no longer supported, use 4.1 style passwords.

I checked some posts in which the solution aimed was to run this script:

SET SESSION old_passwords=0;
SET PASSWORD FOR my_user=PASSWORD('my_password');

The question we have here is: If we make that change, the old system will stop working?
Has anyone here in the forum been through it? Thanks already.

Answer 1

No, the old system does not stop working because all dependencies in the beginning are Backwards compatible. But nothing better than creating a project branch and testing. If something goes wrong, you always have the original project. Eventually you may have to go to the old project and change the password to the new password but I don’t believe.

Anyway it remains only to test, if you prefer to create an auxiliary database and test the access.