Moving MySQL to another server without updating connection strings Currently, I have a Windows 2008 R2 Server which runs both all my websites and all my MySQL databases.  I am considering moving MySQL to another seperate server which may also be Windows or may be Linux.  My question is, if I do this, and MySQL is then on a different IP address, is there anyway of aliasing the IP address of the new MySQL server from the current server hosting the websites so I do not have to go through and update every single connection string?

Thanks.
If you use "localhost" in connection string then the following may work:

edit hosts file and change the line

127.0.0.1   localhost


to

X.X.X.X localhost //( your new ip)


and restart the local application machine.