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

The Geek is the founder of How-To Geek and a geek enthusiast. This article was written on 09/11/06 and tagged with: MySQL

Daily Email Updates

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

Similar Articles	Featured Wiki Articles
Dump just the table structure to a file in MySQL Speed Up Amarok With Large Music Collections Install MySQL Server 4.1 on Ubuntu Install MySQL Server 5 on Ubuntu Track MySQL Queries with mysqlsniffer on Ubuntu	Windows OS Code Names Get Diablo II Working on Windows Vista Why Codec Packs Are Bad Easter Eggs Tweaking a Dedicated Virtual Web Server Disable Smart Quotes in Word 2007
Latest Software Reviews	Quick Linux Tips
Parallels Workstation 2.2 for Windows and Linux Folder Castle 4.1 Wondershare PPT2DVD Sothink Video Converter for Adobe Flash	Copy Just the Last Two Days of Files to Another Directory Fixing Authentication refused: bad ownership or modes for directory Mounting a Shared VirtualBox Folder from an Ubuntu Guest Change the Hostname on a Redhat Linux Machine
Geek Arcade	Popular Forum Threads
Frantic Boxhead: The Zombie Wars BubbleQuod Exorbis 2	Anyone with X-FI Series: Will get very little Support from Creative Labs! GRAY Sml First time builder Vista: Boot Manager Problem

If you have a computer help question, click here to leave it on the forums instead.