[thelist] MySQL - my.cnf not working??

[CDitty]

Hello all, turns out that my odbc problem in Cold Fusion was because of the 
location of the mysql.sock file.  The CF drivers have it hard coded to a 
specific directory.

Anyhow, I have one of two choices.  I can recompile mysql and make it use 
the temp directory that CF likes or I can use the my.cnf file and set the 
temp location it that way.  Problem is, my, mysql doesn't seem to be 
reading my.cnf.  I should be able to set this variable by putting this in 
the my.cnf file. (This info was obtained in the .support-files/my-large.cnf 
file)

[client]
socket          = /var/lib/mysql/mysql.sock

But when I stop and start mysql, the mysql.sock is back in the /tmp/folder.

Can anyone offer any advice on fixing this?

Thanks