Configure MySQL for Arduino in Python
This guide is only applicable for Windows.
This article explains the steps associated with configuring
MySQL for Arduino in Python.
WAMP. Then open its control panel and start
MySQLservers. After that, click the admin button and goto
PHPMyAdminand create the database to store the data.
Install Python 2.7, and install
pyserial, you can also download it from herehttps://pypi.python.org/pypi/pyserial/2.7#downloads. Download the “.exe” file and just run it.
MYSQLdb, you can also download it from https://pypi.python.org/pypi/MySQL-python/1.2.5#downloads. Download the “.exe” file and just run it.
Then, create the required python program to update the database. For this, you need to add two import
Install Arduino and write the program to read values from the sensor and print the values using
I referred to this code in 4 for my project; I hope this will help you.