Chinaunix首页 | 论坛 | 博客
  • 博客访问: 2036756
  • 博文数量: 470
  • 博客积分: 10206
  • 博客等级: 上将
  • 技术积分: 5620
  • 用 户 组: 普通用户
  • 注册时间: 2008-07-03 12:50
文章分类

全部博文(470)

文章存档

2012年(1)

2011年(18)

2010年(47)

2009年(404)

分类: Mysql/postgreSQL

2009-10-26 14:45:55

安装extmail时,启动数据库mysql报错

[root@ns RPMS]# service mysqld start
Timeout error occurred trying to start MySQL Daemon.
启动 MySQL:                                               [失败]
[root@ns RPMS]#
我是安文档做为参考,做到启动数据库就卡到这里了。

二、        修改/etc/postfix/master.cf时
  前面要有一个空格maildrop  unix  -       n       n       -       -       pipe
  前面要有两个空格#flags=DRhu user=vmail argv=/usr/local/bin/maildrop -d ${recipient}
  前两个空格flags=DRhu user=vuser argv=maildrop -w 90 -d ${user}@${nexthop}
  前面是一个空格${recipient} ${user} ${extension} {nexthop}
只有这样才不报错误
三、我也执行了[root@ns RPMS]# rpm -qa | grep -i mysql-server
mysql-server-4.1.20-1.RHEL4.1
[root@ns RPMS]# /usr/bin/mysql_install_db
Installing all prepared tables
Fill help tables

To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h ns.zhijin.com password 'new-password'
See the manual for more instructions.

NOTE:  If you are upgrading from a MySQL <= 3.22.10 you should run
the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!

You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at

Support MySQL by buying support/licenses at
[root@ns RPMS]#

[root@ns RPMS]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.   
启动 MySQL:                                               [失败]
四、日志
[root@ns RPMS]# tail /var/log/mysqld.log
070819 11:03:11  mysqld started
/usr/libexec/mysqld: Can't create/write to file '/tmp/ibhBdvKG' (Errcode: 13)
070819 11:03:11  InnoDB: Error: unable to create temporary file; errno: 13
070819 11:03:11 [ERROR] Can't init databases
070819 11:03:11 [ERROR] Aborting

070819 11:03:11 [Note] /usr/libexec/mysqld: Shutdown complete

070819 11:03:11  mysqld ended
[root@ns RPMS]# tail /var/log/messages
Aug 19 12:09:22 ns kernel: device eth0 left promiscuous mode
Aug 19 12:09:22 ns kernel: device lo left promiscuous mode
Aug 19 12:09:23 ns kernel: eth0: Promiscuous mode enabled.
Aug 19 12:09:23 ns kernel: device eth0 entered promiscuous mode
Aug 19 12:11:28 ns mysqld: 停止 MySQL: failed
Aug 19 12:12:04 ns mysqld: 启动 MySQL: failed
Aug 19 12:16:13 ns kernel: device eth0 left promiscuous mode
Aug 19 12:27:21 ns mysqld: 启动 MySQL: failed
Aug 19 12:32:20 ns mysqld: 启动 MySQL: failed
Aug 19 12:43:14 ns mysqld: 启动 MySQL: failed


请各位高手帮助!我已经看文档看了,将近一个月了。目前还是收获很少很少!谢谢您的关注!
需要越进!需要超越的前进!

TOP

解决了!

看/var/lib/mysql下的日志以主机名命名的*.err
070819 16:26:12 [ERROR] /usr/libexec/mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 13)
然后就chown -R mysql.mysql /var/run/mysqld这样就可以了。我是因为我是/var/lib/mysql这个目录没有所有者,所以出现上面的问题。谢谢各位的关注!

一起 努力!
需要越进!需要超越的前进!

TOP

恭喜啊,自己解决比别人帮忙更有意义!
请引用或摘抄本站文章信息的朋友,保留本站链接及作者信息,保护版权,谢谢。



TOP

哈哈!谢谢您的鼓励!
需要越进!需要超越的前进!

TOP

安装extmail时,启动数据库mysql报错

[root@ns RPMS]# service mysqld start
Timeout error occurred trying to start MySQL Daemon.
启动 MySQL:                                               [失败]
[root@ns RPMS]#
我是安文档做为参考,做到启动数据库就卡到这里了。

二、        修改/etc/postfix/master.cf时
  前面要有一个空格maildrop  unix  -       n       n       -       -       pipe
  前面要有两个空格#flags=DRhu user=vmail argv=/usr/local/bin/maildrop -d ${recipient}
  前两个空格flags=DRhu user=vuser argv=maildrop -w 90 -d ${user}@${nexthop}
  前面是一个空格${recipient} ${user} ${extension} {nexthop}
只有这样才不报错误
三、我也执行了[root@ns RPMS]# rpm -qa | grep -i mysql-server
mysql-server-4.1.20-1.RHEL4.1
[root@ns RPMS]# /usr/bin/mysql_install_db
Installing all prepared tables
Fill help tables

To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h ns.zhijin.com password 'new-password'
See the manual for more instructions.

NOTE:  If you are upgrading from a MySQL <= 3.22.10 you should run
the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!

You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at

Support MySQL by buying support/licenses at
[root@ns RPMS]#

