标题: mysqld 启动失败!!? [打印本页] 作者: chi7na 时间: 2007-08-01 16:21 标题: mysqld 启动失败!!? 我在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 时间: 2007-08-01 16:59
看日志估计能发现点问题把作者: chi7na 时间: 2007-08-01 17:32
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 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 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 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: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 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: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: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: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: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:48 mysqld ended作者: mxbao 时间: 2007-08-01 17:39
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 时间: 2007-08-01 20:31
是不是权限的问题啊。。
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 ?