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