MySQL服务器突然不能启动,查看最后的启动日志如下:

  080825 09:38:04 mysqld started
080825 9:38:04 [ERROR] Can't start server : Bind on unix socket: Permission denied
080825 9:38:04 [ERROR] Do you already have another mysqld server running on socket: /var/mysql.sock ?
080825 9:38:04 [ERROR] Aborting

  080825 9:38:04 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

  080825 09:38:04 mysqld ended

  f 配置如下:
[mysqld]
datadir=/usr/local/mysql/data
socket=/var/mysql.sock

  [mysql]
socket=/tmp/mysql.sock
[mysql.server]
user=mysql
basedir=/usr/local/mysql

  [safe_mysqld]
err-log=/usr/local/mysql/mysqld.log
pid-file=/usr/local/mysql/mysqld.pid

数据库,提示错误,连接不到数据库服务器, /tmp目录下没有mysql.sock这个文件,到这里,基本清楚了Mysql客户端和服务器端在本机的通信方式了,通过一个名为mysql.sock 文件来进行初始化通信的,因此该文件所存放的目录必须双方都有权限可以访问到,而且服务器在启动时需要写该文件,如果f中这两项配置不正确,就 会出现Permission denied等类似错误。将配置文件修改如下,就没有问题了。

  [mysqld]datadir=/usr/local/mysql/datasocket=/tmp/mysql.sock

  [mysql]socket=/tmp/mysql.sock[mysql.server]user=mysqlbasedir=/usr/local/mysql

  [safe_mysqld]err-log=/usr/local/mysql/mysqld.logpid-file=/usr/local/mysql/mysqld.pid如果还是不行,那就需要 chmod  777   /tmp