How do I use MySQL with a localhost IP?

EasyBuilder Pro Q&A
How do I use MySQL with a localhost IP?
none 0.0 0
1
  • HMI Model: CMT3162x (V2)
  • EasyBuilder Pro Version:v6.08.02.449
  • Serial Number or supplier: 2307407001
    I have created a generic database, in My SQL, I configured the DataBase Server and SQL QUERY object and SQL Query Result Viewer, and everything works correctly, but when I load the program to the physical computer, it cannot load the database, this Is it due to the IP address of the server or something else, the localhost address used is 127.0.0.1 and the IP address used to download and upload the program to the HMI and from the PC is another
1 Like
2

Hi @rescobar,

Is the MySQL server running on your PC? If so, you will need to reconfigure the IP address within the “Database Server” object to target your PC’s IP address prior to download. Then, the HMI must be connected to your PC (server) via Ethernet in order to execute SQL queries.

Note: The IP 127.0.0.1 is referred to as the “loopback” IP. When a network application or service on a device sends data to the loopback address, it is essentially sending the data to itself.

3

I think my problem is mainly creating the server on my computer using my own local IP, I will continue investigating to see what I am missing, thank you very much for your help, greetings

4

@rescobar,

Certainly and if you have any additional questions related to this topic, please let us know.