MySQL starts on port 3306, I am able to access the database via phpmyadmin without a problem.
I have a web app in PHP running in apache XAMPP able to connect and process SQL
I am also able to command line into the server : ./mysql -u root -p
sgordon:xamppfiles sgordon$ nmap -P0 localhost -p 3306
Starting Nmap 5.21 ( http://nmap.org ) at 2011-10-13 14:38 CDT
Nmap scan report for localhost (127.0.0.1)
Host is up (0.00013s latency).
PORT STATE SERVICE
3306/tcp closed mysql
I am unable to telnet to the service.
I am unable to configure my coldfusion database -> Data Sources to this MySql Database. This is the primary issue. Suggestions??
I have tried both with firewall on and off. I have tried restarting.
Seems to have something to do with where the PHP files are located, but that does not make sense. Below are the process with mysql running.
sgordon:xamppfiles sgordon$ ps -aef | grep mysql
0 1562 1 0 2:38PM ttys000 0:00.02 /bin/sh /Applications/XAMPP/xamppfiles/bin/mysqld_safe --datadir=/Applications/XAMPP/xamppfiles/var/mysql --pid-file=/Applications/XAMPP/xamppfiles/var/mysql/sgordon.local.pid
-2 1667 1562 0 2:38PM ttys000 0:00.49 /Applications/XAMPP/xamppfiles/sbin/mysqld --basedir=/Applications/XAMPP/xamppfiles --datadir=/Applications/XAMPP/xamppfiles/var/mysql --user=nobody --log-error=/Applications/XAMPP/xamppfiles/var/mysql/sgordon.local.err --pid-file=/Applications/XAMPP/xamppfiles/var/mysql/sgordon.local.pid --socket=/Applications/XAMPP/xamppfiles/var/mysql/mysql.sock --port=3306