LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Programming (https://www.linuxquestions.org/questions/programming-9/)
-   -   Help me (python and MySQLdb module) (https://www.linuxquestions.org/questions/programming-9/help-me-python-and-mysqldb-module-171429/)

Dark Carnival 04-17-2004 05:53 PM

Help me (python and MySQLdb module)
 
Ok I run on a slackware 9.1 pc with python 2.3.3
And MySQLdb 0.92 (newest)

I try to connect to 10.0.0.4 (my local webserver running mysql 4.0.16)
I know mysql works because phpmyadmin has no troubles with running at all.

But when I run this:
#!/usr/bin/python
import MySQLdb
#connect to the database
db = MySQLdb.connect(host="10.0.0.4", port=3306, user="facepaint", passwd="xxxxxxxx", db="client_info")

I get this error:
Traceback (most recent call last):
File "./app.py", line 8, in ?
db = MySQLdb.connect(host="10.0.0.4", port=3306, user="facepaint", passwd="crl2d4lu", db="client_info")
File "/usr/lib/python2.3/site-packages/MySQLdb/__init__.py", line 63, in Connect
return apply(Connection, args, kwargs)
File "/usr/lib/python2.3/site-packages/MySQLdb/connections.py", line 115, in __init__
self._make_connection(args, kwargs2)
File "/usr/lib/python2.3/site-packages/MySQLdb/connections.py", line 41, in _make_connection
apply(super(ConnectionBase, self).__init__, args, kwargs)
_mysql_exceptions.OperationalError: (2003, "Can't connect to MySQL server on '10.0.0.4' (111)")

Exactly what am I doing wrong here ?
Thanks in advance!

ToniT 04-20-2004 03:18 AM

Is it running on same or in different computer?

Dark Carnival 04-22-2004 07:31 AM

It was running on a different computer. skip networking was off. I just went into phpmyadmin and found out my user weren't permitted to log in from another domain than localhost. Fixed and working now :)


All times are GMT -5. The time now is 09:12 AM.