ESP32 4G IoT: Send Data to MySQL using SIM A7670G & MQTT (The Ultimate Guide)
Read the Full Guide & Copy the Code: https://iotbhai.io/esp32-sima7670g-my...
Learn how to send sensor data (DHT11/DHT22) from an ESP32 to a MySQL database using the SIM A7670G 4G LTE module. We will use MQTT to transmit data over the cellular network and a Python script to bridge the MQTT broker with the SQL server.
This is part of our SIM A7670G series. If you haven't set up your server or hardware yet, check the links below!
*Looking for SIM800L Tutorials? Check out our playlist:* [ • The Ultimate ESP32 & SIM800L Guide ]
*Setup and Circuit Diagram Video:* [ • How to Connect SIMA7670G 4G GSM Module wit... ]
In this step-by-step IoT tutorial, you'll discover how to:
✅ Collect temperature and humidity data using the DHT11 sensor
✅ Transmit real-time data via MQTT over a 4G cellular connection
✅ Store sensor readings securely in a MySQL database
✅ Build a reliable, Wi-Fi-free remote monitoring system for environmental data
⚡ Hardware Required:
ESP32 Development Board [https://amzn.to/4sqllnS | https://s.click.aliexpress.com/e/_c3F...]
SIMA7670G 4G Module [https://amzn.to/49hWg5u | https://s.click.aliexpress.com/e/_c3r...]
External 5V 2A Power Supply (Do not power directly from ESP32!) [https://amzn.to/3Napv35 | https://s.click.aliexpress.com/e/_c3A...]
4G LTE SIM Card with Data Plan
DHT11 Temperature Sensor [https://s.click.aliexpress.com/e/_c4s... | https://amzn.to/3Z1HkEb]
⏱️ Timestamps:
00:00 - Introduction & Project Overview
00:50 - Prerequisites (Server & MySQL Setup)
01:15 - Circuit Connection (ESP32 & SIM A7670G)
01:55 - Architecture Explanation (MQTT to Python to MySQL)
02:40 - ESP32 Code Walkthrough
03:30 - Live Demo: Sending Data to MQTT
04:05 - Python Script (MQTT Subscriber)
04:50 - Verifying Data in MySQL Workbench
06:20 - Conclusion
💻 *Resources & Code:*
*TinyGSM Library:* [https://github.com/lewisxhe/TinyGSM-fork]
**ESP32 Code:**[https://github.com/ittipu/IoT_Bhai_Yo...]
**Python Script:**[https://github.com/ittipu/IoT_Bhai_Yo...]
*Setup Your Own MQTT Broker:* [ • Setup Private MQTT Broker on Cloud VPS (Mo... ]
👍 *Did this video help you?*
If you found this tutorial useful, please like, share, and subscribe for more IoT projects! Let me know in the comments if you have any questions.
#esp32 #sima7670g #arduino #esp32tutorial #esp32project #arduinoproject #arduinoprogramming #gsm #gps #sima7670g #4g #tutorial