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]

Reply via email to