Professional Web Applications Themes

How can I make mysqld find the table 'mysql.host' on Fedora Core 4? - MySQL

I'm trying to get mysql working on Fedora Core 4. Actually trying to start the program mysqld without fatal errors. I posted this message first on the linux misc group - but no luck so far. Maybe people on this group can help me out. Sorry about posting to two groups. The reference manual for mysql ver 4.1 is huge, it's over 1900 pages! I've tried all day but now I have to ask for help from people more experienced then me. Anyway, this is what I have done: I changed ownership of the mysql directory to my userid ran ...

  1. #1

    Default How can I make mysqld find the table 'mysql.host' on Fedora Core 4?

    I'm trying to get mysql working on Fedora Core 4. Actually
    trying to start the program mysqld without fatal errors. I posted this
    message first on the linux misc group - but no luck so far. Maybe
    people on this group can help me out. Sorry about posting to two
    groups.
    The reference manual for mysql ver 4.1 is huge, it's over 1900 pages!
    I've tried all day but now I have to ask for help from people more
    experienced then me.
    Anyway, this is what I have done: I changed ownership of the mysql
    directory to my userid
    ran the program mysqld without options - which did set up a few things,
    but had fatal errors.
    So, I tried again.
    Finally I read in the manual that if one's data directory is in a
    different place then usual then the data directory must be given on the
    command line or in a configuration (option) file.
    So,
    I typed the command: /usr/libexec/mysqld -datadir=/var/lib/mysql

    The output (cut and pasted below) was:

    060923 19:16:02 InnoDB: Database was not shut down normally!
    InnoDB: Starting crash recovery.
    InnoDB: Reading tablespace information from the .ibd files...
    InnoDB: Restoring possible half-written data pages from the doublewrite
    InnoDB: buffer...
    060923 19:16:02 InnoDB: Starting log scan based on checkpoint at
    InnoDB: log sequence number 0 43634.
    InnoDB: Doing recovery: scanned up to log sequence number 0 43634
    060923 19:16:02 InnoDB: Flushing modified pages from the buffer
    pool...
    060923 19:16:02 InnoDB: Started; log sequence number 0 43634
    060923 19:16:02 [ERROR] Fatal error: Can't open and lock privilege
    tables: Table 'mysql.host' doesn't exist


    Which brings me to the question:

    How can I make mysqld find the table 'mysql.host' on Fedora Core 4?

    second: Do I have to tell mysqld where the base directory is? And if
    so, where would it be?

    Any help appreciated!

    - Tom Z

    tomzam@gmail.com Guest

  2. #2

    Default How can I make mysqld find the table 'mysql.host' on Fedora Core 4?

    Please forgive me if this message posts rwice to this group.
    (having trouble using google groups)
    I'm trying to get mysql working on Fedora Core 4. Actually trying
    to start the program mysqld without fatal errors. I posted this message
    first on the linux misc group - but no luck so far. Maybe people on
    this group can help me out. Sorry about posting to two groups.
    The reference manual for mysql ver 4.1 is huge, it's over 1900 pages!
    I've tried all day but now I have to ask for help from people more
    experienced then me.
    Anyway, this is what I have done: I changed ownership of the mysql
    directory to my userid
    ran the program mysqld without options - which did set up a few things,
    but had fatal errors.
    So, I tried again.
    Finally I read in the manual that if one's data directory is in a
    different place then usual then the data directory must be given on the
    command line or in a configuration (option) file.
    So,
    I typed the command: /usr/libexec/mysqld -datadir=/var/lib/mysql

    The output (cut and pasted below) was:

    060923 19:16:02 InnoDB: Database was not shut down normally!
    InnoDB: Starting crash recovery.
    InnoDB: Reading tablespace information from the .ibd files...
    InnoDB: Restoring possible half-written data pages from the doublewrite
    InnoDB: buffer...
    060923 19:16:02 InnoDB: Starting log scan based on checkpoint at
    InnoDB: log sequence number 0 43634.
    InnoDB: Doing recovery: scanned up to log sequence number 0 43634
    060923 19:16:02 InnoDB: Flushing modified pages from the buffer
    pool...
    060923 19:16:02 InnoDB: Started; log sequence number 0 43634
    060923 19:16:02 [ERROR] Fatal error: Can't open and lock privilege
    tables: Table 'mysql.host' doesn't exist


    Which brings me to the question:

    How can I make mysqld find the table 'mysql.host' on Fedora Core 4?

    second: Do I have to tell mysqld where the base directory is? And if
    so, where would it be?

    Any help appreciated!

    - Tom Z

    tomzam@gmail.com Guest

  3. #3

    Default How can I make mysqld find the table 'mysql.host' on Fedora Core 4?

    I am having trouble using google groups. My apologies if this
    appears multiple times
    I'm trying to get mysql working on Fedora Core 4. Actually trying
    to start the program mysqld without fatal errors. I posted this message
    first on the linux misc group - but no luck so far. Maybe people on
    this group can help me out. Sorry about posting to two groups.
    The reference manual for mysql ver 4.1 is huge, it's over 1900 pages!
    I've tried all day but now I have to ask for help from people more
    experienced then me.
    Anyway, this is what I have done: I changed ownership of the mysql
    directory to my userid
    ran the program mysqld without options - which did set up a few things,
    but had fatal errors.
    So, I tried again.
    Finally I read in the manual that if one's data directory is in a
    different place then usual then the data directory must be given on the
    command line or in a configuration (option) file.
    So,
    I typed the command: /usr/libexec/mysqld -datadir=/var/lib/mysql

    The output (cut and pasted below) was:

    060923 19:16:02 InnoDB: Database was not shut down normally!
    InnoDB: Starting crash recovery.
    InnoDB: Reading tablespace information from the .ibd files...
    InnoDB: Restoring possible half-written data pages from the doublewrite
    InnoDB: buffer...
    060923 19:16:02 InnoDB: Starting log scan based on checkpoint at
    InnoDB: log sequence number 0 43634.
    InnoDB: Doing recovery: scanned up to log sequence number 0 43634
    060923 19:16:02 InnoDB: Flushing modified pages from the buffer
    pool...
    060923 19:16:02 InnoDB: Started; log sequence number 0 43634
    060923 19:16:02 [ERROR] Fatal error: Can't open and lock privilege
    tables: Table 'mysql.host' doesn't exist


    Which brings me to the question:

    How can I make mysqld find the table 'mysql.host' on Fedora Core 4?

    second: Do I have to tell mysqld where the base directory is? And if
    so, where would it be?

    Any help appreciated!

    - Tom Z

    tomzam Guest

Similar Threads

  1. FMS 2 on Fedora Core 5
    By RajanYadav in forum Macromedia Flash Flashcom
    Replies: 4
    Last Post: February 18th, 10:27 PM
  2. Installation problem on Fedora core 4..
    By artjesus in forum Macromedia Flash Flashcom
    Replies: 2
    Last Post: December 7th, 07:14 PM
  3. Red Hat Fedora Core 4 ?
    By Frank565656 in forum Macromedia Flash Flashcom
    Replies: 2
    Last Post: December 1st, 04:38 AM
  4. Flash Server for Fedora Core 4
    By dpattyatl in forum Macromedia Flash Flashcom
    Replies: 2
    Last Post: April 11th, 01:40 PM
  5. CFMX 7 Doentation for Fedora Core 4?
    By fergussona in forum Coldfusion - Getting Started
    Replies: 36
    Last Post: October 14th, 02:52 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139