Slackware + MySQL

stuart39 · 10-06-2003, 04:38 PM

Hey,

Can anyone help me with the following prob:

i have slackware 9.0 installed, and cannot get the mysql server running. it is a clean install of mysql and i have run mysql_install_db. whenever i run safe_mysqld it reads the data files ok but 'ends'

my error file xxx.err and it says

mysqld started

/usr/libexec/mysqld: Can't find file './mysql/host.frm'

mysqld ended

yeah i don't have host.frm, what is it? what should go in it? i run mysqld as user 'mysql'.

Zoombie · 10-06-2003, 06:30 PM

You need to run mysql_install_db. I think it's in /usr/share/mysql.

Steve Webster · 10-07-2003, 09:50 AM

Don't forget to run it as the user 'mysql' though, or you'll end up having to change the file/directory permissions manually so that MySQL can access it...

sudo -u mysql /usr/share/mysql/mysql_install_db

Steve

stuart39 · 10-07-2003, 03:22 PM

yeah that worked, thanks

stuart39 · 10-07-2003, 03:31 PM

another question

php 4.3.3 w/slack 9.1 loads mysql.so from /usr/lib/php/extensions - why will it not load at all. i have checked the dir and its right, permissions are right, what do you think is up? should i compile php w/mysql support built in ?

Steve Webster · 10-07-2003, 03:37 PM

Hi Stuart,

I'd go ahead and compile it in, but there are advantages to having MySQL external to PHP (to be able to update MySQL without having to recompile PHP for instance).

What does your php.ini file look like?

Steve