It is looking for /var/lib/mysql/./mysql/host.frm
This is probably owned by root, and mysql d runs as user mysql
chown -R mysql /var/lib/mysql
should solve the problem.
Trevor Osatchuk wrote:
> I just installed mysql from the rpm on the disk that came with the RedHat
> distro cd #2. When trying to run the mysqld daemon from root with
> /usr/bin/safe_mysqld I get:
>
> /usr/bin/safe_mysqld
> Starting mysqld daemon with databases from /var/lib/mysql
> 011105 17:17:01 mysqld ended
>
> In /var/lib/mysql/pinto.err I get(pinto is the hostname of the RedHat box):
>
> 011105 17:17:01 mysqld started
> 011105 17:17:01 /usr/libexec/mysqld: Can't find file: './mysql/host.frm'
> (errn)
> 011105 17:17:01 mysqld ended
>
> Now, why is /usr/libexec/mysqld looking for
> /usr/libexec/mysqld/mysql/host.frm when it is in
> /var/lib/mysql/mysql/host.frm?
>
> Am I missing something here?
>
> Thanks!
>
> Trevor Osatchuk
> Process Solutions Canada Ltd.
> Support and Integration Analyst
> (780) 452-2227 Ext. 286
> trevor.osatchuk@stripped
>
> Any man whose errors take ten years to correct is quite a man.
> - J. Robert Oppenheimer, speaking of Albert Einstein
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <mysql-thread90144@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
