jpress连接不上mysql_解决Coldfusion连接MySQL数据库的问题

在连接MySQL时,出现了如下错误:

Connections to MySQL Community Server are not supported. Please contact MySQL to obtain a MySQL Enterprise or Commercial version.

解决方案:

step 1:

download the JDBC driver JDBC Driver for MySQL (Connector/J) here: http://dev.mysql.com/downloads/connector/j/.

in the Platform select box, choose platform independent

next, choose the tar or zip version appropriate for your platform. If you don't know which to pick, choose the zip version.

next, on the screen titled "Begin Your Download - mysql-connector-java-5.1.35.zip", scroll to the bottom and choose the small link "No thanks, just start my download."

finally, once the download completes, extract "mysql-connector-java-5.1.35-bin.jar" and put it in the lib directory of your CF install. For me it is located at: cfusion\lib (your platform and coldfusion edition impacts the path for you.

restart ColdFusion and validate your datasource in the ColdFusion Administrator.

step 2:

After you copy the JAR file to the /lib directory, you have to restart ColdFusion. Then you will be sure that the changes will take effect.

In the Administrator, give your new datasource a name. Select MySQL 5 from the list.

CF_MySQL_DSN_1.png

Press the Add button to create the datasource. You should then get the following user interface:

CF_MySQL_DSN_2.png

This contains the details of my database. Enter the details for yours. Press the Submit button.

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值