TCP/IP connections in Fedora 14

[lucadiote]

I just installed Fedora 14 in a hard disk of my PC. I installed MySQL also. I dontīt know if this is the correct site for my question, but nobody MySQL related, have an answer yet. For MySQL accepting remote connections, my.cnf file must be edited (bind-address line or skip-networking line in that file). Well, that file in my Fedora-MySQL installation does not have such lines, so i assume, TCP/IP connections are allowed in MySQL. When i try to connect to the MySQL server it refuses the connection with the error 2003, that in short, means no TCP/IP connections are allowed. I disabled the firewall and retried but with no success, enabled the firewall again, and nothing happen. Is Fedora not accepting TCP/IP connections?

Can anybody suggest me any action?. Thanks a lot, and sorry for my english.

[Irithori]

is it started?
ps auwx |grep sql

does it listen?
netstat -tunlp |grep sql

[lucadiote]

Thank you for your answer. Yes the MySQL server is up and listening at the 3306 port.

[Irithori]

ok, so can you telnet to 127.0.0.1 3306?
and if that works
mysql -h 127.0.0.1 -u <user> -p

[lucadiote]

Yes it was possible to connect to MySQL .

This was the result of netstat -tunlp |grep sql

tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 1393/mysqld

The commands were run in two ways:

1) At a local terminal
2) At a remote ssh session

With the same results

With telnet 127.0.0.1 3306 the result was:

Trying 127.0.0.1...
Connected to 127.0.0.1.
Escape character is '^]'.
4
5.1.52T2?$5!AU]TnKkY\Br;k

And hitting Enter (i.e.):

Connection closed by foreign host.

[lucadiote]

I solved the problem: i added the port 3306 with the procols udp and tcp to the firewall, and now the remote connections go well. And only root has remote access by now. Thanks a lot