We are using Godaddy Managed WordPress Hosting to store a website,
We need to create reports using MS Power BI on the data that is contained within the underlying MySQL database.
Is it possible to have a remote connection to the MySQL database?
We've been through the PHPAdmin panel and cannot see how to get a connection string.
We are currently exploring if we can use an SSH tunnel.
Does anyone have any experiences or idea to share?
Thanks in advance