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 [email protected] <javascript:>.
> To post to this group, send email to [email protected]
> <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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
