....port3306 ??

[parul]

Hello all of you,
I installed MySQL-4.1.13 on a Sun Solaris 5.8 machine by using package. But the port 3306 is not working. When I run netstat -a | grep 3306, there is no such port listening. But when I run netstat -an | grep 3306, it appears.

There was no my.cnf configuration file on the entire machine. So, copied my-large.cnf file as my.cnf to /etc from /usr/local/share/mysql. The files that appear in /usr/local/share/mysql are:

my-huge.cnf
my-innodb-heavy-4G.cnf
my-large.cnf
my-medium.cnf
my-small.cnf

Changing the port in my.cnf to 3307, it appears as listening when I run
netstat -a | grep 3307. But changing back to 3306 there is no port listening.
It cause a problem when we try to connect from other machines by using the following:
telnet <ip-address> 3306
Can somebody help to fix this problem? -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[evy]

The -n option of netstat displays open ports by their numeric assignments rather than their human readable alias. Make sure that mysqld is using the correct my.cnf file. In my.cnf, check the port to use configured under the mysqld section and make sure of not having the skip-networking variable enabled. 3306 should not be firewalled. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --