mysqld 启动失败！！？

chi7na

我在xp下用vmware虚拟centos5.0；然后手动移动了mysql的数据库目录
并对/etc/my.cnf 文件的中的[mysqld] datadir=/home/ zhangsan/mysql/mysql/ socket=/home/ lib/mysql/mysql/ysql.sock [client] socket = /home/ lib/mysql/mysql.sock 我把/ var/ lib/mysql/ mv到了/home/zhangsan/` mysql/ 下然后我在/sbin/ service mysqld start  结果显示 Timeout error occurred trying to start MySQL Daemon. 启动 MySQL： [失败]  我把一切改回了也是提示上面的错误 这怎么解决？？！/etc/rc.d/init.d/mysqld 的文件要修理那部分？

mxbao

看日志估计能发现点问题把

chi7na

070801 01:01:40  mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
070801  1:01:40  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
070801  1:01:41  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
070801  1:01:41  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
070801  1:01:42  InnoDB: Started; log sequence number 0 0
070801  1:01:42 [ERROR] Can't start server : Bind on unix socket: Permission denied
070801  1:01:42 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
070801  1:01:42 [ERROR] Aborting

070801  1:01:43  InnoDB: Starting shutdown...
070801  1:01:44  InnoDB: Shutdown completed; log sequence number 0 43655
070801  1:01:44 [Note] /usr/libexec/mysqld: Shutdown complete

070801 01:01:44  mysqld ended

070801 01:11:09  mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
070801  1:11:09  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
070801  1:11:10  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
070801  1:11:10  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
070801  1:11:10  InnoDB: Started; log sequence number 0 0
070801  1:11:11 [ERROR] Can't start server : Bind on unix socket: Permission denied
070801  1:11:11 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
070801  1:11:11 [ERROR] Aborting

070801  1:11:11  InnoDB: Starting shutdown...
070801  1:11:12  InnoDB: Shutdown completed; log sequence number 0 43655
070801  1:11:12 [Note] /usr/libexec/mysqld: Shutdown complete

070801 01:11:13  mysqld ended

070801 01:15:51  mysqld started
070801  1:15:52  InnoDB: Started; log sequence number 0 43655
070801  1:15:52 [ERROR] Can't start server : Bind on unix socket: Permission denied
070801  1:15:52 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
070801  1:15:52 [ERROR] Aborting

070801  1:15:52  InnoDB: Starting shutdown...
070801  1:15:54  InnoDB: Shutdown completed; log sequence number 0 43655
070801  1:15:54 [Note] /usr/libexec/mysqld: Shutdown complete

070801 01:15:54  mysqld ended

070801 10:43:55  mysqld started
070801 10:43:57  InnoDB: Started; log sequence number 0 43655
070801 10:43:57 [ERROR] Can't start server : Bind on unix socket: Permission denied
070801 10:43:57 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
070801 10:43:57 [ERROR] Aborting

070801 10:43:57  InnoDB: Starting shutdown...
070801 10:43:59  InnoDB: Shutdown completed; log sequence number 0 43655
070801 10:43:59 [Note] /usr/libexec/mysqld: Shutdown complete

070801 10:44:00  mysqld ended

070801 10:56:54  mysqld started
070801 10:56:54  InnoDB: Started; log sequence number 0 43655
070801 10:56:55 [ERROR] Can't start server : Bind on unix socket: Permission denied
070801 10:56:55 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
070801 10:56:55 [ERROR] Aborting

070801 10:56:55  InnoDB: Starting shutdown...
070801 10:56:57  InnoDB: Shutdown completed; log sequence number 0 43655
070801 10:56:57 [Note] /usr/libexec/mysqld: Shutdown complete

070801 10:56:57  mysqld ended

070801 16:20:28  mysqld started
070801 16:20:30  InnoDB: Started; log sequence number 0 43655
070801 16:20:30 [ERROR] Can't start server : Bind on unix socket: Permission denied
070801 16:20:30 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
070801 16:20:30 [ERROR] Aborting

070801 16:20:30  InnoDB: Starting shutdown...
070801 16:20:32  InnoDB: Shutdown completed; log sequence number 0 43655
070801 16:20:32 [Note] /usr/libexec/mysqld: Shutdown complete

070801 16:20:32  mysqld ended

070801 16:33:25  mysqld started
070801 16:33:26  InnoDB: Started; log sequence number 0 43655
070801 16:33:26 [ERROR] Can't start server : Bind on unix socket: Permission denied
070801 16:33:26 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
070801 16:33:26 [ERROR] Aborting

070801 16:33:26  InnoDB: Starting shutdown...
070801 16:33:28  InnoDB: Shutdown completed; log sequence number 0 43655
070801 16:33:28 [Note] /usr/libexec/mysqld: Shutdown complete

070801 16:33:28  mysqld ended

070801 16:45:14  mysqld started
070801 16:45:16  InnoDB: Started; log sequence number 0 43655
070801 16:45:17 [ERROR] Can't start server : Bind on unix socket: Permission denied
070801 16:45:17 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
070801 16:45:17 [ERROR] Aborting

070801 16:45:17  InnoDB: Starting shutdown...
070801 16:45:19  InnoDB: Shutdown completed; log sequence number 0 43655
070801 16:45:19 [Note] /usr/libexec/mysqld: Shutdown complete

070801 16:45:19  mysqld ended

070801 16:51:34  mysqld started
070801 16:51:38  InnoDB: Started; log sequence number 0 43655
070801 16:51:38 [ERROR] Can't start server : Bind on unix socket: Permission denied
070801 16:51:38 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
070801 16:51:38 [ERROR] Aborting

070801 16:51:38  InnoDB: Starting shutdown...
070801 16:51:40  InnoDB: Shutdown completed; log sequence number 0 43655
070801 16:51:40 [Note] /usr/libexec/mysqld: Shutdown complete

070801 16:51:40  mysqld ended

070801 16:58:44  mysqld started
070801 16:58:46  InnoDB: Started; log sequence number 0 43655
070801 16:58:46 [ERROR] Can't start server : Bind on unix socket: Permission denied
070801 16:58:46 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
070801 16:58:46 [ERROR] Aborting

070801 16:58:47  InnoDB: Starting shutdown...
070801 16:58:48  InnoDB: Shutdown completed; log sequence number 0 43655
070801 16:58:48 [Note] /usr/libexec/mysqld: Shutdown complete

070801 16:58:48  mysqld ended

mxbao

Can't start server : Bind on unix socket: Permission denied
070801  1:01:42 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
看看你的sock把,是不是再这个目录定义的.
还是再tmp/mysql.sock
还有就是以前的sock是不是删除掉了.

SkyBelieve

是不是权限的问题啊。。
070801  1:11:11 [ERROR] Can't start server : Bind on unix socket: Permission denied
070801  1:11:11 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?


为什么要弄的这么复杂啊，你用TAR包安装，把MYSQL安装到一个目录下边。。

chi7na

/var/lib/mysql/mysql.sock  我没找到 反过来想我认为是没了mysql.sock这个文件而引起的，那没重新找个可以吗或是覆盖安装呢？？

mxbao

直接再my.conf里面加上你的socket的路径呗
指向socket=/var/lib/mysql/mysql.sock