Web Hosting Geeks | Web Hosting Experts
Need help? Call us 1(866)TOP-HOST

14625 reviews 1734 hosting providers

Questions & Answers

MySQL automatically detect IP address

Mar 22, 2012 by DinoGuy
hi guys,
Is there a way to have MySQL automatically detect the IP address of the machine it's on and set the "bind-address" configuration variable itself? This is a small home server using DHCP that's used periodically and I really don't want to go through setting up static IP addresses. Does anyone know how to do this?

thanks

1 Answer

0 votes
Mar 22, 2012 by SmartHost
Hey Dino

set the IP  'bind-address = 0.0.0.0' and it will bind to what ever it can.