Will be connecting to express.js/Node.js & Esp8266 (Wemos D1 R2 on Arduino IDE)
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
You should be able to record this data from the same IP address. This library will help with the MQTT protocol.
Since mqtt and MySQL use different ports, using the local mqtt service should not be any different from connections with a remote device.