Mysql remote connect CentOS

Asked Jan 20 '22 at 20:09

Active Jan 20 '22 at 20:09

Viewed 287 times

i have problem with mysql remote connect. In my.cnf have: bind-address = 0.0.0.0 and #skip-networking. In users mysql have special user remote@% And still not working.

If i try: nmap -p 3306 remote.ip.com

Output is:

PORT       STATE      SERVICE
3306/tcp   filtered   mysql

It is way ?

Thanks, Regards.

asked Jan 20 '22 at 20:09

ondravirag

Do you have either `iptables` or `firewalld` blocking the connection? – doneal24 Jan 20 '22 at 20:16
@doneal24 firewalld -- is off, and iptables i add rule – ondravirag Jan 20 '22 at 20:21
1

show us what give ```netstat -pnlt|grep mysql```. If we see a mysql process listening, then you have a firewall issue, otherwise you have a mysql configuration issue. You _need_ to see the port "open" in order to be able to connect to. – dominix Jan 20 '22 at 20:34
1

`filtered` indicates a firewall. – Gerald Schneider Jan 20 '22 at 20:39
You should not open MySQL port to the public internet for security reasons. Use SSH port forwarding instead. – Tero Kilkanen Jan 20 '22 at 22:01
@Dominix netstat -pnlt|grep mysql tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 1577/mysqld – ondravirag Jan 20 '22 at 22:27
you certainly have a firewall issue. Maybe look for nftables based firewall. – dominix Jan 21 '22 at 06:04
1

The firewall does not necessarily have to be on the host itself. – Gerald Schneider Jan 21 '22 at 11:23
@vidarlo OP's post on Ask Ubuntu is closed because it's offtopic there. – Thomas Ward Jan 22 '22 at 18:44
Try drawing a network diagram of how users connect to the database. There may be other network devices between them and the server. – shearn89 Feb 01 '22 at 09:37

Mysql remote connect CentOS

0 Answers0