Thanks for the (not overly pedantic) note. I noticed the link and the
sticky bit setting on /private/tmp and was (I guess rightfully)
afraid to screw stuff up. I think the note about /tmp permissions
applied to some settings that the 10.3.7 updater did.
Todd
On May 16, 2005, at 10:33 AM, Gentry, Michael (Contractor) wrote:
> 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 : Tue May 17 2005 - 06:18:03 EDT