Packt+ | Advance your knowledge in tech

You're reading from Internet of Things Programming with JavaScript Get the best out of Arduino and Raspberry Pi Zero to develop Internet of Things projects using JavaScript

Product type Paperback

Published in Feb 2017

Publisher Packt

ISBN-13 9781785888564

Length 298 pages

Edition 1st Edition

Languages

JavaScript

Tools

Arduino

Concepts

Single Board Computers

Author (1):

Ruben Oliva Ramos

View More author details

Table of Contents (10) Chapters

Preface

1. Getting Started with Raspberry Pi Zero

2. Connecting Things to the Raspberry Pi Zero FREE CHAPTER

3. Connecting Sensors - Measure the Real Things

4. Control-Connected Devices

5. Adding a Webcam to Monitor Your Security System

6. Building a Web Monitor and Controlling Devices from a Dashboard

7. Building a Spy Police with the Internet of Things Dashboard

8. Monitoring and Controlling Your Devices from a Smart Phone

9. Putting It All Together

Configuring MySQL database server

In this section, you will learn how to configure MySQL server in order to create a database and integrate everything in your dashboard, for recording data in a database.

Installing MySQL

Our Raspberry Pi Zero is being configured like a web server. In this section, we will install MySQL database server with the following command, so we can receive connections from clients, display data stored in a database, and use queries in SQL:

sudo apt-get install mysql-server

After the installation is complete, connect to MySQL and type the following command:

mysql -u root -p

Type the following command:

show databases;

Installing MySQL driver for PHP

It's important to install our driver to communicate PHP5 with MySQL database server, to do that we will need MySQL driver for PHP to access MySQL database, execute this...

The rest of the chapter is locked

Tech Concepts

Programming languages

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at €18.99/month. Cancel anytime

Authors (1)

Ruben Oliva Ramos

Ruben Oliva Ramos is a computer systems engineer from Tecnologico de Leon Institute, with a master's degree in computer and electronic systems engineering and a specialization in teleinformatics and networking from the University of Salle Bajio in Leon, Guanajuato, Mexico. He has more than 5 years of experience of developing web applications to control and monitor devices connected with Arduino and Raspberry Pi, using web frameworks and cloud services to build the Internet of Things applications. He is a mechatronics teacher at the University of Salle Bajio and teaches students of the master's degree in design and engineering of mechatronics systems. Ruben also works at Centro de Bachillerato Tecnologico Industrial 225 teaching subjects such as electronics, robotics and control, automation, and microcontrollers. He is a consultant and developer for projects in areas such as monitoring systems and datalogger data using technologies (such as Android, iOS, HTML5, and ASP.NET), databases (such as SQlite, MongoDB, and MySQL), web servers, hardware programming, and control and monitor systems for data acquisition and programming.

See other products by Ruben Oliva Ramos