ChuckBell
commented
6 years ago It appears you have an issue with permissions. The error, "Access denied for user" is from the MySQL server. It indicates the user@host combination + password is not permitted to connect to the server. Check your permissions again to ensure the user you specified can indeed connect to your MySQL instance via the 192.168.1.0 network.
Hint: see the reference manual about user+host access in the troubleshooting section.
Note that simply connecting to your MySQL server from another computer with root or some other account is not a valid test of permissions. You should always test using another computer on the same WiFi network as the Arduino is connecting with the same user and password included in your sketch.
If you continue to have problems and the troubleshooting tips do not help, please respond with the model of WiFi shield you are using.
On 12/5/17 1:17 PM, Niall wrote:
I am using the WiFiESP library from BPortaluri along with your MySQL connector to connect an Arduino UNO to a MySQL server. My code will connect sometimes to the MySQL server but in most cases it times out when trying to connect. I have tried increasing the MAX_CONNECT_ATTEMPTS and the delay between attempts in MySQL_Connection.cpp but this does not seem to matter. Sometimes the timeout will occur after 1 attempt and sometimes after 5 or 6. It is not an issue with the MySQL server as the connection is always successful from a remote computer. My ESP8266 and the MySQL server are connected to the same WiFi router. I have attached a screenshot of my serial monitor output and my Arduino sketch.
Any help would be greatly appreciated.
Screenshot Arduino Timeout Error.docx https://github.com/ChuckBell/MySQL_Connector_Arduino/files/1531785/Screenshot.Arduino.Timeout.Error.docx
`//#include
// Use this for WiFi instead of Ethernet.h include
//use for ESP8266 include
include
// Emulate Serial1 on pins 2/3 if not present
ifndef HAVE_HWSERIAL1
include "SoftwareSerial.h"
SoftwareSerial Serial1(2, 3); // RX, TX
endif
byte mac_addr[] = { 0xDE, 0xAD, 0xBE, 0xEF, 0xFE, 0xED };
IPAddress server_addr(192,168,1,4); // IP of the MySQL /server/ here char user[] = "user1"; char password[] = "pass1";
// WiFi card example char ssid[] = "mysid"; // your network SSID (name) char pass[] = "password"; // your network password
//WiFiClient client; // Use this for WiFi instead of EthernetClient WiFiEspClient client; //Use this for ESP8266 MySQL_Connection conn((Client *)&client);
void setup() { Serial.begin(115200); while (!Serial); // wait for serial port to connect. Needed for Leonardo only // initialize serial for ESP module Serial.println("Starting...."); Serial1.begin(9600); // initialize ESP module WiFi.init(&Serial1); Serial.println("Connecting to WiFi");
// Begin WiFi section int status = WiFi.begin(ssid, pass); if ( status != WL_CONNECTED) { Serial.println("Couldn't get a wifi connection"); while(true); } // print out info about the connection: else { Serial.println("Connected to network"); IPAddress ip = WiFi.localIP(); Serial.print("My IP address is: "); Serial.println(ip); } // End WiFi section
Serial.println("Connecting..."); if (conn.connect(server_addr,3306,user,password)) { delay(1000); } else Serial.println("Connection failed."); conn.close(); }
void loop() { } `
— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/ChuckBell/MySQL_Connector_Arduino/issues/28, or mute the thread https://github.com/notifications/unsubscribe-auth/AH0j4JMHGVtLMc6VJrc6Qp_UHElt5AYxks5s9YizgaJpZM4Q2vFB.
nokeeffe
copterino
asetyde
michaelradhuber
JangHyeonJun2
I am using the WiFiESP library from BPortaluri along with your MySQL connector to connect an Arduino UNO to a MySQL server. My code will connect sometimes to the MySQL server but in most cases it times out when trying to connect. I have tried increasing the MAX_CONNECT_ATTEMPTS and the delay between attempts in MySQL_Connection.cpp but this does not seem to matter. Sometimes the timeout will occur after 1 attempt and sometimes after 5 or 6. It is not an issue with the MySQL server as the connection is always successful from a remote computer. My ESP8266 and the MySQL server are connected to the same WiFi router. I have attached a screenshot of my serial monitor output and my Arduino sketch.
Any help would be greatly appreciated.
Screenshot Arduino Timeout Error.docx
`//#include // Use this for WiFi instead of Ethernet.h
include //use for ESP8266
include
include
// Emulate Serial1 on pins 2/3 if not present
ifndef HAVE_HWSERIAL1
include "SoftwareSerial.h"
SoftwareSerial Serial1(2, 3); // RX, TX
endif
byte mac_addr[] = { 0xDE, 0xAD, 0xBE, 0xEF, 0xFE, 0xED };
IPAddress server_addr(192,168,1,4); // IP of the MySQL server here char user[] = "user1"; char password[] = "pass1";
// WiFi card example char ssid[] = "mysid"; // your network SSID (name) char pass[] = "password"; // your network password
//WiFiClient client; // Use this for WiFi instead of EthernetClient WiFiEspClient client; //Use this for ESP8266 MySQL_Connection conn((Client *)&client);
void setup() { Serial.begin(115200); while (!Serial); // wait for serial port to connect. Needed for Leonardo only // initialize serial for ESP module Serial.println("Starting...."); Serial1.begin(9600); // initialize ESP module WiFi.init(&Serial1); Serial.println("Connecting to WiFi");
// Begin WiFi section int status = WiFi.begin(ssid, pass); if ( status != WL_CONNECTED) { Serial.println("Couldn't get a wifi connection"); while(true); } // print out info about the connection: else { Serial.println("Connected to network"); IPAddress ip = WiFi.localIP(); Serial.print("My IP address is: "); Serial.println(ip); } // End WiFi section
Serial.println("Connecting..."); if (conn.connect(server_addr,3306,user,password)) { delay(1000); } else Serial.println("Connection failed."); conn.close(); }
void loop() { } `