How do I allow mysql connections over network (netstat -an

jdruin · 07-04-2004, 03:26 PM

How do I allow mysql connections over network ? I did a

netstat -an | grep 3306

and got nothing. I think this means mysql is not listening to external connections but I am not sure. Also how do I check to see which connections mysql is listening on. For example, canI use netstat to see if mysql is listening on localhost? THe bigger problem is how do I tell mysql to listen for connections from my network?

david_ross · 07-04-2004, 03:44 PM

Try creating a section like the following in /etc/my.cnf (or just add the port option if the mysqld section exists):

Quote:

[mysqld]
port = 3306

Also make sure that there is no "skip-networking" option.

jdruin · 07-05-2004, 02:48 AM

Thanks david_ross. You gave me the push I needed.

For those reading for solution:

What I did is found the my.cnf in /etc/mysql/my.cnf and opened it after installing nano editor. Here are the steps:

I got nano (my favorite editor) from www.nano-editor.org/ for Debian ( I am using Xandros)

I loaded nano using dpkg -i nano*

I commented out a line in my.cnf that reads "skip-networking" about 47 lines into file.