我正在使用 Google 云,并部署了几个实例。
我试图解决服务器上 MySQL 数据库的问题,但无法启动 MySQL,因此我只能重新启动实例。
我注意到,当它重新启动时,外部 IP 地址似乎已经改变,因此我将其从临时 IP 地址更改为静态 IP 地址,因为该实例用于托管网站。
我现在无法通过 SSH 连接到服务器 - 我在日志中收到此信息:
Mar 4 17:24:09 puntcambridge-puntcambridge-ippn sshd[3419]: Invalid user faina from 184.173.54.130
Mar 4 17:24:09 puntcambridge-puntcambridge-ippn sshd[3419]: input_userauth_request: invalid user faina [preauth]
Mar 4 17:24:10 puntcambridge-puntcambridge-ippn sshd[3419]: Received disconnect from 184.173.54.130: 11: Bye Bye [preauth]
Mar 4 17:24:16 puntcambridge-puntcambridge-ippn sshd[3421]: Connection closed by 173.194.92.32 [preauth]
Mar 4 17:24:29 puntcambridge-puntcambridge-ippn sshd[3423]: Connection closed by 173.194.92.35 [preauth]
Mar 4 17:24:44 puntcambridge-puntcambridge-ippn sshd[3425]: Connection closed by 173.194.92.35 [preauth]
Mar 4 17:24:47 puntcambridge-puntcambridge-ippn collectd[2527]: mysql plugin: Failed to connect to database <none> at server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)
Mar 4 17:24:47 puntcambridge-puntcambridge-ippn collectd[2527]: read-function of plugin `mysql-wpdatabase' failed. Will suspend it for 960.000 seconds.
Mar 4 17:25:08 puntcambridge-puntcambridge-ippn sshd[3436]: Connection closed by 173.194.92.34 [preauth]
Mar 4 17:25:46 puntcambridge-puntcambridge-ippn sshd[3439]: Connection closed by 173.194.92.36 [preauth]
Mar 4 17:25:47 puntcambridge-puntcambridge-ippn sshd[3440]: Connection closed by 173.194.92.33 [preauth]
Mar 4 17:26:57 puntcambridge-puntcambridge-ippn sshd[3453]: Connection closed by 173.194.92.36 [preauth]
Mar 4 17:27:09 puntcambridge-puntcambridge-ippn sshd[3464]: Connection closed by 173.194.92.32 [preauth]
Mar 4 17:27:47 puntcambridge-puntcambridge-ippn sshd[3467]: Invalid user faina from 184.173.54.130
Mar 4 17:27:47 puntcambridge-puntcambridge-ippn sshd[3467]: input_userauth_request: invalid user faina [preauth]
Mar 4 17:27:47 puntcambridge-puntcambridge-ippn sshd[3467]: Received disconnect from 184.173.54.130: 11: Bye Bye [preauth]
Mar 4 17:29:10 puntcambridge-puntcambridge-ippn sshd[3479]: Connection closed by 173.194.92.35 [preauth]
Mar 4 17:30:24 puntcambridge-puntcambridge-ippn sshd[3491]: Connection closed by 173.194.92.36 [preauth]
Mar 4 17:31:24 puntcambridge-puntcambridge-ippn sshd[3503]: Invalid user faina from 184.173.54.130
Mar 4 17:31:24 puntcambridge-puntcambridge-ippn sshd[3503]: input_userauth_request: invalid user faina [preauth]
Mar 4 17:31:24 puntcambridge-puntcambridge-ippn sshd[3503]: Received disconnect from 184.173.54.130: 11: Bye Bye [preauth]
Mar 4 17:32:12 puntcambridge-puntcambridge-ippn sshd[3515]: Connection closed by 74.125.17.96 [preauth]
Mar 4 17:32:21 puntcambridge-puntcambridge-ippn sshd[3517]: Connection closed by 74.125.73.36 [preauth]
Mar 4 17:32:23 puntcambridge-puntcambridge-ippn sshd[3519]: Connection closed by 74.125.73.100 [preauth]
Mar 4 17:32:35 puntcambridge-puntcambridge-ippn sshd[3521]: Connection closed by 74.125.17.33 [preauth]
Mar 4 17:32:45 puntcambridge-puntcambridge-ippn sshd[3532]: Connection closed by 74.125.73.99 [preauth]
Mar 4 17:32:58 puntcambridge-puntcambridge-ippn sshd[3535]: Connection closed by 74.125.73.98 [preauth]
Mar 4 17:33:12 puntcambridge-puntcambridge-ippn sshd[3537]: Connection closed by 74.125.47.161 [preauth]
Mar 4 17:33:55 puntcambridge-puntcambridge-ippn sshd[3548]: Connection closed by 74.125.73.163 [preauth]
Mar 4 17:34:02 puntcambridge-puntcambridge-ippn sshd[3551]: Connection closed by 74.125.17.32 [preauth]
Mar 4 17:34:10 puntcambridge-puntcambridge-ippn sshd[3553]: Connection closed by 74.125.17.99 [preauth]
Mar 4 17:34:19 puntcambridge-puntcambridge-ippn sshd[3555]: Connection closed by 74.125.73.33 [preauth]
Mar 4 17:34:31 puntcambridge-puntcambridge-ippn sshd[3557]: Connection closed by 74.125.73.98 [preauth]
SSH 客户端总是超时。我对此有点不知所措,不知道从哪里开始解决这个问题,所以任何正确的方向的指示都将不胜感激。
很高兴提供任何有帮助的附加信息。
谢谢,
答案1
社区维基帖子:
原始发帖人找到的解决方案是重新创建一个新用户,以便重新登录他的 MySQL 服务器。恢复实例时,可能存储了一组更改后的原始用户凭据,并导致错误。