mysql - 现在改了ip无法启动MySql

Question

我有一个公共(public)虚拟机，我不得不更改 IP 地址，现在我无法启动 MySql。

事件查看器显示这些消息:

Server hostname (bind-address): 'xxx.xxx.xxx.249'; port: 3306

然后我得到这 3 个错误:

Can't start server: Bind on TCP/IP port: No such file or directory

Do you already have another mysqld server running on port: 3306 ?

Faulting application name: mysqld.exe, version: 5.5.42.0, time stamp: 0x54ac4a9a
Faulting module name: mysqld.exe, version: 5.5.42.0, time stamp: 0x54ac4a9a
Exception code: 0x80000003
Fault offset: 0x000000000021fac2
Faulting process id: 0x23cc
Faulting application start time: 0x01d0c7f3f4d0a87d
Faulting application path: C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld.exe
Faulting module path: C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld.exe
Report Id: 3b931dcc-33e7-11e5-80dd-00155dbffa04
Faulting package full name: 
Faulting package-relative application ID:

我注意到在 my.ini 中它的客户端和服务器绑定(bind)到 3306:

[client]

port=3306

[mysql]

default-character-set=utf8

# SERVER SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by the MySQL Server. Make sure that
# you have installed the server correctly (see above) so it reads this 
# file.
#
[mysqld]

# The TCP/IP Port the MySQL Server will listen on
port=3306

我不确定这是否正确，但我没有更改它。

我确实执行了 netstat -an 但我没有在端口 3306 上显示任何内容。

我已重新启动服务器以验证它尚未解决。

我还应该检查什么？我不认为更改 IP 地址会对 MySql 产生如此大的影响。

有人有什么建议吗？

Answer 1

我在这里找到了答案:

https://serverfault.com/questions/35637/mysql-dying-on-startup

这就是我所做的，它对以后有需要的人有用:

I had this error after running out of harddisk space. I finally solved it by deleting ib*.tmp files from C:\Windows\temp which were causing the startup to fail, even for data directories that were previously working.

如果找不到临时目录，显示隐藏文件夹。