it seems like you connect without a host using mysql.exe, so try:
create_engine('mysql+pymysql://teaspoon:teaspoon@/teaspoon')
otherwise you need to add an entry for 'teaspoon'@'localhost' to your user
table:
http://dev.mysql.com/doc/refman/5.0/en/connection-access.html
On Mar 21, 2012, at 10:48 PM, shinriyo wrote:
> 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.
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
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.
