Re: Can't start mysqld
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.)
Re: Can't start mysqld
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 r...@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.)
Re: Can't start mysqld
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 colinpaulad...@googlemail.com: 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 r...@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.)
Re: Can't start mysqld
On Wed, Apr 22, 2009 at 08:29:46PM +0100, Colin Adams wrote: 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. Did you even bother to follow the instructions from installation method? Consider running pkg_info -D mysql-server again... Joerg
Re: Can't start mysqld
That's just what I can't do - these instructions don't work because of the access problem. (They say there is no existing password, but the system denies me access anyway). 2009/4/22 Joerg Sonnenberger jo...@britannica.bec.de: On Wed, Apr 22, 2009 at 08:29:46PM +0100, Colin Adams wrote: 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. Did you even bother to follow the instructions from installation method? Consider running pkg_info -D mysql-server again... Joerg