OT: MySQL on Mac OS 10.4

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

  • Next message: Todd O'Bryan: "OT: MySQL on Mac OS 10.4"

    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,

    This archive was generated by hypermail 2.0.0 : Sun May 15 2005 - 14:31:38 EDT