I just setup a new DB server replacing one that has been live for 5+ years. I normally set the db connections in the host file but now that the new server is up I still see some connections to the old server how can I track down where those connections are coming from?
If you log into the old MySQL server and run the following:
You should see a list of all active connections, with the source host in the 3rd column. It should be of the form:
You should get something like this:
So in this example, command
Hope this helps.
You can view same informations explained by vmfarms also using Mysql Administrator (old gui) or Mysql WorkBench, into the section "Server Connections", after you login into the server as root.