[calimehtar]

I'm trying to get mysql up and running... I followed the instructions here
two different ways -- logged in as me and logged in as root. In either case when I run

Code:
sudo ./bin/mysqld_safe &

it says mysqld couldn't be found. I figured out the problem has to do with permissions on mysql/data so just as a test I turned the permissions as promiscuous as possible and ran it again. This time it just quits. Here's what the error log says:

Code:
030527 16:29:31  Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
030527 16:29:31  Aborting

etc.


What's going on?

[philzilla]

i had trouble with Marc's installation, last time i tried using it. i tried all day, to no avail. in the end, i went to the source, and tried their method. worked first time:

http://www.mysql.com/doc/en/Mac_OS_X_installation.html

[calimehtar]

yeah, well, it still doesn't work though it's failing in a different way this time. I suspect it might be a permissions problem or a netinfo problem as most of the installation instructions I found had strange, byzantine instructions for making and modifying mysql users and groups...

Anyway the error of the day is as follows:

Code:
Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist

also I tried running mysql_fix_privilege_tables which causes the following error to be repeated ad nauseum

Code:
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

I really don't know where to start as I've looked in all install instruction pages for Mac OS X and done repeated searches for the error messages I've come across on google.

[Colonel_Panic]

ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

You have your mysqld process running from your unix temp dir, in most cases when an app uses this directory it resets its privs, If you are getting this error then the last step for you to do is get info on /private/tmp and make sure all three options say read-write

[calimehtar]

All three _do_ say rw:

Code:
drwxrwxrwt  196 root  wheel  6664 May 29 12:42 tmp

[Colonel_Panic]

Thats interesting, Whitch install method did you use to get where you are now?

[calimehtar]

I used the instructions for binary install on the Mysql site.