Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, I'm having a problem connecting Power BI to a MySQL DB. I'm connecting to localhost and then select the database 'monitore_perfileducacion'. I don't know why but this error comes up when it appears everything's alright. And if I try to connect to the IP that appears at the workbench connections in MySQL it doesn't work. How can I fix this? I tried everything in almost every available post.
DataSource.Error: MySQL: Authentication to host 'localhost' for user 'root' using method 'caching_sha2_password' failed with message: Unknown database 'monitore_perfileducacion'
Details:
DataSourceKind=MySql
DataSourcePath=localhost;monitore_perfileducacion
Message=Authentication to host 'localhost' for user 'root' using method 'caching_sha2_password' failed with message: Unknown database 'monitore_perfileducacion'
ErrorCode=-2147467259
The screen looks like this, and if I press refresh in the preview, the error is shown. Thing is, the connection is alright in MySQL.
Solved! Go to Solution.
This error message means your root name or password is incorrect. Please check them again in mysql database.
Regards,
Jimmy Tao
This error message means your root name or password is incorrect. Please check them again in mysql database.
Regards,
Jimmy Tao
Hi Jimmy,
I had the same issue. I'm pretty sure the username and password is correct (I can log in into workbench with same credentials)I also tried clear permission and reconnect again, still doesn't work. Do you have other suggestions?
Thanks,
Vicky
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |