there is database in php which is not hosted in a local machine. Want to connect the database to power bi.
error is- "MySQL: Unable to connect to any of the specified MySQL hosts."
Mysql connector is already installed.
here is the proof Image
1 Answers
So, if it is the first time you are connecting to it, then you can see an icon at the home page called as MySQL. Then click on it and it will ask details. It will ask the server name, enter the name and database if required. Then it verifies and asks the username and password to login. the server Ip in your image is IP 54.90.3.4 this is your hosted server. If your database is hosted on same server, you should set your same server value. Add the default localhost in the last. follow here to connect your server to power BI
Related