Re: OT: MySQL on Mac OS 10.4

From: Todd O'Bryan (toddobrya..ac.com)
Date: Sun May 15 2005 - 18:42:11 EDT

  • Next message: Doychi: "Validation failures with Primary Key"

    As so often happens, I found the answer after I posted. So here it is
    for others who might be stumped.

    The problem I was having is that MySQL thought it was updating a
    previous install and kept getting confused. (The fact that the
    installer said "Upgrade" rather than "Install" should have been a tip-
    off.) I went into the /Library/Receipts folder and deleted all of the
    MySQL stuff, restarted, and then re-installed and everything seems to
    be working.

    Thanks for letting me waste bandwidth and fill up your inboxes with
    stupid messages since I can't ever seem to discover answers *before*
    I send the messages off. :-)

    Todd

    On May 15, 2005, at 2:14 PM, Todd O'Bryan wrote:

    > Sorry to post something off-topic, but I know there are Mac and
    > MySQL people on this list.
    >
    > I upgraded to OS 10.4 and used the MySQL 4.1.11 installer for 10.3
    > but have been unable to get anything working yet. Here's what
    > happens when I try to run MySQL (I added /usr/local/mysql/bin to my
    > PATH):
    >
    > [pb-17:227]> mysql -u root
    > ERROR 2002 (HY000): Can't connect to local MySQL server through
    > socket '/tmp/mysql.sock' (61)
    >
    > I also installed the MySQL Prefs Pane, and it says
    >
    > The MySQL Server Instance is running
    >
    > but it also has a button that says "Start MySQL" instead of "Stop
    > MySQL" which is what it should say if it really is running.
    >
    > I've seen two messages about OS X problems: one that the /tmp
    > directory is too protected, so I chmod'ed -R 777 /tmp.
    >
    > Another issue was whether the mysql user had access to the data
    > directory, so I chown'ed -R mysql /usr/local/mysql/data/.
    >
    > If I try to start the server using the Pref Pane, I get
    >
    > Could not startup MySQL Server.
    > Reason: Internal error.
    >
    > And the same error if I try to run mysql from the command line.
    >
    > I looked at the log and I'm getting
    >
    > 050515 14:07:21 [ERROR] Fatal error: Can't open privilege tables:
    > Table 'mysql.host' doesn't exist
    > 050515 14:07:21 mysqld ended
    >
    > Has anyone successfully installed MySQL 4.1 on 10.4 and if so, did
    > you do anything special? I've restarted about 4 times hoping that
    > will clean up whatever mess I've made, but so far no good.
    >
    > Any help appreciated,
    > Todd
    >



    This archive was generated by hypermail 2.0.0 : Sun May 15 2005 - 18:42:23 EDT