Hi there
I use sqlalchemy and Python3.2 and pymysql on Windows7.
I tried below
from sqlalchemy import *
engine = create_engine('mysql+pymysql://teaspoon:teaspoon@localhost/teaspoon')
metadata = MetaData()
t = Table('mytable', metadata,
Column('mytable_id', Integer, primary_key=True)
)
metadata.create_all(engine)
But, error occurd
sqlalchemy.exc.InternalError: (InternalError) (1045, "#28000Access denied for
user 'teaspoon'@'localhost' (using password: YES)") None None
So, I tried via console. (DOSprompt)
*It it connect? => It is OK!*
c:\xampp\mysql\bin\mysql.exe -u teaspoon -p
*Can user use database? => It is OK!*
mysql> use teaspoon
Database changed
*Can user create? => It is OK!*
mysql> CREATE TABLE teaspoon(id INT(11)
Query OK, 0 rows affected (0.07 sec)
I have no idea.
*Would you tell me why mysql deny?*
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/sqlalchemy/-/JwFed_O_iu0J.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
