Forum Discussion
Solved
Unable to connect MySQL Authentication with old password no longer supported
Hi, I am new to Power BI and i need to connect to an old MySQL database to produce reports. Here is the error Unable to connect We encountered an error while trying to connect. Details:...
Hi pbadion,
I think the issue is more related to mysql, you can refer to below link to modify your password:
Authentication with old password no longer supported, use 4.1 style passwords.
Regards,
Xiaoxin Sheng
Hi pbadion,
I think the issue is more related to mysql, you can refer to below link to modify your password:
Authentication with old password no longer supported, use 4.1 style passwords.
Regards,
Xiaoxin Sheng
I got it working by setting the global variable of MySQL secure_auth to ON.
I ran this command using the root login in MySQL.
set global secure_auth = ON;
Thanks for the help.