Carl E. Hartung wrote:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Robert A. Rawlinson wrote: <snip> | 050215 16:15:04 mysqld started | 050215 16:15:05 InnoDB: Started | 050215 16:15:05 Fatal error: Can't open privelege tables: Can't find | file: './mysql/host.frm' (errno: 13) | 050215 16:15:05 Aborting | | 050215 16:15:05 InnoDB: Starting shutdown... | 050215 16:15:08 InnoDB: Shutdown completed | 050215 16:15:08 /usr/sbin/mysqld-max: Shutdown Complete
Bob,
I know this sounds like a repeat, but in my post before last I had you confirm that you ran mysql_install_db. I'd like you to try the procedure "from scratch" as though you'd just installed the rpm(s) with YaST. The correct sequence (off the top of my head now -- please verify) was:
(all as root) mysql_install_db
I got the messages like you sent on a previous e-mail. This looked like everything was ok with no error messages.
rcmysql start
I got an indication of start which looked ok
rcmysql status
This gave me the unused message. Then I looked in the log for today and found the time I ran it. it again showed the error: Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm ' (errno: 13) I also tryed the ls -l /var/lib/mysql that someone suggested and it returned: drwxr--xr-x 4 mysql daemon 296 2005-02-16 14:42 . drwxr--xr-x 32 root root 896 2005-02-16 04:19 .. However the host.frm file is not there.
mysqladmin -u root -p extended-status
I'm hoping you just misinterpreted what was happening at the start and can just repeat the entire procedure in the correct order to set it straight. Afterwards, if it doesn't work, check the logs in /var/lib/mysql for anything new. If it /does/ work it'll be time to move on to the next level.
- - Carl
- --
It just seems that files are missing and do not get created if mysql_install_db is supposed to create them. Bob Rawlinson