Mysql database in DHCP sever issues

Question

Hi all I am using MySQL as my application database in a local network applications. And in connection string I used IP address instead of computer-name. And the last three years everything worked very well without any errors but recently we changed our sever as a DHCP sever. From that point I am getting many connection errors as MySQL host not responding connection failed etc. I just want to know can I have any benefits if I use computer name/server name in application connections string instead of IP Address?. As I am a newbie please help me to distinguish between using IP address and computer name in connection strings. -Thanks in advance

Nitin Sontakke · Answer

In IT the only thing that is constantis change. So start getting used to it. Whether you use IP or computer name both will change when your deployment environment changes. So if your IP is changing dynamically you can use computer name instead. Even if DHCP is configured I believe you can still have a static ip for your computer by changing few settings. In any case keep connection string separate from application code so as to modify them without compilation.