Michael, Thanks for the response. The configuration of the username was indeed the problem!
Meg On Tuesday, May 19, 2015 at 5:04:21 PM UTC-6, Michael Bayer wrote: > > > > On 5/19/15 6:53 PM, Margaret Tilton wrote: > > Hello, > > If there is documentation on this that I missed, please let me know. > > I have code that worked fine when I was using a MySQL database. My > organization has switched to using MariaDB, which I was told was virtually > identical to MySQL. It seems can connect to a MariaDB db using the > following statement, which doesn't generate any errors: > > engine = > create_engine('mysql+pymysql://[user]:[password@[server]/[db]', > pool_recycle=3600) > > Then the script tries to execute a simple select statement that worked > fine on MySQL: > > check_for_table = "SELECT * FROM tb_metadata" > table_result = session.execute(check_for_table) > > At this point the script throws an error > ("sqlalchemy.exc.OperationalError: (OperationalError) (1045, u"Access > denied for user XXX")" > > > that issue is not within SQLAlchemy, it has to do with the configuration > of the username which you are connecting with as well as the host > configuration. You should try testing first with the "mysql" command > line client. Take a look at > https://mariadb.com/kb/en/mariadb/configuring-mariadb-for-remote-client-access/ > > for configuration instructions. > > > > > Any ideas? I would like to keep using SQLAlchemy if possible. > > Thank you, > > Meg > -- > 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+...@googlegroups.com <javascript:>. > To post to this group, send email to sqlal...@googlegroups.com > <javascript:>. > Visit this group at http://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. > > > -- 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 http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.