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.