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 SontakkePosted Jul 20, 2016, 2:42 AM
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.