I have a VM setup in Azure (running Windows Server 2012 R2) with MySQL 5.7 installed. I am trying to access this using MySQL Workbench - which when running on the server works perfectly.
I have also tried doing this using a PHP file in an Azure web app to connect, again not working.
I have set the following:
- Azure Security Group, inbound port 3306 is open
- On the server the following inbound port rules have been applied:
- User is set to stackexchange@% (i.e. not localhost)
Is there something I have missed? Do I need to allow the database to have remote connections?
Apologises if this is the wrong site. Wasn't sure if it was server related or related to the DB itself.