I am currently trying to connect an ESP8266 to my Azure MySQL database via WiFi, but have not yet been successful.
I have tried a bunch of guides, but no luck and I'm running out of ideas. I have made a connection to an IoT Hub in Azure but could not forward the messages to the MySQL database in the cloud. I managed to get it stored in a blob datatype but had so many issues with it that I kinda scratched that idea.
Last thing I tried was trying to implement the example from https://github.com/ChuckBell/MySQL_Connector_Arduino more specifically the 'connect_wifi' example. I was unable to find the ip of my azure server so i tried using some of the code from the 'connect_by_hostname' but no luck there.
I'm new to Arduino and cloud in general so any help is appreciated.