I'm new to Azure App Service.
I want to run a WebPage, I'm using PHP and MySQL as backend. Everything is working fine for me when I'm running local but my task is to connect the database residing in a remote server. I have created a VM in Azure and installed XAMP, now I'm trying to connect the MySQL in that remote server with the Azure "MySQL in App" but every time I connect I get the error "MySQL in App import failed"

NOTE - I'm not using the root account - a proper account with a password has been configured in MySQL, also note that XAMP uses port 3306 for MySQL and that is opened in the networking part of that VM so there is no issue in VM.
Please let me know if you need more information. I need a solution ASAP,
Thanks