OOPs, my mistake. Simon, your command is running fine. But it still doesn't
work in sqlalchemy ORM code:
Traceback (most recent call last):
File "saintdb_data_model.py", line 55, in <module>
execute =
create_engine('mysql://root:[email protected]:3306').connect().execute
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
1649, in connect
return self._connection_cls(self, **kwargs)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
59, in __init__
self.__connection = connection or engine.raw_connection()
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
1707, in raw_connection
return self.pool.unique_connection()
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 220,
in unique_connection
return _ConnectionFairy(self).checkout()
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 425,
in __init__
rec = self._connection_record = pool._do_get()
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 777,
in _do_get
con = self._create_connection()
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 225,
in _create_connection
return _ConnectionRecord(self)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 318,
in __init__
self.connection = self.__connect()
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 368,
in __connect
connection = self.__pool._creator()
File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/strategies.py", line
80, in connect
return dialect.connect(*cargs, **cparams)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py",
line 279, in connect
return self.dbapi.connect(*cargs, **cparams)
File "/usr/lib/python2.7/dist-packages/MySQLdb/__init__.py", line 81, in
Connect
return Connection(*args, **kwargs)
File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 187, in
__init__
super(Connection, self).__init__(*args, **kwargs2)
sqlalchemy.exc.OperationalError: (OperationalError) (1045, "Access denied for
user 'root'@'mypc.local' (using password: YES)") None None
Do you or anyone else here have any idea? Thanks a lot.
LYH
--
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?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
