By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,996 Members | 1,498 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,996 IT Pros & Developers. It's quick & easy.

need help with MySQLdb

P: n/a
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

Jul 19 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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(*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
Jul 19 '05 #2

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

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.netcom.com | Wulfraed Dennis Lee Bieber KD6MOG <
wu******@dm.net | Bestiaria Support Staff <
================================================== ============ <
Home Page: <http://www.dm.net/~wulfraed/> <
Overflow Page: <http://wlfraed.home.netcom.com/> <

Jul 19 '05 #3

P: n/a
On Thu, 30 Jun 2005 06:47:18 GMT, Dennis Lee Bieber
<wl*****@ix.netcom.com> declaimed the following in comp.lang.python:
On 29 Jun 2005 21:56:49 -0700, ne*****@xit.net declaimed the following
in comp.lang.python:

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.netcom.com | Wulfraed Dennis Lee Bieber KD6MOG <
wu******@dm.net | Bestiaria Support Staff <
================================================== ============ <
Home Page: <http://www.dm.net/~wulfraed/> <
Overflow Page: <http://wlfraed.home.netcom.com/> <

Jul 19 '05 #4

P: n/a
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
Jul 19 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.