Create a Soft Link: cd /opt/coldfusion/lib/
ln -s /usr/local/lib/libmyodbc.so .
Create MySQL DataBases and users as applicable.
ColdFusion Supports Connections to MySQL only over tcp and not unix domain sockets.
Then create an ODBC DataSource from ColdFusion admin Interface using "myODBC mySQL Driver"