mysql not listening on 3306 port
Pleas help. I can't connect my mysql remotely but only from console.
I checked skip-networking is off. MYSQLD is running my port 3306. I've flush the iptables by -F
and restarted the mysqld many times. Still the netstat shows me 3306 is still not being listening. (but I can see tcp6).
I also tried iptables -F to flush firewall and restart mysqld it's the same
Please kindly advise.
netstat -ntlp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 127.0.0.1:25 0.0.0.0:* LISTEN 2873/master
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 1588/sshd
tcp6 0 0 ::1:25 :::* LISTEN 2873/master
tcp6 0 0 :::3306 :::* LISTEN 29817/mysqld
tcp6 0 0 :::22 :::* LISTEN 1588/sshd
netstat --ip -a
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State
tcp 0 0 localhost:smtp 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:ssh 0.0.0.0:* LISTEN
tcp 0 0 80.134.52.113.stati:ssh tswc3022.netvigato:7185 ESTABLISHED
tcp 0 0 localhost:38376 localhost:mysql TIME_WAIT
tcp 0 0 80.134.52.113.stati:ssh 122.225.109:boosterware TIME_WAIT
ps -ef|grep mysql
mysql-dr 29817 29334 0 15:58 pts/0 00:00:01 /usr/local/mysql56/bin/mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql56 --datadir=/var/lib/mysql-dr --plugin-dir=/usr/local/mysql56/lib/plugin --user=mysql-dr --log-error=/var/log/mysqld-dr.log --pid-file=/tmp/mysqld-dr.pid --socket=/var/lib/mysql-dr/mysql-dr.sock --port=3306
Thanks
Chadwick
Subject
Written By
Posted
mysql not listening on 3306 port
December 13, 2014 02:25AM
February 20, 2015 06:13PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.