need help with MySQLdb
Wolfram Kraus
kraus at hagen-partner.de
Thu Jun 30 02:41:37 EDT 2005
nephish at xit.net wrote:
> 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?
>
> thanks
>
Try the following from the shell (NOT the python shell):
mysql -u user -p
[Enter passwd]
mysql> show databases;
If MyDB isn't in the list either something went wrong with the xampp
installation or the database for xampp got a different name. (I am no
xampp expert, so I can't help you any further)
HTH,
Wolfram
More information about the Python-list
mailing list