Re: MySQL and Arduino Chapter 7

[Richard Mason]

Well, following my recent frustrations I've proceeded to the next problem
First to note that that in the /etc/mysql/my.cnf file under the [mysqld] section it said:
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = 127.0.0.1

which explains why I couldn't connect using the pi's assigned ip address
Now that's fixed the the sketch on page 234 of the book runs - sort of.

I added a disconnect() and, starting with an empty arduino.hello table, opening of the Serial Monitor results in:
Connecting
Connecting to server version 5.5.35-0+wheezy1
Query Success!
Disconnected

Good, except there is not one entry into the database but three!
The first shouldn't be there at all as its time stamp preceeds the actual opening of the Serial Monitor. The second entry is the expected one. The third entry is triggered by closing the Serial Moniter