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

Don't show again X

Subscribe

Daily Email Updates

You can get our how-to articles in your inbox each day for free. Just enter your email below:


Email:

Comments are closed on this post.

If you'd like to continue the discussion on this topic, you can do so at our forum.


Go to the Forum