I have ColdFusion MX and MySQL running on a Windows XP PC. Iím trying to create a data source in the ColdFusion admin. Iíve tried dozens of times but keep getting and error. Connection verification failed for data source: ken
[]java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info.
The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. Iím guessing one of these parameters is wrong. Below is what I think they should be. Can I use WinMySQLadmin to find out exactly what information to use? CF Data Source Name: kenDatabase: test (the empty database installed when installing MySQL)Server: (local)Port: 8500 (also tried 3306)Username: (username used to login CF Admin) Password: (password used to login CF Admin) Can someone point be in the right direction? PLEASEÖÖÖÖÖ