Re: Can't start mysqld

[Colin Adams <colinpauladams@xxxxxxxxxxxxxx>]

Well I've just changed /tmp permissions to match those of /var/tmp
(which also match those for /tmp on my Linux systems).

And now mysqld runs, but I can't set any passwrods - I get access
denied (even for root) from mysqladmin.
It seems that the software gets installed with a secret password!

2009/4/22 Jeremy C. Reed <reed@reedmedia.net>:
>> I guess the answer is the permissions - /tmp has drwxr-xr-x 4 root wheel
>>
>> Presumably mysql is using it's own id, even though I'm starting it from root.
>>
>> But I don't understand why /tmp isn't writeable by all. I guess this
>> is a difference between linux and *BSD usage?
>
> That sure looks wrong to me. Maybe /tmp wasn't created from a problem
> installation and then later something created when needed.
>
> If was my system, I would do:   chmod 01777 /tmp
>
> (By the way, see /etc/mtree/BSD.root.dist for tmp -- it may be
> interesting.)
>
>