python mysql connection problem

Question

This code works fine:

import  MySQLdb

db = MySQLdb.connect("localhost", "root", "","bullsorbit")
cursor = db.cursor()

cursor.execute("Select * from  table  where  conditions'")
numrows = int(cursor.rowcount)

print 'Total number of Pages :  %d ' % numrows

but if I give my IP address

db = MySQLdb.connect("192.168.*.*", "root", "","bullsorbit")

it will give this error

super(Connection, self).__init__(*args, **kwargs2)
_mysql_exceptions.OperationalError: (2003, "Can't connect to MySQL server on 'ip address' (111)")

Is your server configured to allow the root to login on a non-localhost connection? — Stephen Edmonds
– Stephen Edmonds, Commented Jul 22, 2009 at 9:19

lutz · Accepted Answer · 2009-07-22 10:17:09Z

5

Code 2003 is a standard MySQL client error:

Error: 2003 (CR_CONN_HOST_ERROR) Message: Can't connect to MySQL server on '%s' (%d)

I'd guess that your user is not allowed to connect to the MySQL server using an iP-address. What happens if you try a connection usign the MySQL commandline client?

$ mysql --host=192.168.1.1 -u root bullsorbit

answered Jul 22, 2009 at 10:17

lutz

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

2 Comments

rajaneesh Over a year ago

ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.5.23' (111)

lutz Over a year ago

So your problem has nothing to do with Python. You must give the user the permission to connect from the IP address of your local machine.

Blauohr · Accepted Answer · 2009-07-22 09:33:02Z

3

with localhost you connect via loopback-interface.

with ip-addr you connect - as you connect from extern.

if your server allows only the local (loopback) connection your ip-addr connection fails. (security!)

look at your mysql config, maybe only local-connections are allowed.

is the skip-networking switch off (in the mysql-conf) ?

#skip-networking

edited Jul 22, 2009 at 9:33

answered Jul 22, 2009 at 9:18

Blauohr

6,0032 gold badges28 silver badges31 bronze badges

Comments

demongolem · Accepted Answer · 2013-01-02 16:06:39Z

1

For the 2003 error, another possibility is that too many connections are being attempted in too short of time. I noticed this same behavior when I had 127.0.0.1 as my connect string. First I replaced it with localhost which got me further but still the same 2003 error. Then I saw that if I scaled back the number of calls the error disappeared completely.

answered Jan 2, 2013 at 16:06

demongolem

9,76436 gold badges97 silver badges107 bronze badges

Comments

unmounted · Accepted Answer · 2009-07-22 09:19:52Z

0

Instead of:

db = MySQLdb.connect("192.168..", "root", "","bullsorbit")

try:

db = MySQLdb.connect(user="root", host="192.168..", db="bullsorbit")

Password will default to empty string and try the usual identity methods. Host will also default to localhost on default port.

answered Jul 22, 2009 at 9:19

Collectives™ on Stack Overflow

python mysql connection problem

4 Answers 4

2 Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related