Mysql socket problem - possible way to solve

[esv]

I had a problem - I recompiled mysql myself (without DA help) and mysql socket was at /tmp directory - /tmp/mysql.sock

But DA thought that mysql socket is at /var/lib/mysql/mysql.sock
I saw quite a few such strings in DA binary exe file. Thats weird.

I didn't wanted to recompile mysql to change mysql socket and also php was compiled with this socket...

The only way I found to solve it is to create symlink mysql.sock -> /tmp/mysql.sock

This worked fine for me.

If anyone has any better idea and can explain why DA is looking for mysql socket at some predefined location that would be cool.

Thanks.

 

[jmstacey]

That change is mentioned here:
http://www.directadmin.com/features.php?id=477

As well as another mention of the /tmp symlink back in 2003:
http://www.directadmin.com/features.php?id=31

 

[nobaloney]

Some OS distributions will automatically delete everything in /tmp on a server reboot, so it's never a good idea to put a link, or anything else that needs to stay between reboots, there.

Jeff

 

[SeLLeRoNe]

i would like that the mysql.sock file will put in another directory not in /tmp.. how can i do?

thanks