no "host.frm"

Hi all, new to this ng and trying to run MySQL for the first time ever.
The box runs Slackware 9.0 on a Duron, the version MySQL is
"mysql-3.23.56-i386-1" as supplied with the distro.

Starting mysqld with

# /usr/bin/safe_mysqld &

gives me

# Starting mysqld daemon with databases from /var/lib/mysql 031004
21:48:25 mysqld ended

(I did do # mysql_install_db also copied my-small.cnf to my.cnf)

I get a host.err log saying:

031004 21:48:25 mysqld started
031004 21:48:25 /usr/libexec/mysqld: Can't find file: './mysql/host.frm'
(errno: 13) 031004 21:48:25 mysqld ended

Looks to be a common problem - but what's the fix? I tried using touch to
make a mysql/host.frm empty file in libexec or in etc, but still get the same
error.

Any help appreciated,
TIA, Monster
--
Spam will eat itself

re: no "host.frm"

Hi,
[color=blue]
> I get a host.err log saying:
>
> 031004 21:48:25 mysqld started
> 031004 21:48:25 /usr/libexec/mysqld: Can't find file: './mysql/host.frm'
> (errno: 13) 031004 21:48:25 mysqld ended
>
> Looks to be a common problem - but what's the fix? I tried using touch to
> make a mysql/host.frm empty file in libexec or in etc, but still get the
> same error.[/color]

have you created the database tables? There must be a script called
mysql_install_db or so ... Check /usr/bin after that an execute it ...

Brgds,
Jens

re: no "host.frm"

Hi,
[color=blue]
> I get a host.err log saying:
>
> 031004 21:48:25 mysqld started
> 031004 21:48:25 /usr/libexec/mysqld: Can't find file: './mysql/host.frm'
> (errno: 13) 031004 21:48:25 mysqld ended
>
> Looks to be a common problem - but what's the fix? I tried using touch to
> make a mysql/host.frm empty file in libexec or in etc, but still get the
> same error.[/color]

have you created the database tables? There must be a script called
mysql_install_db or so ... Check /usr/bin after that an execute it ...

Brgds,
Jens

re: no "host.frm"

On Sun, 05 Oct 2003 19:47:12 +0200, Jens Schanz wrote:[color=blue]
>
> have you created the database tables? There must be a script called
> mysql_install_db or so ... Check /usr/bin after that an execute it ...
>[/color]
Yes, I had done that. Fixed it now - I discovered my slocate was out of
date! The permissions on /var/lib/mysql/mysql were set to root.root so I
changed to mysql.root. Everything is working now!

Thanks,
Alexis
--
Spam will eat itself

re: no "host.frm"

On Sun, 05 Oct 2003 19:47:12 +0200, Jens Schanz wrote:[color=blue]
>
> have you created the database tables? There must be a script called
> mysql_install_db or so ... Check /usr/bin after that an execute it ...
>[/color]
Yes, I had done that. Fixed it now - I discovered my slocate was out of
date! The permissions on /var/lib/mysql/mysql were set to root.root so I
changed to mysql.root. Everything is working now!

Thanks,
Alexis
--
Spam will eat itself