Results 1 to 5 of 5

Thread: MySQL error 111

  1. #1
    Junior Member
    Join Date
    Jan 2002
    Posts
    25

    MySQL error 111

    Ok, here goes:
    I just reinstalled linux (don't ask )
    I installed the apache package with support
    for PHP and MySQL and the nessary MySQL
    packages.
    But I cannot access MySQL.
    Please view mysqld.txt for everything I
    have tried
    I have looked at different online docs
    and have not found anything useful at all!
    If you can help me get started, Please DO!
    thanks in advance
    --
    \"UNIX is basically a simple operating system, but you have to be a genius to understand the simplicity.\"
    Dennis Ritchie.

  2. #2
    mysqld started on Thu Jan 3 22:28:06 EST 2002
    /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (Errcode: 2)
    mysqld ended on Thu Jan 3 22:28:06 EST 2002

    mysqld started on Thu Jan 3 22:38:43 EST 2002
    /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (Errcode: 2)
    mysqld ended on Thu Jan 3 22:38:44 EST 2002

    it seems you are missing that host.frm file...I'm no expert at SQL but thats my guess

  3. #3
    Junior Member
    Join Date
    Jan 2002
    Posts
    25
    >quote:
    >mysqld started on Thu Jan 3 22:28:06 EST 2002
    >/usr/sbin/mysqld: Can't find file: './mysql/host.frm' >(Errcode: 2)
    >mysqld ended on Thu Jan 3 22:28:06 EST 2002

    >mysqld started on Thu Jan 3 22:38:43 EST 2002
    >/usr/sbin/mysqld: Can't find file: './mysql/host.frm' >(Errcode: 2)
    >mysqld ended on Thu Jan 3 22:38:44 EST 2002

    >it seems you are missing that host.frm file...I'm no >expert at SQL but thats my guess

    I seems to be, but I can't ca't find "host.frm"
    and can't figure out where "./mysql" refers to.
    --
    \"UNIX is basically a simple operating system, but you have to be a genius to understand the simplicity.\"
    Dennis Ritchie.

  4. #4
    PHP/PostgreSQL guy
    Join Date
    Dec 2001
    Posts
    1,164
    Run this to find that file (if it exists somewhere else):

    find / -name host.frm -exec ls -l {} \;

    If it doesn't exist, I'd find out what to do to create it.
    We the willing, led by the unknowing, have been doing the impossible for the ungrateful. We have done so much with so little for so long that we are now qualified to do just about anything with almost nothing.

  5. #5
    Junior Member
    Join Date
    Jan 2002
    Posts
    25
    Vorlin:
    I think I got it figured out some-what.

    "mysqladmin install-db"

    Creates host.frm and the other necessary
    files in order to start the mysqld
    --
    \"UNIX is basically a simple operating system, but you have to be a genius to understand the simplicity.\"
    Dennis Ritchie.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •