Cannot connect to remote MySQL server

[ondravirag]

Hello guys,

i have problem with mysql remote connect.
On remote VPS with mysql in my.cnf have:

bind-address = 0.0.0.0 and #skip-networking.

In users in phpmyadmin mysql have special user:

remote@%

And still not working.


If i try from VPS:

nmap -p 3306 remote_mysql.ip.com

Output is:

PORT STATE SERVICE
3306/tcp filtered mysql

if try:

mysql -u remote -h remote_mysql.ip.com -p

Output is:

ERROR 2002 (HY000): Can't connect to MySQL server on 'remote_mysql.ip.com' (115)

On server with MYSQL cmd:

netstat -pnlt|grep mysql

Output is:

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

On server with MYSQL cmd: s

udo lsof -i -P -n | grep LISTEN

Output is:

sshd 798 root 3u IPv4 16467 0t0 TCP *:22 (LISTEN)
sshd 798 root 4u IPv6 16469 0t0 TCP *:22 (LISTEN)
checkstat 802 root 7u IPv4 15190 0t0 TCP *:44086 (LISTEN)
sendmail 888 root 4u IPv4 16568 0t0 TCP 127.0.0.1:25 (LISTEN)
nginx 4870 root 6u IPv4 31245 0t0 TCP *:4084 (LISTEN)
nginx 4870 root 7u IPv4 31246 0t0 TCP *:4085 (LISTEN)
nginx 4870 root 8u IPv4 31247 0t0 TCP *:4082 (LISTEN)
nginx 4870 root 9u IPv4 31248 0t0 TCP *:4083 (LISTEN)
nginx 4871 emps 6u IPv4 31245 0t0 TCP *:4084 (LISTEN)
nginx 4871 emps 7u IPv4 31246 0t0 TCP *:4085 (LISTEN)
nginx 4871 emps 8u IPv4 31247 0t0 TCP *:4082 (LISTEN)
nginx 4871 emps 9u IPv4 31248 0t0 TCP *:4083 (LISTEN)
mysqld 5246 mysql 11u IPv4 28242 0t0 TCP *:3306 (LISTEN)

Thanks, it is way ?