CFMX 7 cannot add MySQL datasource

[game_on]

Hi. I have installed CFMX 7 and its working amazing. I have a local MySQL
databse running on 127.0.0.1 port 3306. I am trying to add a datasource but
keep getting errors. CF Data Source Name: MyDataSourceName Database: TestDB
Server: 127.0.0.1 port 3306 Username: root Password: password This results in
the following error: Connection verification failed for data source:
MyDataSourceName java.sql.SQLException: Communication failure during handshake.
Is there a server running on 127.0.0.1:3306? The root cause was that:
java.sql.SQLException: Communication failure during handshake. Is there a
server running on 127.0.0.1:3306? I read in the support notes that I should
try 'local' as the hostname - but that results in the error: Connection
verification failed for data source: MyDataSourceName java.sql.SQLException:
Cannot connect to MySQL server on 'local':3306. Is there a MySQL server running
on the machine/port you are trying to connect to?
(java.net.UnknownHostException) The root cause was that: java.sql.SQLException:
Cannot connect to MySQL server on 'local':3306. Is there a MySQL server running
on the machine/port you are trying to connect to?
(java.net.UnknownHostException) Help - I need to demo it working with some
data to my boss.... M@)

[BobJP]

Hi,

I googled the error message and I got this as a possible solution:

change the authentication method at the mysql server:
set password for <username>@<servername> = old_password('<password>');

[cf_menace]

The MySQL drivers that ship with CFMX 7 olny work for MySQL 3.23 through 4.0.x.

If you're running MySQL 4.1, you need to either configure it to use the
[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=6ef0253[/url] to see how
to setup the latest Connector J JDBC drivers from MySQL.

[mpwoodward *TMM*]

cf_menace wrote:

> The MySQL drivers that ship with CFMX 7 olny work for MySQL 3.23 through 4.0.x.
>
> If you're running MySQL 4.1, you need to either configure it to use the
> [url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=6ef0253[/url] to see how
> to setup the latest Connector J JDBC drivers from MySQL.
>

Yep, you can handle this situation either way that's been posted.
Either you rehash your passwords within MySQL, or you use the updated
MySQL JDBC driver (which I would recommend).

Matt

--
Matt Woodward
Team Macromedia - ColdFusion

[game_on]

Thanks loads - will give it a go.... M@)