Hey there all,
i have a question about how to point my python install to my sql database.

when i enter this:

db = MySQLdb.connect(user="user", passwd="pass", db="myDB")

i get this:

Traceback (most recent call last):
  File "<pyshell#1>", line 1, in -toplevel-
    db = MySQLdb.connect(user="user", passwd="pass", db="MyDB")
  File "/usr/lib/python2.4/site-packages/MySQLdb/__init__.py", line 66, in Connect
    return Connection(*args, **kwargs)
  File "/usr/lib/python2.4/site-packages/MySQLdb/connections.py", line 134, in __init__
    super(Connection, self).__init__(*args, **kwargs2)
OperationalError: (1049, "Unknown database 'MyDB'")

i am using the all in one package from lampp (now xampp) and i have tested a couple of python scripts from the cgi, but.... nothing that connects to the database.

any ideas?


oh, nevermind. got it fixed now.
had my SQL environment messed up.

You are getting into some pretty fancy coding! Nice to let us know what you are doing! May the power of Python be with you!

Hey thanks !

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.