MySQL Forums
Forum List  »  Connector/Arduino

Re: MySQL and Arduino Chapter 7
Posted by: Richard Mason
Date: April 07, 2014 01:11AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
2415
March 31, 2014 01:35AM
Re: MySQL and Arduino Chapter 7
1347
April 07, 2014 01:11AM
1247
April 08, 2014 11:31AM
1326
April 10, 2014 07:22PM
1552
April 08, 2014 11:43AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.