查看: 3617|回复: 2

[求助] esp8266+mysql的问题

我最近在使用esp8266的时候打算和本机的mysql数据库产生互联
我使用了Arduino的sql库
esp8266+mysql的问题图1

然后使用实例代码
/*
  MySQL Connector/Arduino Example : connect by wifi

  This example demonstrates how to connect to a MySQL server from an
  Arduino using an Arduino-compatible Wifi shield. Note that "compatible"
  means it must conform to the Ethernet class library or be a derivative
  with the same classes and methods.

  For more information and documentation, visit the wiki:
  https://github.com/ChuckBell/MySQL_Connector_Arduino/wiki.

  INSTRUCTIONS FOR USE

  1) Change the address of the server to the IP address of the MySQL server
  2) Change the user and password to a valid MySQL user and password
  3) Change the SSID and pass to match your WiFi network
  4) Connect a USB cable to your Arduino
  5) Select the correct board and port
  6) Compile and upload the sketch to your Arduino
  7) Once uploaded, open Serial Monitor (use 115200 speed) and observe

  If you do not see messages indicating you have a connection, refer to the
  manual for troubleshooting tips. The most common issues are the server is
  not accessible from the network or the user name and password is incorrect.

  Created by: Dr. Charles A. Bell
*/
#include <Arduino.h>
#include <ESP8266WiFi.h>          // Use this for WiFi instead of Ethernet.h
#include <MySQL_Connection.h>
#include <MySQL_Cursor.h>

IPAddress server_addr(192,168,1,5);  // IP of the MySQL *server* here
char user[] = "root";             // MySQL user login username
char password[] = "123456";       // MySQL user login password

// Sample query
char INSERT_SQL[] = "INSERT INTO arduino_test.hello (message) VALUES ('Hello, Arduino!')";

// WiFi card example
char ssid[] = "CU_md5k";       // your SSID
char pass[] = "g7yy7h63";    // your SSID Password

WiFiClient client;                // Use this for WiFi instead of EthernetClient
MySQL_Connection conn(&client);
MySQL_Cursor* cursor;

void setup()
{
  Serial.begin(9600);
  while (!Serial); // wait for serial port to connect. Needed for Leonardo only

  // Begin WiFi section
  Serial.printf("\nConnecting to %s", ssid);
  WiFi.begin(ssid, pass);
  while (WiFi.status() != WL_CONNECTED) {
delay(500);
Serial.print(".");
  }

  // print out info about the connection:
  Serial.println("\nConnected to network");
  Serial.print("My IP address is: ");
  Serial.println(WiFi.localIP());

  Serial.print("Connecting to SQL...  ");
  if (conn.connect(server_addr, 3306, user, password))
Serial.println("OK.");
  else
Serial.println("FAILED.");

  // create MySQL cursor object
  cursor = new MySQL_Cursor(&conn);
}

void loop()
{
  if (conn.connected())
cursor->execute(INSERT_SQL);

  delay(5000);
}

我已经在mysql里面创建好对应的表
esp8266+mysql的问题图2