no "host.frm"
Question posted by: Little Monster
(Guest)
on
July 20th, 2005 12:28 AM
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
4
Answers Posted
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
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
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
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
|
|
|
What is Bytes?
We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights.
Get the best answers to your questions from over 196,948 network members.
Top Community Contributors
|
