After that, follow the next steps to create your database, username, password, and SQL table. Preparing Your MySQL DatabaseĪfter signing up for a hosting account and setting up a domain name, you can login to your cPanel or similar dashboard. This allows you to easily access your ESP readings without relying on a third-party IoT platform. However, the purpose of this tutorial is to publish readings in your own domain name that you can access from anywhere in the world. Note: you can also run a LAMP (Linux, Apache, MySQL, PHP) server on a Raspberry Pi to access data in your local network. If you like our projects, you might consider signing up for one of the recommended hosting services, because you’ll be supporting our work. This is what makes this project interesting: you’ll be able to go to your domain name () and see the sensor readings from the ESP32 or ESP8266. When buying a hosting account, you’ll also have to purchase a domain name. Get Hosting and Domain Name with Bluehost » If you don’t have a hosting account, I recommend signing up for Bluehost. Any hosting service that offers PHP and MySQL will work with this tutorial. Those two services are the ones that I use and personally recommend, but you can use any other hosting service. I only recommended this option for advanced users. Digital Ocean : Linux server that you manage through a command line.I recommend choosing the unlimited websites option Bluehost (user-friendly with cPanel): free domain name when you sign up for the 3-year plan.I recommend using one of the following hosting services that can handle all the project requirements: You can visualize the readings from anywhere in the world by accessing your own server domain. The goal of this project is to have your own domain name and hosting account that allows you to store sensor readings from the ESP32 or ESP8266. Hosting Your PHP Application and MySQL Database
0 Comments
Leave a Reply. |