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, uAccess
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.