Power BI connect mysql problem

[s_kula]

I have a problem with connecting to mysql database via Power Bi Desktop. I can log in to the database without any problems via phpmyadmin.
Can programs require different login passwords?

If so, will I find the required logins and passwords after logging into the database via php?

Sebastian

[Pbidev342]

Check out this video guide might help you https://youtu.be/EL3DdMVAUnQ?si=ie7O3RiB0nrIap0B

[s_kula]

Below, server details

[s_kula]

Hello, I found a user who logs in php.
Unfortunately, there is still a problem with logging in

Details "MySQL: Reading from the stream has failed."

Could it be some server security?

[s_kula]

Hello, I already have the connector correctly installed. I suspect the problem is an error in the login details.
When logging in directly to the database via phpmyadmin, I enter:
server
database
password

power bi requires an additional username

does anyone know how to find this data?

[pratyashasamal · Accepted solution]

Try to use your username ,

Thanks ,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

[pratyashasamal]

Hi @s_kula ,
Please follow this link to connect power bi to my sql .
https://learn.microsoft.com/en-us/power-query/connectors/mysql-database
Thanks ,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C