MySQL Forums
Forum List  »  Install & Repo

mysql not listening on 3306 port
Posted by: Chadwick Hung
Date: December 13, 2014 02:25AM

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

Options: ReplyQuote


Subject
Written By
Posted
mysql not listening on 3306 port
December 13, 2014 02:25AM


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.