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