On 23/3/03 16:36, "Jeff Shapiro" <[EMAIL PROTECTED]> wrote:
> > 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. [...] > 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/ Hi, Jeff. Right on the money! mysqld is now running happily and I can get into my data. How the hell the permissions got screwed up like that, I've no idea but now I know the error code, I'll know what to look for if it happens again. Many thanks, Regards, Phil. > 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]