mysql.h

Projects Programming
1

hello everyone ..

im trying to do something with arduino and sql
this is the library i need
SPI.h
Ethernet.h
sha1.h
mysql.h

but my problem with mysql.h
when i do like this

#include "SPI.h"
#include "Ethernet.h"
#include "sha1.h"
#include "mysql.h"

/* Setup for Ethernet Library */
byte mac_addr[] = { 0xDE, 0xAD, 0xBE, 0xEF, 0xFE, 0xED };
IPAddress server_addr(10, 0, 1, 23);

/* Setup for the Connector/Arduino */
Connector my_conn; // The Connector/Arduino reference

char user[] = "root";
char password[] = "secret";
char INSERT_SQL[] = 
 "INSERT INTO test_arduino.hello VALUES ('Hello, MySQL!', NULL)";

void setup() {
  Ethernet.begin(mac_addr);
  Serial.begin(115200);
  delay(1000);
  Serial.println("Connecting...");
  if (my_conn.mysql_connect(server_addr, 3306, user, password))
  {
    delay(500);
     /* Write Hello, World to MySQL table test_arduino.hello */
     my_conn.cmd_query(INSERT_SQL);
     Serial.println("Query Success!"); 
  } 
  else
    Serial.println("Connection failed.");
}

void loop() {
}

i gat this error

sketch_may06d.ino:4:19: fatal error: mysql.h: No such file or directory
compilation terminated.
Error compiling.

how can i download the mysql.h libraly to arduino
i trid mysql_connecter

i also gat this error ..

In file included from sketch_may06d.ino:1:0:
C:\Users\pulldozerr\Documents\Arduino\libraries\mysql_connector/._mysql.h:1:2: error: stray '\5' in program
C:\Users\pulldozerr\Documents\Arduino\libraries\mysql_connector/._mysql.h:1:2: error: stray '\26' in program
C:\Users\pulldozerr\Documents\Arduino\libraries\mysql_connector/._mysql.h:1:2: error: stray '\7' in program
C:\Users\pulldozerr\Documents\Arduino\libraries\mysql_connector/._mysql.h:1:2: error: stray '\2' in program
C:\Users\pulldozerr\Documents\Arduino\libraries\mysql_connector/._mysql.h:1:2: error: stray '\2' in program
C:\Users\pulldozerr\Documents\Arduino\libraries\mysql_connector/._mysql.h:1:2: error: stray '\203' in program
C:\Users\pulldozerr\Documents\Arduino\libraries\mysql_connector/._mysql.h:1:2: error: stray '\2' in program
C:\Users\pulldozerr\Documents\Arduino\libraries\mysql_connector/._mysql.h:1:2: error: stray '\265' in program
C:\Users\pulldozerr\Documents\Arduino\libraries\mysql_connector/._mysql.h:1:2: error: stray '\5' in program
C:\Users\pulldozerr\Documents\Arduino\libraries\mysql_connector/._mysql.h:1:2: error: stray '\265' in program
C:\Users\pulldozerr\Documents\Arduino\libraries\mysql_connector/._mysql.h:1:2: error: stray '\230' in program
C:\Users\pulldozerr\Documents\Arduino\libraries\mysql_connector/._mysql.h:1:2: error: stray '\35' in program
C:\Users\pulldozerr\Documents\Arduino\libraries\mysql_connector/._mysql.h:1:2: error: stray '\1' in program
C:\Users\pulldozerr\Documents\Arduino\libraries\mysql_connector/._mysql.h:1:2: error: stray '\230' in program
C:\Users\pulldozerr\Documents\Arduino\libraries\mysql_connector/._mysql.h:1:2: error: stray '\35' in program
C:\Users\pulldozerr\Documents\Arduino\libraries\mysql_connector/._mysql.h:1:2: error: stray '\25' in program
C:\Users\pulldozerr\Documents\Arduino\libraries\mysql_connector/._mysql.h:1:160: error: exponent has no digits
C:\Users\pulldozerr\Documents\Arduino\libraries\mysql_connector/._mysql.h:1:2: error: stray '\1' in program
C:\Users\pulldozerr\Documents\Arduino\libraries\mysql_connector/._mysql.h:1:2: error: stray '\5' in program
C:\Users\pulldozerr\Documents\Arduino\libraries\mysql_connector/._mysql.h:1:2: error: stray '\10' in program
C:\Users\pulldozerr\Documents\Arduino\libraries\mysql_connector/._mysql.h:1:2: error: stray '\4' in program
C:\Users\pulldozerr\Documents\Arduino\libraries\mysql_connector/._mysql.h:1:2: error: stray '\10' in program
C:\Users\pulldozerr\Documents\Arduino\libraries\mysql_connector/._mysql.h:1:2: error: stray '\4' in program
C:\Users\pulldozerr\Documents\Arduino\libraries\mysql_connector/._mysql.h:1:2: error: stray '\4' in program
C:\Users\pulldozerr\Documents\Arduino\libraries\mysql_connector/._mysql.h:1:2: error: stray '\36' in program
C:\Users\pulldozerr\Documents\Arduino\libraries\mysql_connector/._mysql.h:1:2: error: stray '\1' in program
C:\Users\pulldozerr\Documents\Arduino\libraries\mysql_connector/._mysql.h:1:2: error: stray '\5' in program
C:\Users\pulldozerr\Documents\Arduino\libraries\mysql_connector/._mysql.h:1:2: error: stray '\10' in program
C:\Users\pulldozerr\Documents\Arduino\libraries\mysql_connector/._mysql.h:1:2: error: stray '\4' in program
C:\Users\pulldozerr\Documents\Arduino\libraries\mysql_connector/._mysql.h:1:2: error: stray '\10' in program
C:\Users\pulldozerr\Documents\Arduino\libraries\mysql_connector/._mysql.h:1:2: error: stray '\7' in program
C:\Users\pulldozerr\Documents\Arduino\libraries\mysql_connector/._mysql.h:1:2: error: stray '\311' in program
C:\Users\pulldozerr\Documents\Arduino\libraries\mysql_connector/._mysql.h:1:2: error: stray '\34' in program
In file included from sketch_may06d.ino:1:0:
C:\Users\pulldozerr\Documents\Arduino\libraries\mysql_connector/._mysql.h:2:3: error: stray '\377' in program
C:\Users\pulldozerr\Documents\Arduino\libraries\mysql_connector/._mysql.h:2:3: error: stray '\377' in program
C:\Users\pulldozerr\Documents\Arduino\libraries\mysql_connector/._mysql.h:2:3: error: stray '\3' in program
sketch_may06d.ino:6:19: fatal error: mysql.h: No such file or directory
compilation terminated.
Error compiling.

so how can i add mysql.h ..
thank you ..

2

Have you actually got mysql.h and if so where is it located on the PC, where did you get it from and how (zip file, copy/paste, some other way) ?

3

UKHeliBob:
Have you actually got mysql.h and if so where is it located on the PC, where did you get it from and how (zip file, copy/paste, some other way) ?

no i didn't ..
its not to where to locat it ..
if i have the zip file ill uploaded to the arduino software librarys
and im like you need the zip file ..