MySql/Slack 8.1 - Starting d

[hads]

Hi all,

Please bear with me as I'm a bit green to this...

I have this all running on RH 7.2 but I've just installed Slackware 8.1 to have a play and I'm having trouble starting MySql.

This is a standard fresh install of Slackware with Apache/PHP/MySql installed from the disk, I have Apache and PHP running fine but if I try to start MySql it ends immediately (see output below).

------------------------------------------
root@elroy:~# safe_mysqld &
[1] 407
root@elroy:~# Starting mysqld daemon with databases from /var/lib/mysql
020623 23:16:59 mysqld ended

[1]+ Done safe_mysqld
root@elroy:~#
------------------------------------------

I've run mysql_install_db and it appeared to run correctly (same as other box)

Anyone have any ideas as to why this would be?

Any suggestions or redirections would be greatly appreciated.

Cheers,

01101000011000010110010001110011

 

[piti]

hi

first look in the logs, i always found an answer there ;-)
or
check out this thread thread436-289751 ("newbie mysql question" by wreikun), there was the same problem solved

hope that helps

 

[hads]

Okay, sorry for the double posting, I had a search round before I posted but I must be blind cos I didn't see that one.

It did have some helpful stuff in it i.e. I'd been trying to figure out the name of the log file for ages!

I had a look in the log file and the output is as follows:

------------------------------------------
020624 18:32:30 mysqld started
020624 18:32:30 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
020624 18:32:30 mysqld ended
------------------------------------------

I think errno: 13 is permission denied or something but I'm not sure.

The path the actual data files are in is /var/lib/mysql/mysql...

...heh, O.K I just figured it out, I chown and chgrp'd /var/lib/mysql/ to mysql:mysql and it sorted it out.

Thanks for the step in the right direction piti.
01101000011000010110010001110011