Cannot connect to remote MySQL server

ondravirag

New Member
Joined
Jan 22, 2022
Messages
1
Reaction score
0
Credits
13
Hello guys,

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


If i try from VPS:
Code:
nmap -p 3306 remote_mysql.ip.com
Output is:
PORT STATE SERVICE
3306/tcp filtered mysql


if try:
Code:
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:
Code:
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
Code:
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 ?
 
$100 Digital Ocean Credit
Get a free VM to test out Linux!

Members online


Latest posts

Top