cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rashidanwar
Regular Visitor

Authentic to host using method ''mySql_native_password' failed: Plugin 'unix_socket' is not loaded

Hi everybody, 
I am getting an error while connecting to mySql database
Here is the full error message I see when I refresh the power BI desktop report.

"MySQL: Authentication to host 'xxx.xxx.xxx.xxx' for user '' using method 'mysql_native_password' failed with message: Plugin 'unix_socket' is not loaded".

I would appreceiate any help in this regard.

Thank you.

1 ACCEPTED SOLUTION
rashidanwar
Regular Visitor

Thank you Ibendlin for your response. This problem was resolved as follow.
Context of the problem: I changed my lapptop and after installing the power BI on new laptop I did face this problem. 

Later I came to know that, when we install power BI, credentials in the Data Source Setting are set to windows by default. So I changed them to Database by going to
Home => Transform data => Data Source Setting => Edit Permissions => Edit => Database and then provide your database credentials there, hit the SAVE button and you are DONE!

 


View solution in original post

2 REPLIES 2
rashidanwar
Regular Visitor

Thank you Ibendlin for your response. This problem was resolved as follow.
Context of the problem: I changed my lapptop and after installing the power BI on new laptop I did face this problem. 

Later I came to know that, when we install power BI, credentials in the Data Source Setting are set to windows by default. So I changed them to Database by going to
Home => Transform data => Data Source Setting => Edit Permissions => Edit => Database and then provide your database credentials there, hit the SAVE button and you are DONE!

 


View solution in original post

lbendlin
Super User
Super User

Helpful resources

Announcements
Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Microsoft Ignite 768x460.png

Find your focus

Explore the latest tools,training sessions,technical expertise, networking and more.

Power BI Womens Summit 2021 768 x460.jpg

Interviews, learning sessions, allies, and more!

#PowerBIWomenSummit

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!