Hi,

I have MySQL on a Slackware 10.2 server but it does not listen on port 3306.

In my "my.cnf", port=3306 and "skip-networking" is not there

when I try "netstat -atn" 3306 is not there.

If y try "netstat -an | grep 3306" nothing

MySQL is running fine whit my local PHP script but not with some java application that need port 3306 to listen to gain acces to database.

I have search on the web all night and cannot find something !! everybody that have this trouble is because of "skip-networking" !!

Someone know what can I try...

Thanks,

Franck

I've finally found that if I connecto to mysql (mysql -p -u root)

and type in "SHOW VARIABLES;"

skip_networking = ON

If I type:

mysql > SET GLOBAL skip_networking = Off;

It tell me: unknown system variable 'skip_networking'

Why !!

If I type: mysql> SHOW VARIABLES LIKE 'skip_networking';

It respond me: skip_networking = On

does I misstype something ?

Put in the [mysqld] section of your my.cnf.

already there...

My issue now is really that I don't find how to modify the skip_networking variable in mysql.

I've try 2 things:

mysql> SET GLOBAL skip_networking=off;

and

mysql> SET @@global.skip_networking=off;

In the 2 case, mysql reply:

ERROR 1193 (HY000): Unknown system variable 'skip_networking'

skip_networking is a command line option. Take a look at your mysql server startup script to see if it starts with --skip_networking

ok, so the mysql startup script, you mean de rc.mysqld ?

I've look in it and don't sea --skip-networking.

In my my.cnf, i've try different things.

First pus a "#skip-networking" or "#skip_networking" or "#--skip-networking" but this don't turn off the skip-networking.

I've also try these:

skip-networking=off
skip_networking=off
set-variable=skip-networking=off
set-variable=skip_networking=off

but in those case, mysql won't start at all !

Yes ! get it !!

I was not lokking at the right place in my rc.mysqld !

I've found this line:

SKIP="--skip-networking"

Just comment it to have:

#SKIP="--skip-networking"

restart mysql and 3306 is listening !

Thanks bathory !

hope it will help people around that have the same problem !

bye

I just had the same problem with Mandriva 2006. I searched for hours and came across this thread. It solved my problem too. Thanks for posting guys!

it really helps.
I can connect my mysql server now.
thanks.

I had the same problem with Mandriva 2005 Limited Edition, and searched in /etc/init.d/mysqld, but I haven't found such parameter there.

Actually, "ps ax" shows, mysql is truly started with that parameter --skip-networking, so I was investigating further and finally found it.

In this distro, there is another config file for mysql (except for the well-known /etc/my.cnf).
Be sure to look for:

/etc/sysconfig/mysqld

and there is that pesky little line:
MYSQLD_OPTIONS="--skip-networking"

I hope this really helps those folks with Mandriva 2005 LE )

Thanks jramen for the hint on Mandriva 2005 LE!

I was already searching a while with no luck. Saved me a lot more time!

Great!

Hi All - hoping for a little guidance,

I've confirmed skip_networking is OFF:

mysql> SHOW VARIABLES LIKE 'skip_networking';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| skip_networking | OFF |
+-----------------+-------+

and, port 3306 is definitely appears in /etc/my.cnf

My only guess is iptables but as far as I can tell, all ports are accepted.

Here is my iptables -L :

Chain INPUT (policy ACCEPT)
target prot opt source destination
DROP all -- anywhere anywhere state INVALID
ACCEPT all -- anywhere anywhere state RELATED,ESTABLISHED
ACCEPT all -- anywhere anywhere
ACCEPT icmp -- anywhere anywhere
ACCEPT tcp -- anywhere anywhere tcp dpt:http
ACCEPT tcp -- anywhere anywhere tcp dpt:https
ACCEPT tcp -- anywhere anywhere tcp dpt:ssh
DROP tcp -- anywhere anywhere tcp dpts:tcpmux:65535
DROP udp -- anywhere anywhere udp dpts:tcpmux:65535
ACCEPT tcp -- anywhere anywhere tcp dpt:mysql

Chain FORWARD (policy ACCEPT)
target prot opt source destination

Chain OUTPUT (policy ACCEPT)
target prot opt source destination

Is it my iptables blocking access? Is there an entry that I can make to open port 3306?

Thanks in advance, Rein

I had the same problem in ubuntu, and went to edit the same file.
now in ubuntu it looks a bit different than skip-networking. This is how it looks:

# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = 127.0.0.1

so I replaced bind-address localhost ip with the right ip, mysql restart and that was it.
woulndt be for this post I wouldnt have found that...
thanks guys