You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
/*
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.
Note: The MAC address can be anything so long as it is unique on your network.
Created by: Dr. Charles A. Bell
*/
#include <WiFi.h> // Use this for WiFi instead of Ethernet.h
#include <MySQL_Connection.h>
#include <MySQL_Cursor.h>
IPAddress server_addr(111,1111,111,111); // IP of the MySQL *server* here <-- dummy IP
char user[] = "root"; // MySQL user login username
char password[] = "rootdummypassword"; // MySQL user login password
// WiFi card example
const char *ssid = "My_WiFi"; // your SSID
const char *pass = "my-password"; // your SSID Password
WiFiClient client; // Use this for WiFi instead of EthernetClient
MySQL_Connection conn((Client *)&client);
void setup() {
Serial.begin(115200);
// while (!Serial); // wait for serial port to connect. Needed for Leonardo only
// Begin WiFi section
WiFi.mode(WIFI_STA);
WiFi.begin(ssid, pass);
Serial.println("Connectiing to WiFi");
unsigned long start_time = millis();
const unsigned long timeout = 20000;
while(WiFi.status() != WL_CONNECTED && (millis() - start_time) < timeout){
delay(500);
Serial.print(".");
}
if (WiFi.status() == WL_CONNECTED){
Serial.println("\nConnected to WiFi!");
Serial.print("IP address: ");
Serial.println(WiFi.localIP());
} else {
Serial.println("\nFailed to connect to WiFi.");
}
// End WiFi section
Serial.println("Connecting...");
if (conn.connect(server_addr, 3306, user, password)) {
delay(1000);
Serial.println("Connected to database!");
}
else
Serial.println("Connection failed.");
conn.close();
}
void loop() {
}
Hello.
I'm trying to use one of your example codes to connect to a database via WiFi
The example code is this:
https://github.com/ChuckBell/MySQL_Connector_Arduino/blob/master/examples/connect_wifi/connect_wifi.ino
but with some minor changes.
This is what I get in my serial monitor:
Any thing I can do to try to figure out what is happening?
The text was updated successfully, but these errors were encountered: