Find the answer to your Linux question:
Results 1 to 4 of 4
Hay guys, I have been scratching my head about this for some time, well 2 days, but my site is down and I need to fix it soon. When starting ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Jul 2004
    Posts
    85

    050116 12:51:32 mysqld ended, Plese Help :(


    Hay guys, I have been scratching my head about this for some time, well 2 days, but my site is down and I need to fix it soon.

    When starting mySQL (I run it on Slackware 10.0) after few seconds it ends and prints out a message: 050116 12:51:32 mysqld ended

    I looked in the error logs. Here is what I found:

    050116 12:51:29 mysqld started
    050116 12:51:30 InnoDB: Started
    050116 12:51:30 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
    050116 12:51:30 Aborting

    050116 12:51:30 InnoDB: Starting shutdown...
    050116 12:51:32 InnoDB: Shutdown completed
    050116 12:51:32 /usr/libexec/mysqld: Shutdown Complete

    050116 12:51:32 mysqld ended

    I gather that the problem is with the mysql.host file. Problam is, I have no idea what to do about that? Please help,

    - Bogdan

  2. #2
    Linux Guru sarumont's Avatar
    Join Date
    Apr 2003
    Location
    /dev/urandom
    Posts
    3,682
    Obviously, the priveledge table doesn't exist. You'll have to treat it as if you've never had it running. I think this can be done by running the 'mysql_install_db' script, but I'm not sure on that.
    "Time is an illusion. Lunchtime, doubly so."
    ~Douglas Adams, The Hitchhiker's Guide to the Galaxy

  3. #3
    Linux Enthusiast puntmuts's Avatar
    Join Date
    Dec 2004
    Location
    Republic Banana
    Posts
    562
    Code:
    su - mysql    <-- mind the - in the command 
    mysql_install_db
    exit
    Follow the instructions on your screen to set a root password for mysql.
    Done
    I\'m so tired .....
    #200472

  4. $spacer_open
    $spacer_close
  5. #4
    Just Joined!
    Join Date
    Jul 2004
    Posts
    85
    Thank you, that fixed the problem. Wow, I guess am never going back to Win Servers Again

    - Bogdan

Posting Permissions

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