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