Data source connection problems with MYSQL

[revdave]

I am having some data source connection problems with MYSQL.

- MAC 10.4.6 tiger
- I just successfully installed ColdFusion 7.01
- also - I just successfully installed mysql plus other goodies using MAMP
- phpmyadmin let me create a test database at : [url]http://localhost:8888/MAMP[/url] ...
- this page tells me that I can connect to mySQL server using the following
connection parameters:
- host = localhost (port 8889) user = root password = root
- in the Cold fusion administrator I tried to create a new data source
- * the only driver type that was available was mySql 3.x * ( - not sure what
I believe that MAMP installed the latest MYSQL 5.??) ... maybe this driver is
the problem?
- database = test
- port = 889
- user name = root
- password = root

* error says Java. Sql sql exception: communication failure during handshake
is there a server running on local host: 8889?

Basically I am a novice trying to work with MYSQL....

* question: any ideas in have the correct this situation?

[tzimmerman]

See [url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=6ef0253[/url].

HTH

Ted Zimmerman

[revdave]

Yippee - that worked! Thank you very much for that info!

Now - another mysql issue...

- I tried to create another data source from my home Cold fusion
administrator 7.01 to a mysql test database that I have on the web
- for this I use the supplied mysql driver 3.0
- database = mytest
- server = mysite.com
- port was preset to 3306 - I don't know what my port is so I left it like
this
- user name = test
- password = test

* the error that came back =
' connection verification failed java.sql.sql exception: server denies access
to data source'

* question: why is this happening? Is there a way to fixit?

[revdave]

still curious how to connect to an outside source...any ideas?