Can't start mysqld

Colin Adams colinpauladams at
Wed Apr 22 12:34:59 PDT 2009

I can access mysql if i start it with the --skip-grant-tables option,
and then i can set the root user's password, but I still can't login
when i restart it.

the mysql packages are clearly screwed on dragonfly.

2009/4/22 Colin Adams <colinpauladams at>:
> 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 at>:
>>> 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.)

More information about the Users mailing list