Cannot connect to MySQL database

[AnibalPb]

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.

[v-yuta-msft · Accepted solution]

@AnibalPb ,

This error message means your root name or password is incorrect. Please check them again in mysql database.

Regards,

Jimmy Tao

[Vickyli]

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