need help with MySQLdb

[nephish]

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(*arg s, **kwargs)
File "/usr/lib/python2.4/site-packages/MySQLdb/connections.py" , line
134, in __init__
super(Connectio n, self).__init__( *args, **kwargs2)
OperationalErro r: (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

[Wolfram Kraus]

ne*****@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(*arg s, **kwargs)
File "/usr/lib/python2.4/site-packages/MySQLdb/connections.py" , line
134, in __init__
super(Connectio n, self).__init__( *args, **kwargs2)
OperationalErro r: (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

[Dennis Lee Bieber]

On 29 Jun 2005 21:56:49 -0700, ne*****@xit.net declaimed the following
in comp.lang.pytho n:

any ideas?
Step 1: show us what the interactive command line tool "mysql"
does with...
mysql user -p
pass
use MyDB;

IOW, verify you can connect to the database using the MySQL
tools first, then figure out what is different with the MySQLdb call.

-- =============== =============== =============== =============== == <
wl*****@ix.netc om.com | Wulfraed Dennis Lee Bieber KD6MOG <
wu******@dm.net | Bestiaria Support Staff <
=============== =============== =============== =============== == <
Home Page: <http://www.dm.net/~wulfraed/> <
Overflow Page: <http://wlfraed.home.ne tcom.com/> <

[Dennis Lee Bieber]

On Thu, 30 Jun 2005 06:47:18 GMT, Dennis Lee Bieber
<wl*****@ix.net com.com> declaimed the following in comp.lang.pytho n:

On 29 Jun 2005 21:56:49 -0700, ne*****@xit.net declaimed the following
in comp.lang.pytho n:

any ideas?
Step 1: show us what the interactive command line tool "mysql"
does with...
mysql user -p
pass
use MyDB;

IOW, verify you can connect to the database using the MySQL
tools first, then figure out what is different with the MySQLdb call.

{okay, slight error in the command line string -- I haven't ported MySQL
from the old W98 machine to the WinXP machine yet}

-- =============== =============== =============== =============== == <
wl*****@ix.netc om.com | Wulfraed Dennis Lee Bieber KD6MOG <
wu******@dm.net | Bestiaria Support Staff <
=============== =============== =============== =============== == <
Home Page: <http://www.dm.net/~wulfraed/> <
Overflow Page: <http://wlfraed.home.ne tcom.com/> <

[Wolfram Kraus]

nephish wrote:
[...]

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

after i entered the password it told me it cannot connect to mysql through
socket /tmp/mysql.sock

hmmmm.
hope this helps

Please keep the discussion on the list

Try
mysql -u user -p -h 127.0.0.1

HTH,
Wolfram