RE: OT: MySQL on Mac OS 10.4

From: Gentry, Michael \(Contractor\) ("Gentry,)
Date: Mon May 16 2005 - 10:33:32 EDT

  • Next message: Joshua Pyle: "Compound expressions Problem and solution"

    I see you solved your problem, but at the risk of being called a pedant,
    I have two things to point out.

    1) If you changed permissions on /tmp on OS X, you probably changed the
    permissions of the symbolic link. /tmp on OS X is really under
    /private/tmp.

    2) The permissions of 777 on /tmp is not a good idea. If you do an "ls
    -ld /private/tmp" you should see permissions of "drwxrwxrwxt". The
    important thing here is the "t" at the end (the sticky bit) and if you
    "chmod 777 /private/tmp" (as root), it'll get rid of the "t". You want
    the "t" there since it is a security feature. Do a "man sticky" and
    read the part on sticky directories.

    /dev/mrg

    -----Original Message-----
    From: Todd O'Bryan [mailto:toddobrya..ac.com]
    Sent: Sunday, May 15, 2005 6:42 PM
    To: cayenne-use..bjectstyle.org
    Subject: Re: OT: MySQL on Mac OS 10.4

    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 : Mon May 16 2005 - 10:33:37 EDT