Note the mysql-connector people actually contacted us this week on the devel list, and while mysql-connector-python does still have a lot of major issues they are not as bad as the ones I listed on the site, as apparently there is a totally different fork of it called mysql-connector also on pypi that is ancient so most of the problems were there. Current 8.x release still has binary data issues and possibly some lockup issues though.
On Tue, Mar 5, 2019 at 7:08 PM Warwick Prince <warwi...@mushroomsys.com> wrote: > > Hi Mike > > Thanks very much. It’s a shame they broke it so badly! I’ll change to your > recommendation immediately. > > Cheers > Warwick > > Warwick A. Prince > Mushroom Systems International Pty. Ltd. > > > On 5 Mar 2019, at 3:07 am, Mike Bayer <mike...@zzzcomputing.com> wrote: > > > >> On Sun, Mar 3, 2019 at 8:40 PM Warwick Prince <warwi...@mushroomsys.com> > >> wrote: > >> > >> Hi Community > >> > >> We’ve been using sqlalchemy with great success for many years. We’ve been > >> using the mysqlconnector to connect to my MySQL databases with no issues > >> to speak of. > >> > >> My issue is that I recently upgraded to the latest version of the > >> connector from Oracle which has changed from Python to C. I’m now > >> regularly receiving the following error where this has never happened in > >> the past; MySQL 5.6 BTW. > >> > >> DatabaseError: (mysql.connector.errors.HashError) Hashed authentication > >> data is invalid > >> > >> Obviously, I would assume that this is not a sqlalchemy issue, however > >> there’s nothing really being spoken about this anywhere else and I > >> wondered if anyone had had the problem and fixed it - or eventually rolled > >> back to the very old version of mysqlconnector? > > > > Unfortunately recent versions of MySQL connector, specifically when > > the C code was added, work very poorly, such that I had to remove > > mysql connector from testing. I documented a partial list of > > blocking issues I encountered here: > > https://docs.sqlalchemy.org/en/latest/dialects/mysql.html#current-issues > > > > > >> > >> Alternatively, @Mike - could you recommend in your opinion the ‘best’ > >> connector to use for MySQL based on reliability and performance. > > > > The best drivers for MySQL are mysqlclient and pymysql, both > > maintained by the same person. Both drivers work very well and are > > well supported. mysqlclient is a fork of the original C based > > python-mysql driver which is no longer maintained. > > > > > >> > >> Cheers > >> Warwick > >> > >> Warwick Prince > >> Managing Director > >> mobile: +61 411 026 992 > >> skype: warwickprince > >> phone: +61 7 3102 3730 > >> fax: +61 7 3319 6734 > >> web: www.mushroomsys.com > >> > >> -- > >> SQLAlchemy - > >> The Python SQL Toolkit and Object Relational Mapper > >> > >> http://www.sqlalchemy.org/ > >> > >> To post example code, please provide an MCVE: Minimal, Complete, and > >> Verifiable Example. See http://stackoverflow.com/help/mcve for a full > >> description. > >> --- > >> You received this message because you are subscribed to the Google Groups > >> "sqlalchemy" group. > >> To unsubscribe from this group and stop receiving emails from it, send an > >> email to sqlalchemy+unsubscr...@googlegroups.com. > >> To post to this group, send email to sqlalchemy@googlegroups.com. > >> Visit this group at https://groups.google.com/group/sqlalchemy. > >> For more options, visit https://groups.google.com/d/optout. > > > > -- > > SQLAlchemy - > > The Python SQL Toolkit and Object Relational Mapper > > > > http://www.sqlalchemy.org/ > > > > To post example code, please provide an MCVE: Minimal, Complete, and > > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > > description. > > --- > > You received this message because you are subscribed to the Google Groups > > "sqlalchemy" group. > > To unsubscribe from this group and stop receiving emails from it, send an > > email to sqlalchemy+unsubscr...@googlegroups.com. > > To post to this group, send email to sqlalchemy@googlegroups.com. > > Visit this group at https://groups.google.com/group/sqlalchemy. > > For more options, visit https://groups.google.com/d/optout. > > -- > SQLAlchemy - > The Python SQL Toolkit and Object Relational Mapper > > http://www.sqlalchemy.org/ > > To post example code, please provide an MCVE: Minimal, Complete, and > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > description. > --- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+unsubscr...@googlegroups.com. > To post to this group, send email to sqlalchemy@googlegroups.com. > Visit this group at https://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
