求助:MySQL无法启动

数据库服务和管理,MySQL/PostgreSQL/Oracle/Sybase 等
回复
bobby
帖子: 84
注册时间: 2006-10-23 0:37
送出感谢: 0
接收感谢: 0

求助:MySQL无法启动

#1

帖子 bobby » 2007-03-28 2:00

我是下载的源码自己编译安装的MySQL 5.0.37,现在无法启动,具体情况如下

代码: 全选

bobby@ubuntu:~$ sudo /usr/local/mysql/bin/mysqld_safe -user=mysql &
[1] 6709
bobby@ubuntu:~$ Starting mysqld daemon with databases from /usr/local/mysql/data
STOPPING server from pid file /usr/local/mysql/data/ubuntu.pid
070328 01:37:07  mysqld ended
在/usr/local/mysql/data/ubuntu.err中的信息如下

代码: 全选

070328 01:28:09  mysqld started
070328  1:28:09 [Warning] Ignoring user change to 'ser=mysql' because the user was set to 'mysql' earlier on the command line

070328  1:28:09  MyISAM: Operating system error number 13 in a file operation.
MyISAM: The error means mysqld does not have the access rights to
MyISAM: the directory.
MyISAM: File name ./ibdata1
MyISAM: File operation call: 'create'.
MyISAM: Cannot continue operation.
070328 01:28:09  mysqld ended

070328 01:37:07  mysqld started
070328  1:37:07 [Warning] Ignoring user change to 'ser=mysql' because the user was set to 'mysql' earlier on the command line

/usr/local/mysql/libexec/mysqld: File './mysql-bin.index' not found (Errcode: 13)
070328  1:37:07 [ERROR] Aborting

070328  1:37:07 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

070328 01:37:07  mysqld ended
请问该如何解决?
urooter
帖子: 16
注册时间: 2007-02-06 18:33
送出感谢: 0
接收感谢: 0

....

#2

帖子 urooter » 2007-04-13 17:47

MyISAM: The error means mysqld does not have the access rights to
MyISAM: the directory.

说明你的mysql database 目录没有把权限给mysql:mysql
chown -R mysql:mysql 你的mysql数据目录
---------------------------------
http://hi.baidu.com/uroot
回复

回到 “数据库管理”