[root@ns RPMS]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.   
启动 MySQL:                                               [失败]
四、日志
[root@ns RPMS]# tail /var/log/mysqld.log
070819 11:03:11  mysqld started
/usr/libexec/mysqld: Can't create/write to file '/tmp/ibhBdvKG' (Errcode: 13)
070819 11:03:11  InnoDB: Error: unable to create temporary file; errno: 13
070819 11:03:11 [ERROR] Can't init databases
070819 11:03:11 [ERROR] Aborting

070819 11:03:11 [Note] /usr/libexec/mysqld: Shutdown complete

070819 11:03:11  mysqld ended
[root@ns RPMS]# tail /var/log/messages
Aug 19 12:09:22 ns kernel: device eth0 left promiscuous mode
Aug 19 12:09:22 ns kernel: device lo left promiscuous mode
Aug 19 12:09:23 ns kernel: eth0: Promiscuous mode enabled.
Aug 19 12:09:23 ns kernel: device eth0 entered promiscuous mode
Aug 19 12:11:28 ns mysqld: 停止 MySQL: failed
Aug 19 12:12:04 ns mysqld: 启动 MySQL: failed
Aug 19 12:16:13 ns kernel: device eth0 left promiscuous mode
Aug 19 12:27:21 ns mysqld: 启动 MySQL: failed
Aug 19 12:32:20 ns mysqld: 启动 MySQL: failed
Aug 19 12:43:14 ns mysqld: 启动 MySQL: failed


请各位高手帮助!我已经看文档看了,将近一个月了。目前还是收获很少很少!谢谢您的关注!
需要越进!需要超越的前进!

TOP

解决了!

看/var/lib/mysql下的日志以主机名命名的*.err
070819 16:26:12 [ERROR] /usr/libexec/mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 13)
然后就chown -R mysql.mysql /var/run/mysqld这样就可以了。我是因为我是/var/lib/mysql这个目录没有所有者,所以出现上面的问题。谢谢各位的关注!

一起 努力!
需要越进!需要超越的前进!

TOP

恭喜啊,自己解决比别人帮忙更有意义!
请引用或摘抄本站文章信息的朋友,保留本站链接及作者信息,保护版权,谢谢。



TOP

哈哈!谢谢您的鼓励!
需要越进!需要超越的前进!

TOP

安装extmail时,启动数据库mysql报错

[root@ns RPMS]# service mysqld start
Timeout error occurred trying to start MySQL Daemon.
启动 MySQL:                                               [失败]
[root@ns RPMS]#
我是安文档做为参考,做到启动数据库就卡到这里了。

二、        修改/etc/postfix/master.cf时
  前面要有一个空格maildrop  unix  -       n       n       -       -       pipe
  前面要有两个空格#flags=DRhu user=vmail argv=/usr/local/bin/maildrop -d ${recipient}
  前两个空格flags=DRhu user=vuser argv=maildrop -w 90 -d ${user}@${nexthop}
  前面是一个空格${recipient} ${user} ${extension} {nexthop}
只有这样才不报错误
三、我也执行了[root@ns RPMS]# rpm -qa | grep -i mysql-server
mysql-server-4.1.20-1.RHEL4.1
[root@ns RPMS]# /usr/bin/mysql_install_db
Installing all prepared tables
Fill help tables

To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h ns.zhijin.com password 'new-password'
See the manual for more instructions.

NOTE:  If you are upgrading from a MySQL <= 3.22.10 you should run
the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!

You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at

Support MySQL by buying support/licenses at
[root@ns RPMS]#

[root@ns RPMS]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.   
启动 MySQL:                                               [失败]
四、日志
[root@ns RPMS]# tail /var/log/mysqld.log
070819 11:03:11  mysqld started
/usr/libexec/mysqld: Can't create/write to file '/tmp/ibhBdvKG' (Errcode: 13)
070819 11:03:11  InnoDB: Error: unable to create temporary file; errno: 13
070819 11:03:11 [ERROR] Can't init databases
070819 11:03:11 [ERROR] Aborting

070819 11:03:11 [Note] /usr/libexec/mysqld: Shutdown complete

070819 11:03:11  mysqld ended
[root@ns RPMS]# tail /var/log/messages
Aug 19 12:09:22 ns kernel: device eth0 left promiscuous mode
Aug 19 12:09:22 ns kernel: device lo left promiscuous mode
Aug 19 12:09:23 ns kernel: eth0: Promiscuous mode enabled.
Aug 19 12:09:23 ns kernel: device eth0 entered promiscuous mode
Aug 19 12:11:28 ns mysqld: 停止 MySQL: failed
Aug 19 12:12:04 ns mysqld: 启动 MySQL: failed
Aug 19 12:16:13 ns kernel: device eth0 left promiscuous mode
Aug 19 12:27:21 ns mysqld: 启动 MySQL: failed
Aug 19 12:32:20 ns mysqld: 启动 MySQL: failed
Aug 19 12:43:14 ns mysqld: 启动 MySQL: failed


请各位高手帮助!我已经看文档看了,将近一个月了。目前还是收获很少很少!谢谢您的关注!
需要越进!需要超越的前进!

TOP

解决了!

 看/var/lib/mysql下的日志以主机名命名的*.err
070819 16:26:12 [ERROR] /usr/libexec/mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 13)
然后就chown -R mysql.mysql /var/run/mysqld这样就可以了。我是因为我是/var/lib/mysql这个目录没有所有者,所以出现上面的问题。谢谢各位的关注!

一起努力!
需要越进!需要超越的前进!
阅读(3316) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~