Datasource on MySql

[plarts]

Trying to set up a datasource on MySql : I had an error message as in this link
below. I followed this information :
[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=6ef0253[/url] Which
says :
--------------------------------------------------------------------------------
-------------------------------- When using the MySQL Driver provided in the
list of driver options in the ColdFusion MX Administrator to connect to a MySQL
4.1 database, the following error may occur: Connection verification failed
for data source: mysql_bad java.sql.SQLException: Communication failure during
handshake. Is there a server running on localhost:3306? The root cause was
that: java.sql.SQLException: Communication failure during handshake. Is there a
server running on localhost:3306? Reason The MySQL 4.1 database
authentication mechanism has changed since earlier versions, and earlier MySQL
JDBC drivers will not work unless either MySQL is configured to use the former
authentication mechanism or a current version of the driver is used instead.
Solution To connect to a MySQL 4.1 database from ColdFusion MX: Download a
current, stable version of the MySQL Connector J JDBC driver, available at:
[url]http://dev.mysql.com/doc/connector/j/en/index.html[/url] Extract the
mysql-connector-java-3.{n}-bin.jar file from the downloaded archive file. Save
the mysql-connector-java-3.{n}-bin.jar file in the cf_root/WEB-INF/lib
directory. Restart the ColdFusion MX server. Add a new data source to the
ColdFusion MX Administrator, using the driver option Other. Enter the JDBC
URL: jdbc:mysql://[host]:[port]/[database] Enter the Driver Class:
com.mysql.jdbc.Driver Complete username/password, and adjust other data source
settings, if needed. Submit the data source for verification.
--------------------------------------------------------------------------------
----------- But this form ask me an other field which I do not know what to
answer : Driver name ? ok for JDBC URL ok for driver class when submitting, I
have this message : Echec de v?rification de la connexion pour la source de
donn?es : test_mysql []java.sql.SQLException: No suitable driver available for
test_mysql, please check the driver setting in resources file, error:
com.mysql.jdbc.Driver The root cause was that: java.sql.SQLException: No
suitable driver available for test_mysql, please check the driver setting in
resources file, error: com.mysql.jdbc.Driver Also the procedure says : Save
the mysql-connector-java-3.{n}-bin.jar file in the cf_root/WEB-INF/lib
directory. What is : cf_root/WEB-INF/lib ? what is cf_root ? I have a
CFusionMX directory with 'WEB-INF/lib' in the wwwroot of CFusionMX but I use
IIS as HTTP server, and there is no 'WEB-INF/lib' in the wwwroot directory.
Is there somewhere a clear and complete procedure to set up a datasource on
MySql ? Thanks to help this mes. Pierre.

[plarts]

I answer myself I found the solution by chance. - The driver name can be
empty (blank) - the mysql-connector-java-3.{n}-bin.jar has been put in the CF
directory : cfusionmx/wwwroot/WEB-INF/lib - I have another wwwroot
under IIs , nothing need to be done there. Pierre.