How To Connect NodeMCU ESP8266 to MySQL/MariaDB Database (Remote Server Or Local PC)

How To Connect NodeMCU ESP8266 to MySQL/MariaDB Database (Remote Server Or Local PC):-

1. Create database, table and columns.
3. Upload files to server using Filezilla FTP client.
4. Edit .ino file for necessary changes.
5. Upload code to NodeMCU ESP8266.

[viveksharmamcaa]

Please, Make video for taking input from website to nodemcu

[experimental]

After trying numerous tutorials, this one worked, Thank You !!

[benmedka]

The best video ever in this shield.
Thank you

[touficmadhoun]

You bro are a life savior..It worked like a charm. I used ultrasonic sensors and turbidity sensor and it sent the values correctly within a delay..Thank you so much <3

[rajmehta]

Thank you!!! I follow your instruction and I got output. Thank you.

[abcknw]

It worked perfectly 😊 thank you so much 😊

[munir]

Thank you sir, you are a life savior, a perfect tutorial

[megasinc]

thank you very much ... brilliant tutorial 👍👍👍

[happy]

Http response -1, failed to upload values. How can I fix this error?

[tandasjamesbryang.]

hey tricksumo why i cant connect my data in hostinger but in 00webhost it works like a charm and it said that mysql is connected in serial monitor but if my host is my domain in hostinger it will said failed to upload values 301, i check my database and it connected.

[bacchus]

when i try this i get "Failed to upload values" in the COM with HTTPCode 400 both dbread an dbwrite are connected to the server. please help

[musaadejoshuaibuopaluwa]

Hi, Thank you so much for your detailed tutorial. I followed your steps and it worked.
I however need your help with how I could SELECT or request for a data in a cell of my choice using either id number or column name.
That is a function that could INSERT values and another function that would read values in one ESP8266.
Thank you in anticipation.

[hoannguyen-uceh]

hi. I did follow your code but unfortunately, I have an error but don't know how to fix this.
My browser show Incorrect double value: '' for column at row 1
Can you tell me what the error is?

[MuhammadAdeel-ryrt]

sir i have an issue please help me
call to 'HTTPClient::begin' declared with attribute error: obsolete API, use ::begin(WiFiClient, url)

[kharl]

Hello Sir can please make a video for getting a data from database and store it to a variable in nodemcu ?

[mihai-vladrusu]

Hello, this works on ESP8266 Module? I want to get some data from mysql and store them in arduino variables

[jeremytiempo]

Is this same process if i use arduino uno board + esp-01 not nodemcu?

[ShivamThakur-itsg]

I am getting an error which I can't understand, this is the error text : Connected to mysql database. Error: INSERT INTO data_table (val, val2, Date, Time) VALUES ('27', '359', '2021-05-30', '17:23:05')<br>Field 'id' doesn't have a default value
17:23:04.877 ->
Please help. I have mailed you all the codes and screenshots.

[timotejgaspar]

hello, can you pls tell me whats the name of library for that #include <ESP8266HTTPClient.h>. Thanks

[deepshikhaparwate]

can i use
wroom dev kit v1 instead nodemcu