Hi ,
Iam trying to use
from sqlalchemy.engine.url import URL
myDB = URL(drivername='mysql', host='localhost',
database='my_database_name',
query={ 'read_default_file' : '/path/to/.my.cnf' } )
engine = create_engine(name_or_url=
>
> myDB)
but it is not working form me. The error I am getting is
sqlalchemy.exc.OperationalError: (OperationalError) (1045, "Access denied
for user 'root'@'localhost' (using password: NO)") None None
This is occurring because SQLALCHEMY is not reading password from .my conf
file.
It is working fine if I give username and password as URL argument. The
my.conf file is
also correct which is working if pass it to mysql shell command.
Any comment on how to make SQLALCHEMY/MYSQL read password from file.
Thanks
Balaji
On Monday, September 29, 2008 at 2:48:18 PM UTC-7, Tom H wrote:
>
> Depending on security preferences, it may be desirable to keep
> database passwords out of code files.
>
> One of the recommendations for MySQL is to keep the password in
> a .my.cnf file accessible only to the user.
> http://dev.mysql.com/doc/refman/5.0/en/password-security.html
>
> To use the .my.cnf password in sqlalchemy, do something like the
> following:
>
> from sqlalchemy.engine.url import URL
> myDB = URL(drivername='mysql', host='localhost',
> database='my_database_name',
> query={ 'read_default_file' : '/path/to/.my.cnf' } )
> engine = create_engine(name_or_url=myDB)
> # use the engine as usual, no password needed in your code file :)
>
> This has been very useful to me, hopefully others find it helpful as
> well.
--
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.
