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

2

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

Objective:  We are building a new c # mvc system that should use the same database, but this time we are using the MySql.Data driver version 6.10.4. Problem: When we try to connect to the same database , we get the error Message: Authentication with old password no longer supported, use 4.1 style passwords. Home I checked some posts where the solution pointed out 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 this change, the old system will stop working?
Has anyone here from the forum ever been through this? Thank you.

    
asked by anonymous 14.11.2017 / 14:45

1 answer

0

No, the old system does not stop working because all dependencies at startup 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 do not believe it.

In any case, it is only necessary to test if you prefer to create an auxiliary database and test access.

    
16.11.2017 / 02:37