MySQL for the Internet of Things
Chapter 6 ■ Building low-Cost MysQl data nodes However, the really nice part is the pcDuino’s onboard bootable operating system ...
Chapter 6 ■ Building low-Cost MysQl data nodes The Intel Galileo’s onboard bootable Linux is minimal, but I recommend downloadin ...
Chapter 6 ■ Building low-Cost MysQl data nodes Once the installation is complete, you should be able to start the MySQL server a ...
Chapter 6 ■ Building low-Cost MysQl data nodes MySQL Clients: How to Connect and Save Data You have already seen how to connect ...
Chapter 6 ■ Building low-Cost MysQl data nodes The database connector is named Connector/Arduino. It implements the MySQL client ...
Chapter 6 ■ Building low-Cost MysQl data nodes Installing Connector/Arduino There are two ways to get and install Connector/Ardu ...
Chapter 6 ■ Building low-Cost MysQl data nodes ■Tip if you copy a library to your Libraries folder while the arduino application ...
Chapter 6 ■ Building low-Cost MysQl data nodes Using Connector/Arduino Let’s begin with a simple sketch designed to insert a sin ...
Chapter 6 ■ Building low-Cost MysQl data nodes mysql> GRANT ALL ON . to 'root'@'%' IDENTIFIED BY 'secret'; mysql> INSERT I ...
Chapter 6 ■ Building low-Cost MysQl data nodes Next, you need to set up some variables for Connector/Arduino. You need to define ...
Chapter 6 ■ Building low-Cost MysQl data nodes After the delay, you print a statement to the serial monitor to indicate that you ...
Chapter 6 ■ Building low-Cost MysQl data nodes Listing 6-5. “Hello, MySQL!” Sketch /** Example: Hello, MySQL! This code modul ...
Chapter 6 ■ Building low-Cost MysQl data nodes If your Arduino connects to the MySQL server but the query fails, you see an erro ...
Chapter 6 ■ Building low-Cost MysQl data nodes Be sure to double-check the source code and the IP address of your MySQL server a ...
Chapter 6 ■ Building low-Cost MysQl data nodes Let’s check the results of the test runs. To do so, you connect to the database s ...
Chapter 6 ■ Building low-Cost MysQl data nodes You can do much more with the connector than shown here. In fact, you can query t ...
Chapter 6 ■ Building low-Cost MysQl data nodes if you have never used python or you would like to know more about it, the follow ...
Chapter 6 ■ Building low-Cost MysQl data nodes As I mentioned, the current version of Connector/Python is 2.1.3, but most versio ...
Chapter 6 ■ Building low-Cost MysQl data nodes $ sudo pip3 install mysql-connector-python --allow-external mysql-connector-pytho ...
Chapter 6 ■ Building low-Cost MysQl data nodes $ python Python 2.7.6 (default, Mar 4 2014, 16:53:21) [GCC 4.2.1 Compatible Apple ...
«
8
9
10
11
12
13
14
15
16
17
»
Free download pdf