Choosing DNS Servers

Every once in a while (it doesn’t happen very often) DNS servers would stop resolving certain domains causing intermittent issues when accessing the Internet. To solve the DNS issues, I often switch DNS servers on my main router. Changing DNS servers may require rebooting your router.

So, here’s a list of DNS servers you could use on your router, in case the current DNS servers you are using is having problems. I primarily use OpenDNS and Google DNS servers, but others DNS servers are reliable as well.

OpenDNS Primary Secondary

Google Primary Secondary

Comcast Primary Secondary

AT&T DSL Primary Secondary

UltraDNS Primary Secondary

ScrubIt Primary Secondary

DNSResolvers Primary Secondary

Can’t Connect To MySQL Server

I recently had a problem with an Ubuntu server that was running MySQL. None of my applications were connecting to the database. After poking around in the server, I realized the database doesn’t seem to be running at all. I tried restarting it from the Terminal, but I ran into this error message.

ERROR 2003 (HY000): Can't connect to MySQL server on '' (111)

As it turns out, the Ubuntu server picked up a new IP address of from the last reboot. I went ahead and assigned a static IP address to the server of I should have done it initially when I setup the server. If you need help setting up a static IP address on the Ubuntu server, here are the instructions on how to set Ubuntu server to static IP address.

I looked at the MySQL configuration file called /etc/mysql/my.cnf, the bind-address was manually set to the old IP address of So, edited the file and entered the new IP address of

bind-address =

Finally, I restarted the network as well as started the MySQL server.

sudo /etc/init.d/networking restart
sudo /etc/init.d/mysql start

Everything is hunky dory again.