I tried sqlit. it is fine.
engine = create_engine('sqlite+pysqlite:///file.db')
but, MySQL can't connect.
2012年3月21日水曜日12時46分23秒 UTC+9 shinriyo:
>
> 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?*
>
>
2012年3月21日水曜日12時46分23秒 UTC+9 shinriyo:
>
> 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/-/F9BC0dTCw8oJ.
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.
