ColdFusion 7.x & MySQL 4.1.x Connection

ColdFusion 7.x & MySQL 4.1.x Connection


You can check MySQL installation by nmap or netstat commands.

debian:~# nmap localhost

Starting nmap 3.81 ( http://www.insecure.org/nmap/ ) at 2006-01-14 11:22 CET
Interesting ports on localhost.localdomain (127.0.0.1):
(The 1654 ports scanned but not shown below are in state: closed)
PORT STATE SERVICE
21/tcp open ftp
22/tcp open ssh
25/tcp open smtp
53/tcp open domain
80/tcp open http
110/tcp open pop3
143/tcp open imap
953/tcp open rndc
3306/tcp open mysql

Nmap finished: 1 IP address (1 host up) scanned in 0.809 seconds
debian:~#
debian:~# netstat -a | grep mysql
tcp 0 0 localhost.localdo:mysql *:* LISTEN
unix 2 [ ACC ] STREAM LISTENING 4245 /var/run/mysqld/mysqld.sock
debian:~#

BE CAREFUL: This settings are working without any problem on Windows systems BUT if you want to get Unicode support on Linux systems, you must define JDBC URL like below

jdbc:mysql://127.0.0.1:3306/unicodetest?useUnicode=true&characterEncoding=UTF-8