use python to access mysql

Question

i am finally starting with python. i wanted to ask if i use the mysql db with python, how should i expect python to connect to the db? what i mean is, i have mysql installed in xampp and have my database created in mysql through php myadmin. now my python is in C:\python25\ and my *.py files would be in the same folder as well. now do i need any prior configuration for the connection?

what i am doing now

>>> cnx = MySQLdb.connect(host=’localhost’, user=’root’, passwd=’’,  db=’tablename’)
SyntaxError: invalid syntax

how do i need to go around this?

OctaneFX · Accepted Answer · 2009-08-22 21:48:39Z

4

the basics is

import MySQLdb

conn = MySQLdb.connect(host="localhost", user="root", passwd="nobodyknow", db="amit")
cursor = conn.cursor()

stmt = "SELECT * FROM overflows"
cursor.execute(stmt)

# Fetch and output
result = cursor.fetchall()
print result

# get the number of rows
numrows = int(cursor.rowcount)

# Close connection
conn.close()

and don´t use ’ use single or double ' ou " quotes

answered Aug 22, 2009 at 21:48

OctaneFX

1067 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

S.Lott · Accepted Answer · 2009-08-22 21:40:27Z

2

If you simply cut and pasted, you have the wrong kind of quotes.

You've got some kind of asymmetric quote.

Use simple apostrophes ' or simple quotes ".

Do not use ’ .

answered Aug 22, 2009 at 21:40

S.Lott

393k83 gold badges520 silver badges791 bronze badges

2 Comments

pavium Over a year ago

The path (C:\python25\) tells us that Windows is being used. The substitution of so-called smart quotes for the real thing is one of Windows' more irritating habits.

Soviut Over a year ago

This isn't a windows issue, its a blog/wordpress issue where he copied the original connection code from. A lot of newer blogging engines pretty up the quotes if the poster isn't careful to identify a block as code.

Collectives™ on Stack Overflow

use python to access mysql

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related