Hi,
I am re-writing a live/old PHP website locally, so I'm connecting to an externally hosted MySQL database via my local machine.
I've installed the MySql.Data.dll v6.9.6.0 via NuGet.
However, when I try to connect to the database I get the following error:
"Authentication with old password no longer supported, use 4.1 style passwords"
I get why this is, and I know that I can fix it by running the command:
SET SESSION old_passwords=0;
SET PASSWORD FOR my_user=PASSWORD('my_password');
The problem is, I can't change anything on the live database as it'll affect the live website.
Does anyone know of a work-around until my local version is complete (an extra parm in the connection string maybe)?
Thanks
Go to the complete details ...