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.
