A list of tips on troubleshooting MySQL data source connectivity for ColdFusion on RedHat Linux:
ColdFusion: Troubleshooting MySQL Data Source Connectivity on RedHat Linux (Updated April 20, 2001)