On onsdag, apr 23, 2003, at 10:10 Europe/Copenhagen, Chris Lloyd wrote:

> On Wed, Apr 23, 2003 at 03:05:45AM +0200, guillaume meurice wrote:
>>>> the probleme i have now is :
>>>> "can't connect to local mysql server througth
>>> socket
>>>> '/tmp/mysql.socket' when i try to launch mysql.
>>>
>> i try this and check that /var/mysql was own by mysql
>> user and group.
>> the pb is that i havn't /tmp/mysql.sock.
>> i saw that the solution was to make a symbolik link to
>> /var/lib/mysql/mysql.sock in my tmp directory, but I
>> havn't this directory...
>> moreover, i can't find anywhere a file name mysql.sock
>
> Have you actually started mysql server?
> Try '/usr/pkg/etc/rc.d/mysql forcestart' at the command line.
>

Basically there are three steps you have to do after installation 
through pkgsrc:

1) copy the startup files to /etc/rc.d

For MySQL this should do the trick:
	cp /usr/pkg/etc/rc.d/mysql /etc/rc.d/

2) edit /etc/rc.conf to reflect what should be started and what not at 
boot

Put
	mysql="YES"
inside /etc/rc.conf

3) manually start / reboot

Run
	/etc/rc.d/mysql start

I hope this helps. I've messed around with this, too, before I found 
out how to do it right. ;)

/Daniel