//uint8_t mac[] = {0x00, 0x00, 0xCC, 0xBB, 0xAA, 0xEE};  // Change MAC
uint8_t mac[] = {0xEE, 0xAA, 0xBB, 0xCC, 0x00, 0x02};  // Physical Address MAC
// WIFI
#include <ESP8266WiFi.h>
#include <WiFiClient.h>

char ssid[] = "@RMUTI-One-IoT";
char pass[] = "IotRMUTI1";

// MySQL
#include <MySQL_Connection.h>
#include <MySQL_Cursor.h>

IPAddress server_addr(172, 17, 15, 140);  // ping db-cluster.rmuti.ac.th 
char user[] = "db_eeiot";
char password[] = "@db_eeiot*";

WiFiClient client;
MySQL_Connection conn((Client *)&client);

void setup() {
  delay(1000);

  Serial.begin(9600);
  Serial.print("Connecting to ");
  Serial.println(ssid);

  wifi_set_macaddr(STATION_IF, &mac[0]);  // set MAC

  WiFi.begin(ssid, pass);
  while (WiFi.status() != WL_CONNECTED) {
    delay(200);
    Serial.print(".");
  }
   
  WiFi.macAddress(mac);
  Serial.println("");
  Serial.print("MAC: ");
  Serial.print(mac[5], HEX);
  Serial.print(":");
  Serial.print(mac[4], HEX);
  Serial.print(":");
  Serial.print(mac[3], HEX);
  Serial.print(":");
  Serial.print(mac[2], HEX);
  Serial.print(":");
  Serial.print(mac[1], HEX);
  Serial.print(":");
  Serial.println(mac[0], HEX);
  Serial.println("");
  Serial.print("Assigned IP: ");
  Serial.print(WiFi.localIP());
  Serial.println("");
  Serial.println("Connecting to database");
  while (conn.connect(server_addr, 3306, user, password) != true) {
    delay(200);
    Serial.print ( "." );
  }
  delay(1000);

}
void loop() {
  delay(1000); // more than 1000
}