I have recently setup a new database in the PHPMyAdmin tool for Inmotion hosting. I have also been successful in setting up a connection between the database and MySQL Workbench.
I am not working to try to setup a connection between this database and Power BI in order to setup some reporting on the data. However, after inputs I am getting the following error:
"Unable to Connect: We encountered an error while trying to connect.
Details: "Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - The remote computer refused the network connection.)"
To recreate the issues I am:
Get Data --> MySQL database
For server value I have tried many things such as localhost and localhost:3306. For credentials I am selecting database credentials and entering in credentials for the C-Panel.
Any assistance on this would be greatly appreciated.