working env started giving - cannot connect to mysql server (10060)

Have a standard mysql installation in linode machine.

The mysql connection was working for years. Yesterday it started throwing the connection failure error 10060.

No changes happened in the server in these two days

Now I am able to login to linode machine, login to mysql and see the tables. Only the remote login fails.

Upon googling, I checked "bind" It is commented in the cnf file

Would like to know why sudden issue with connection? Can someone tamper the system?
How to fix the issue?

Here is the netstate result.

netstat -l
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State
tcp 0 0 *:ssh *:* LISTEN
tcp6 0 0 [::]:mysql [::]:* LISTEN
tcp6 0 0 [::]:http [::]:* LISTEN
tcp6 0 0 [::]:ssh [::]:* LISTEN
tcp6 0 0 [::]:https [::]:* LISTEN
tcp6 0 0 [::]:9020 [::]:* LISTEN
Active UNIX domain sockets (only servers)
Proto RefCnt Flags Type State I-Node Path
unix 2 [ ACC ] STREAM LISTENING 11302685 /var/run/mysqld/mysqld.sock
unix 2 [ ACC ] STREAM LISTENING 5855276 /run/systemd/private
unix 2 [ ACC ] STREAM LISTENING 1281189 /run/user/1000/systemd/private
unix 2 [ ACC ] STREAM LISTENING 9948 /run/systemd/journal/stdout
unix 2 [ ACC ] SEQPACKET LISTENING 9954 /run/udev/control
unix 2 [ ACC ] STREAM LISTENING 14051 /var/run/dbus/system_bus_socket
unix 2 [ ACC ] STREAM LISTENING 14061 /run/uuidd/request
unix 2 [ ACC ] STREAM LISTENING 9966 /run/systemd/fsck.progress


2 Replies

It sounds like this may be related to a firewall issue for your server. Have you had the chance to review these for your server? We have a few guides that you can reference in regards to reviewing your server's firewall rules:

I've used this link when I setup MySQL remote access for my personal server.

As for your server possibly being compromised, I would check the log files for your server, as well as the login dates and timestamps for the accounts on your server. The following commands will assist with this.

cat /var/log/auth.log
cat /var/log/secure

I also suggest installing and running a security auditing tool called Lynis for your server. This tool scans your server for security vulnerabilities and offers suggestions on how to rectify them. You can reference our guide in regards to securing your server.

Thanks a lot to your detailed answer.

I followed the ufw config page.
Ran this cmd

sudo ufw allow 3306

Now everything is working good. :-)


Please enter an answer

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct