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.
