AdobeStock_455007340

MySQL 5 Released

Home » MySQL 5 Released

The long awaited MySQL 5 has been released. New to this significantly update are views, triggers, stored procedures, and more. I’ve been using MySQL 5 since very early beta days, and it has been solid and stable (and every bug I reported has been fixed). Download your copy now.

18 responses to “MySQL 5 Released”

  1. Lola Lee Avatar
    Lola Lee

    Will this work with CF7? I’m sure there is an updated JDBC driver to be found at the MySQL site.

  2. John Farrar Avatar
    John Farrar

    I downloaded a previous jdbc driver from the site and it was working with the mySQL 5 beta. I have not tried the final release yet.

  3. Rick Smith Avatar
    Rick Smith

    All is working well for me. 🙂 I really hope Macrobe adds support for mySQL 4.x and 5.x in the next CF7 updater.

  4. Rick Smith Avatar
    Rick Smith

    For those of you who don’t know what we’re talking about and just want to run mySQL 5 with ColdFusion, read up on this tech note as it still applies:
    http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=6ef0253
    🙂

  5. Rick Smith Avatar
    Rick Smith

    actually… the connector link on the tech note is bad. The link to the connector is now:
    http://dev.mysql.com/downloads/connector/j/

  6. Ben Forta Avatar
    Ben Forta

    Thanks for posting that, Rick.

  7. John2 Avatar
    John2

    Hi
    I have tried to get this working but I get the following error:
    Connection verification failed for data source: abachi
    java.sql.SQLException: Illegal connection port value ‘[3307]’
    The root cause was that: java.sql.SQLException: Illegal connection port value ‘[3307]’
    I am running on port 3307, as mysql4 is on 3306

  8. John2 Avatar
    John2

    lol
    my bad… had port in [] – just delete this and last post, thanks

  9. Lon Bentkower Avatar
    Lon Bentkower

    I am trying to use ColdFusion 7.0 with MySQL 5.1 with a Windows XP OS. Has anyone been successful with this combination? If so, what was involved with respect to MySQL drivers and CF data source connections?
    Any help would be appreciated.

  10. Lon Bentkower Avatar
    Lon Bentkower

    I am trying to use ColdFusion 7.0 with MySQL 5.1 with a Windows XP OS. Has anyone been successful with this combination? If so, what was involved with respect to MySQL drivers and CF data source connections?
    Any help would be appreciated.

  11. Lon Bentkower Avatar
    Lon Bentkower

    I am trying to use ColdFusion 7.0 with MySQL 5.1 with a Windows XP OS. Has anyone been successful with this combination? If so, what was involved with respect to MySQL drivers and CF data source connections?
    Any help would be appreciated.

  12. Shimju Avatar
    Shimju

    Can anybopdy helps me when ever I tried to create DSN on Coldfusion MX7.0.1 administarrtaor for MYSQL 5 DB using built-in MYSQL driver, Iam getting the following error
    "
    Connection verification failed for data source: chc_engine
    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?"
    Please help

  13. shimju Avatar
    shimju

    Well I found out the solution to above problem.
    Follow the below steps:
    1) Download the MySQL Connector J JDBC driver from http://dev.mysql.com/downloads/connector/j/
    2) Make the JDBC driver available to CFMX through the classpath by saving mysql-connector-java-3.0-bin.jar in either $CFMX_HOME/runtime/servers/lib/ for CFMX Server Configuration or $JRUN_HOME/servers/lib/ for CFMX on JRun
    Configuration. This makes the driver available to all JRun server instances.
    3)Restart CFMX server.

  14. Danilo Mello Avatar
    Danilo Mello

    oh those damn brackets…

  15. D. Roger Maves Avatar
    D. Roger Maves

    I am testing CF7 with MySQL 5.0 and have run into a problem with MySQL’s DATA LOAD.
    I’m using the following jdbc driver:
    mysql-connector-java-3.1.10-bin.jar
    Here’s my code:
    <cfquery name="ImportIDXRes" datasource="cayrealestate-import">
    LOAD DATA LOCAL
    INFILE ‘c:/IDX-data/20061211_listings_res.txt’
    INTO TABLE idx_res
    FIELDS TERMINATED BY ‘,’
    ENCLOSED BY ‘"’
    IGNORE 1 LINES
    </cfquery>
    The error I’m getting is:
    Data truncation: Out of range value adjusted for column ‘l_br’ at row 5
    This error can vary with the text file being imported, for example this is the error I got on the next day’s attempt:
    Data truncation: Out of range value adjusted for column ‘u_sq’ at row 5
    This code has been running fine with MySQL 4.0 and the same driver.
    Has anyone tested DATA LOAD with MySQL 5.0?
    Is this a driver problem or some other kind of problem.

  16. Doron Katz Avatar
    Doron Katz

    Hi. Trying to get MYSQL 5 on my ColdFusion on Mac platform, I have copied the mysql-connector-java-5.0.4-bin.jar to the servers/lib in the JRUN folder and still get the error:
    Connection verification failed for data source: CFLearning
    java.sql.SQLException: No suitable driver available for CFLearning, please check the driver setting in resources file, error: null
    The root cause was that: java.sql.SQLException: No suitable driver available for CFLearning, please check the driver setting in resources file, error: null
    If Anyone knows the cause of this , I would be most appreciative. Thanks

  17. Christy Avatar
    Christy

    I’ve tried the 5.0.5 and the 3.0.17 Connectors, I still get the same error.

  18. Andrew Davey Avatar
    Andrew Davey

    I was having the same problem as everyone else using CFMX7, mySql 5 and Windows XP until I read shimju’s post above regarding where to copy the jar file if you are using JRun4 as your server.
    Theirs a couple of hours I’ll never get back.

Leave a Reply