ChuckBell
commented
3 years ago You must use the IP address of your MySQL server, not the loop back address.
On Nov 4, 2020, at 21:14, luckydalanzhu notifications@github.com wrote:
include
include
byte mac_addr[] = { 0xDE, 0xAD, 0xBE, 0xEF, 0xFE, 0xED };
I only chang two field,ip address and password. When I upload is complete, in the serial port monitor show "Connection failed." Mysql password is correct, I verified it with the Navicat for MySQL. php and mysql environment is powered by xampp.
IPAddress server_addr(127,0,0,1); // IP of the MySQL server here char user[] = "root"; // MySQL user login username char password[] = "password"; // MySQL user login password
EthernetClient client; MySQL_Connection conn((Client *)&client);
void setup() { Serial.begin(115200); while (!Serial); // wait for serial port to connect Ethernet.begin(mac_addr); Serial.println("Connecting..."); if (conn.connect(server_addr, 3306, user, password)) { delay(1000); // You would add your code here to run a query once on startup. } 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, or unsubscribe.
luckydalanzhu
include
include
byte mac_addr[] = { 0xDE, 0xAD, 0xBE, 0xEF, 0xFE, 0xED };
I only chang two field,ip address and password. When I upload is complete, in the serial port monitor show "Connection failed." Mysql password is correct, I verified it with the Navicat for MySQL. php and mysql environment is powered by xampp.
IPAddress server_addr(127,0,0,1); // IP of the MySQL server here char user[] = "root"; // MySQL user login username char password[] = "password"; // MySQL user login password
EthernetClient client; MySQL_Connection conn((Client *)&client);
void setup() { Serial.begin(115200); while (!Serial); // wait for serial port to connect Ethernet.begin(mac_addr); Serial.println("Connecting..."); if (conn.connect(server_addr, 3306, user, password)) { delay(1000); // You would add your code here to run a query once on startup. } else Serial.println("Connection failed."); conn.close(); }
void loop() { }