SEARCH

How-To Geek

Switch MySQL to listen on TCP

By default, MySQL only allows connections from the localhost address. The configuration file is usually found in /etc/mysql/my.cnf

You will want to comment out the bind-address line by making it look like this:

#bind-address     = 127.0.0.1

Next, you will need to restart the database server:

sudo /etc/init.d/mysql restart

Lowell Heddings, better known online as the How-To Geek, spends all his free time bringing you fresh geekery on a daily basis. You can follow him on if you'd like.

  • Published 09/11/06

Enter Your Email Here to Get Access for Free:

Go check your email!