Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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: "MySQL: Authentication with old password no longer supported; use 4.1 style passwords."
I don't know how to proceed.
Should I change the MySQL database installation ? Is this advisable?
Should I find a workaround to use a different MySQL Connector?
I tried to uninstall every MySQL related application in my computer and the error persists.
I appreciate any help.
Solved! Go to Solution.
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.
User | Count |
---|---|
106 | |
88 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |