It looks to me like you have a permissions problem with your directories. You need to make sure that the directory own for the mysql directory tree is your mysql user.
You can't use the Users section of Systems Preferences to create the MySQL user, you have to use the NetInfo utility. Apple as instructions on how to install MySQL on OS X at:
http://developer.apple.com/internet/macosx/osdb.html
Hmmm, just checked Marc Liyanage's site and for pre-Jaguar he does mention to use System Preferences to create the MySQL user. He also only suggests to use 3.23.51 with pre-Jaguar as well. I'm not what the differences might be between the .51 and .55 for him to make this suggestion. I did try using his setup, but I gave up and went with the tarball files from MySQL instead. I didn't like all the nonstandard stuff that his system did. (At least I think it does some nonstandard stuff, it's been a while).
I just checked your error code with: [~] [0] > perror 13 Error code 13: Permission denied
So it definitely looks like it's a permissions problem.
Try using this command in the Terminal program:
chown -R mysql /usr/local/mysql-3.23.51/
At 13:09 +0000 3/23/03, Phil Dobbin wrote:
I'm having a problem starting the mysqld. I'm running 3.23.51 on Mac OS X 10.1.5 and have a startup script which confirms on boot that it has started but doesn't.
I've tried starting manually from the CLI but no luck. I looked in localhost.err and found:
030323 9:48:21 /usr/local/mysql-3.23.51/bin/mysqld: Can't create/write to file '/usr/local/mysql-3.23.51/data/localhost.pid' (Errcode: 13) 030323 9:48:22 /usr/local/mysql-3.23.51/bin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 030323 9:48:22 /usr/local/mysql-3.23.51/bin/mysqld: Error on delete of '/usr/local/mysql-3.23.51/data/localhost.pid' (Errcode: 13) 030323 09:48:22 mysqld ended
According to the O'Reilly `MySQL Reference Manual' it seems that the daemon may have been damaged but offers no real clue as how to fix it.
One other very odd aspect is that on OS X you create a mysql user in Sys Prefs and I noticed, upon reboot, that this user had disappeared from the pref panel. I re-created but to no avail.
Any help at all on this would be gratefully appreciated.
Regards,
Phil.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
Jeff Shapiro, Colorado Springs, CO, USA
At work I *have* to use a Windows machine, at home I *get* to use a Mac.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
