AppletTalk.com Java discussions newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  mysql-connector-java-3.1.7-bin.jar          AppletTalk.com Forum Index -> Java and Databases View previous topic :: View next topic   Author Message Ike Guest Posted: Fri Jan 20, 2006 5:13 pm    Post subject: mysql-connector-java-3.1.7-bin.jar I am using : mysql-connector-java-3.1.7-bin.jar to connect to a MySQL database on a MySQL server ver 4.0.25. After Mysql 4.1.1 there is a new password hashing algorithm involved. Does anyone know if mysql-connector-java-3.1.7-bin.jar will work with MySQL 5.x ? Thanks, Ike Back to top Roedy Green Guest Posted: Fri Jan 20, 2006 10:22 pm    Post subject: Re: mysql-connector-java-3.1.7-bin.jar On Fri, 20 Jan 2006 17:13:40 GMT, "Ike" <rxv (AT) hotmail (DOT) com> wrote, quoted or indirectly quoted someone who said : Quote: After Mysql 4.1.1 there is a new password hashing algorithm involved. Does anyone know if mysql-connector-java-3.1.7-bin.jar will work with MySQL 5.x ? Thanks, Ike Why would you deliberately use a mismatched pair? -- Canadian Mind Products, Roedy Green. http://mindprod.com Java custom programming, consulting and coaching. Back to top Ike Guest Posted: Sat Jan 21, 2006 2:18 am    Post subject: Re: mysql-connector-java-3.1.7-bin.jar It's not mismatched. In fact, that mysql connector works with both hashing algorithms under Mysql. The reason I asked is because I am forced, in this project, to use php 4.x which only works with the older hashing algorithm on mysql, so you have to adjust mysql to use the old style hashing algorithm. -Ike "Roedy Green" <my_email_is_posted_on_my_website (AT) munged (DOT) invalid> wrote in message news:5lo2t1t5lvm6vj6m9opdalpqjh48h30cr4 (AT) 4ax (DOT) com... Quote: On Fri, 20 Jan 2006 17:13:40 GMT, "Ike" <rxv (AT) hotmail (DOT) com> wrote, quoted or indirectly quoted someone who said : After Mysql 4.1.1 there is a new password hashing algorithm involved. Does anyone know if mysql-connector-java-3.1.7-bin.jar will work with MySQL 5.x ? Thanks, Ike Why would you deliberately use a mismatched pair? -- Canadian Mind Products, Roedy Green. http://mindprod.com Java custom programming, consulting and coaching. Back to top Roedy Green Guest Posted: Sat Jan 21, 2006 4:32 am    Post subject: Re: mysql-connector-java-3.1.7-bin.jar On Fri, 20 Jan 2006 17:13:40 GMT, "Ike" <rxv (AT) hotmail (DOT) com> wrote, quoted or indirectly quoted someone who said : Quote: After Mysql 4.1.1 there is a new password hashing algorithm involved I remember reading in the comments they suggested avoiding the password hash feature and using an explicit digest function. Perhaps they have that old function now exposed with a name to get at directly under new versions. -- Canadian Mind Products, Roedy Green. http://mindprod.com Java custom programming, consulting and coaching. Back to top Ike Guest Posted: Sat Jan 21, 2006 1:06 pm    Post subject: Re: mysql-connector-java-3.1.7-bin.jar It seems the new versions of the connector can still work with the old-style passwords. I had the password on the 5.x MySQL set to old-style, so that older versions of php could connect to it, and I am able to still connect under the newest versions of connectorJ. -Ike "Roedy Green" <my_email_is_posted_on_my_website (AT) munged (DOT) invalid> wrote in message news:18e3t1lad2gmmj538q5n59nrgsj9r6u4tl (AT) 4ax (DOT) com... Quote: On Fri, 20 Jan 2006 17:13:40 GMT, "Ike" <rxv (AT) hotmail (DOT) com> wrote, quoted or indirectly quoted someone who said : After Mysql 4.1.1 there is a new password hashing algorithm involved I remember reading in the comments they suggested avoiding the password hash feature and using an explicit digest function. Perhaps they have that old function now exposed with a name to get at directly under new versions. -- Canadian Mind Products, Roedy Green. http://mindprod.com Java custom programming, consulting and coaching. Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         AppletTalk.com Forum Index -> Java and Databases All times are GMT Page 1 of 1   Jump to: Select a forum Java Newsgroups----------------Java DiscussionsWeb-based java games comp.lang.java 3D Graphics API's for Java Java: Support and criticism Java System Announcements comp.lang.java.api JavaBeans Java and CORBA Java and Databases comp.lang.java.developer Java GUI Toolkits Java Help comp.lang.java.javascript JVM, native methods and hardware comp.lang.java.misc Java Language Programming Security and Java comp.lang.java.setup Java Software Tools comp.lang.java.tech ibm.software.java.linux  Non-English Java Newsgroups----------------Java Language (German)Language Java (Français)Java (Italian)  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.