Python database creation - MySQL error

Question

I have been trying to create a database in python using the MySQL module. Here's the code:

import MySQLdb
conn = MySQLdb.connect(host = '127.0.0.1', user='root', passwd='', db='test', port='3306')
cursor = conn.cursor()
cursor.execute("SELECT VERSION()")
row = cursor.fetchone()
print "server version:",row[0]
cursor.close()
conn.close()

I had errors in initial steps relating to the host name, which I changed from localhost to the local IP and added a port keyword which seems to work with the quotes only. Apart from this, I am encountering the following error:

Traceback (most recent call last):
  File "C:\Python27\server_version", line 4, in <module>
    conn = MySQLdb.connect(host = '127.0.0.1', user='root', passwd='', db='bhavin', port='3306')
  File "C:\Python27\lib\site-packages\MySQLdb\__init__.py", line 81, in Connect
    return Connection(*args, **kwargs)
  File "C:\Python27\lib\site-packages\MySQLdb\connections.py", line 187, in __init__
    super(Connection, self).__init__(*args, **kwargs2)
TypeError: an integer is required

alecxe · Accepted Answer · 2015-01-02 07:12:14Z

1

port should be an integer, not a string:

conn = MySQLdb.connect(host='127.0.0.1', 
                       user='root', 
                       passwd='', 
                       db='test', 
                       port=3306)

Though, note that 3306 is a default port used if not provided explicitly:

port

TCP port of MySQL server. Default: standard port (3306).

answered Jan 2, 2015 at 7:12

alecxe

476k127 gold badges1.1k silver badges1.2k bronze badges

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

8 Comments

user3451879 Over a year ago

that gives me the following error: Traceback (most recent call last): File "C:\Python27\server_version", line 4, in <module> conn = MySQLdb.connect(host = '127.0.0.1', user='root', passwd='', db='test', port=3306) File "C:\Python27\lib\site-packages\MySQLdb_init_.py", line 81, in Connect return Connection(*args, **kwargs) File "C:\Python27\lib\site-packages\MySQLdb\connections.py", line 187, in init super(Connection, self).__init__(*args, **kwargs2) OperationalError: (2003, "Can't connect to MySQL server on '127.0.0.1' (10061)")

alecxe Over a year ago

@user3451879 and this is a different problem.

user3451879 Over a year ago

its taking 10061 as default port

alecxe Over a year ago

@user3451879 nope, 10061 is not a port here.

alecxe Over a year ago

@user3451879 first of all, make sure your credentials are correct and MySQL server is up and running.

|

Fabian Loayza · Accepted Answer · 2015-01-02 07:17:43Z

0

Any way you are not creating a db table with that code, you are going to get an error, like "No such table exists" or something like that. Your should try: CREATE TABLE IF NOT EXISTS(" // columns of your table with the type like integer or varchar

answered Jan 2, 2015 at 7:17

Fabian Loayza

153 bronze badges

Collectives™ on Stack Overflow

Python database creation - MySQL error

2 Answers 2

8 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

8 Comments

Comments

Related