connecting arduino to my web server mysql database wirelessly by esp8266

Hi, guys, I am new to Arduino forum and I required your help hardly, My doubt is "How can I retrieve data from web server MySQL database to Arduino by using esp8266 wirelessly" Please help me :frowning: :frowning:

My approach would be:

Send an https GET or POST request to your server, have server respond with a JSON or similarly packed set of data. Use a python or php script server side to handle the connection to your database.

Add to that some basic session management (username/password login) and harden your script against sql injection and you should have a very good starting point. I do assume the connection to your WiFi network is there already.