Redhat9+apache+php+mysql4.0.26安装出问题，求救！！！

caichunlei

前面安装apache和PHP都很顺利，再安装mysql-4.0.26时，最后执行[root@redhat9xp bin]# mysqld_safe &时系统提示：
[root@redhat9xp bin]# mysqld_safe &
[1] 9864
[root@redhat9xp bin]# Starting mysqld daemon with databases from /usr/local/var
STOPPING server from pid file /usr/local/var/redhat9xp.pid
051020 16:21:55  mysqld ended
上面的提示是什么意思，问题出在什么地方。？


贴上日志文件：
051020 16:15:48  mysqld started
Fatal error: Can't change to run as user 'mysql'.  Please check that the user exists!
051020 16:15:48 Aborting

051020 16:15:48 /usr/local/mysql/libexec/mysqld: Shutdown Complete

051020 16:15:48  mysqld ended

051020 16:20:31  mysqld started
051020 16:20:31  InnoDB: Operating system error number 13 in a file operation.
InnoDB: See http://dev.mysql.com/doc/mysql/en/InnoDB.html
InnoDB: for installation help.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
051020 16:20:31  mysqld ended

在线等...................................

HonestQiao

你可以自己学着看日志么？

Fatal error: Can't change to run as user 'mysql'.  Please check that the user exists!
这个已经很明显了啊

caichunlei

那是之前启动的
后来051020 16:20:31  mysqld started 出错是什么原因？
051020 16:20:31  InnoDB: Operating system error number 13 in a file operation.

netos

最近学习freebsd,也遇到这问题.

#tar zxvf mysql-standard-5.0.12-beta-freebsd5.3-i386.tar.gz
#mv mysql-standard-5.0.12-beta-freebsd5.3-i386 mysql //把文件改成mysql
#cp -r mysql /usr/local //把mysql目录拷贝到/usr/local目录下
#cd /usr/local/mysql
#pw groupadd mysql
#pw useradd mysql -g mysql
#chown -R root .
#chown -R mysql data
#chgrp -R mysql .
#scripts/mysql_install_db --user=mysql
#cd /usr/local/mysql/bin
#./mysqld_safe --user=mysql //启动mysql服务

HonestQiao

那你吧mysql的日志先删除了，再起动。

再把日志贴上来。

freebsd使用ports安装很简单的。

caichunlei

删掉之后，重新启动的日志文件：
051020 18:47:38  mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
051020 18:47:38  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
051020 18:47:39  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...
051020 18:47:39  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
051020 18:47:40  InnoDB: Started
051020 18:47:40 /usr/local/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
051020 18:47:40 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (er
rno: 13)
051020 18:47:40 Aborting

051020 18:47:40  InnoDB: Starting shutdown...
051020 18:47:42  InnoDB: Shutdown completed
051020 18:47:42 /usr/local/mysql/libexec/mysqld: Shutdown Complete

HonestQiao

051020 18:47:40 /usr/local/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)

没有发现mysql的host.frm文件。

你做了mysql的初始化数据库的工作么？

caichunlei

怎么初始化数据库？请教

ipaddr

干嘛不用包安装，

ＲＰＭ，ＰＯＲＴ都不错呀.

caichunlei

linux被我删掉了，下次试试RPM