Results 1 to 5 of 5

Thread: Problem with MYSQL "mysql.host doesn't exist

  1. #1
    kaltera is offline Partner (VAR/HSP)
    Join Date
    Apr 2008
    Location
    France
    Posts
    48
    Rep Power
    7

    Default Problem with MYSQL "mysql.host doesn't exist

    Hi,

    I'm encountering a problem with mysql that doesn't want to start. I went into the logs and here comes the fatal error :

    [ERROR] Fatal error: Can’t open and lock privilege tables: Table ‘mysql.host’ doesn’t exist

    Anybody has an idea to solve that ?

    Thank you

  2. #2
    phoenix is offline Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,480
    Rep Power
    56

    Default

    Some idea of Zimbra version and operating system might help. Is this an upgrade, new install or running installation? Did you search the forums for the words "privilege tables", do any of those results help?

    Please update your profile with the details from zmcontrol -v
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  3. #3
    kaltera is offline Partner (VAR/HSP)
    Join Date
    Apr 2008
    Location
    France
    Posts
    48
    Rep Power
    7

    Default

    This is a new install, Zimbra 5.05 NE on Ubuntu 6.06 Server

    I'm actually reading the 5 pages topic but doesn't seem to be a solution

    i'm searching on the web aswell in case this is not a problem with Zimbra itself

  4. #4
    Krang is offline New Member
    Join Date
    Jun 2010
    Location
    Winnipeg, Manitoba
    Posts
    4
    Rep Power
    5

    Default

    Howdy,

    I am also having the same problem as described. I have a new install on a new RHEL5 server. zimbra release 6.0.6_GA_2330 (network edition)

    zmcontrol status shows the mailbox is stopped, mysql.server is not running.

    I can see an error in the /opt/zimbra/logs/mysql_error.log and I have the entry :
    [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
    mysqld ended

    any help or pointers in the right direction are always appreciated.

    Best regards,
    Monte.

  5. #5
    Krang is offline New Member
    Join Date
    Jun 2010
    Location
    Winnipeg, Manitoba
    Posts
    4
    Rep Power
    5

    Default

    Quote Originally Posted by Krang View Post
    Howdy,

    I am also having the same problem as described. I have a new install on a new RHEL5 server. zimbra release 6.0.6_GA_2330 (network edition)

    zmcontrol status shows the mailbox is stopped, mysql.server is not running.

    I can see an error in the /opt/zimbra/logs/mysql_error.log and I have the entry :
    [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
    mysqld ended

    any help or pointers in the right direction are always appreciated.

    Best regards,
    Monte.

    I resolved my own issue.
    I removed the OS/YUM installed version of mysql, and dependencies. Then I reinstalled the zimbra server with the install.sh script which added it's own mysql server, which operates under the /opt/zimbra/db/mysql directory with it's own dependencies.

    Now my zimbra server starts and runs as expected.

    I strongly recommend that the zimbra team add a check for existing mysql databases, and stop the installation at that point. Some documentation warning of this in the install/quick setup guide would be helpful as well.

    best regards,
    Monte.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Zimbra fails after working for 2 weeks
    By Linsys in forum Administrators
    Replies: 10
    Last Post: 10-07-2008, 12:42 AM
  2. [SOLVED] Install Problem in Ubuntu 6.06 Server
    By xtimox in forum Installation
    Replies: 16
    Last Post: 03-27-2008, 09:36 AM
  3. DNS Questions and Trouble Installing
    By smurraysb in forum Installation
    Replies: 22
    Last Post: 03-14-2008, 03:27 PM
  4. [SOLVED] Upgraded to 5.0 OSS - Sendmail Problem
    By Chewie71 in forum Installation
    Replies: 11
    Last Post: 12-28-2007, 07:07 PM
  5. Replies: 18
    Last Post: 03-20-2006, 02:22 PM

Posting Permissions

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