I want to build Web Site with apache, mysql & php. I have installed Red Hat 8 on pentium 4 system. After downloading source code for all the three packages I have compiled Apache,PHP,MySql. The compilation completed without any errors.

Now when I try to run /etc/rc.d/init.d/mysql start

I am geting following message

Starting mysqld daemon with databases from /usr/local/mysql/var
030730 19:08:31 mysqld ended

When I checked localhost.localdomain.err file from /usr/mysql/var
it is showning following error message

030730 19:08:30 mysqld started
030730 19:08:31 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 43892
InnoDB: Doing recovery: scanned up to log sequence number 0 43892
030730 19:08:31 InnoDB: Flushing modified pages from the buffer pool...
030730 19:08:31 InnoDB: Started
030730 19:08:31 /usr/local/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
030730 19:08:31 mysqld ended

As I am compiling these software first time I don't have any clue about how to solve these types of problems. Please help me out!
I am using a book "beginning databases with MySQL" to learn these softwares.

Thanks in advance

Prasad Sakharkar
Mumbai(India)
[email protected]

getpas,

 I don't have a working install of mysql server where I'm at now, so this is based on memory.

 If all you did was build the binaries on your system you are missing a critical step -- the mysql needs to find it's conf database where it expects to start correctly. I've run into this issue myself (with a similiar sounding error message). Inside the build directory their should be a sub-tree named 'scripts' or 'sql' or something to that effect -- after building the binaries you need to run these scripts to create the initial database mysql needs to run. If you don't, you will get that error message.

  Also, the build process could have dumped them somewhere that mysql doesn't expect ... for example, in /usr/local/var instead of /usr/local/mysql/var ... if you build the database ( see above paragraph) and still get the same error message, check if there are any mysql files, or a mysql folder under /usr/local/var and, if so, try creating sym-links to /usr/local/mysql/var ( or where ever the error msg indicates mysql is looking ).

 The specifics should be documented in the mysql installation guide or pdf manual.

Regards,
Meredith Shaebanyan