[问题]系统时间改了，mysql启动失败

农村干部

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)


出现这个错误，咋弄？谢谢

yueliangdao0608

把错误日志贴出来看看

农村干部

/var/run/mysqld/mysqld.sock
这个文件没有了
系统日志里边说连不上3306这个端口

农村干部

May  5 07:53:24 ubuntu mysqld[3831]: 080505  7:53:24 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested
address
May  5 07:53:24 ubuntu mysqld[3831]: 080505  7:53:24 [ERROR] Do you already have another mysqld server running on port: 3306 ?
May  5 07:53:24 ubuntu mysqld[3831]: 080505  7:53:24 [ERROR] Aborting
May  5 07:53:24 ubuntu mysqld[3831]:
May  5 07:53:24 ubuntu mysqld[3831]: 080505  7:53:24  InnoDB: Starting shutdown...
May  5 07:53:26 ubuntu mysqld[3831]: 080505  7:53:26  InnoDB: Shutdown completed; log sequence number 0 43655
May  5 07:53:27 ubuntu mysqld[3831]: 080505  7:53:27 [Note] /usr/sbin/mysqld: Shutdown complete
May  5 07:53:27 ubuntu mysqld[3831]:
May  5 07:53:27 ubuntu mysqld_safe[3861]: ended
May  5 07:53:32 ubuntu ntpdate[2464]: can't find host ntp.ubuntu.com
May  5 07:53:32 ubuntu ntpdate[2464]: no servers can be used, exiting
May  5 07:53:39 ubuntu /etc/init.d/mysql[3991]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.c
nf ping' resulted in
May  5 07:53:39 ubuntu /etc/init.d/mysql[3991]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
May  5 07:53:39 ubuntu /etc/init.d/mysql[3991]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/my
sqld.sock' (2)'
May  5 07:53:39 ubuntu /etc/init.d/mysql[3991]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock
' exists!
May  5 07:53:39 ubuntu /etc/init.d/mysql[3991]:

yueliangdao0608

你用

netstat -anp | grep 3306

看一下哪个程序占用了3306端口。

农村干部

没有，没有占用3306端口的

yueliangdao0608

你是不是在配置文件里面
bind-address了

May  5 07:53:24 ubuntu mysqld[3831]: 080505  7:53:24 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested
address

sunnyfun

确认 /var/run/mysqld/ 权限没变过吗

农村干部

没有动过权限，只是改了系统时间么的

bind-address指定过，但是指导以后用的好好的，一点问题没有

yueliangdao0608

你应该仔细尝试一下LS各位的意见那