Python MySQL.connect() question

[Jim Conger]

Boudewijn,

Thanks you for the quick response.  I'm still missing something.  Here is my
attempt to follow you example.  First I check that mySQL is running using
mysqladmin, and then attempt to connect in python:

$ mysqladmin -ppassword processlist

| Id | User | Host     | db | Command  | Time | State | Info
| 12 | jimc | localhost |    | Processes | 0 |    |     |

$ python
Python 1.5.1...........
>>> import MySQL;
>>> self.dbConnection = MySQL.connect("localhost","jimc","password")
Traceback (innermost last):
  File "<stdin>", line 1, in ?
MySQL.error: Can't connect to local MySQL server
>>>

Does mySQL need to be already connected to a DB?  If so how?  I'm sure it is
obvious, but I can't figure it out!

Regards,
Jim Conger
www.regnoc.com


Boudewijn Rempt wrote:

> Jim Conger <jimc at regnoc.com> wrote:
> > I have mySQL running on a RH Linux 6.1 box, and have added the
> > MySQLmodule.so to my python library.  I can't figure out how to connect
> > within python.  My attempts look like:
>
> >>>> import MySQL;
> >>>> db = MySQL.connect();
> > Traceback (innermost last):
> >   File "<stdin>", line 1, in ?
> > MySQL.error: Can't connect to local MySQL server
> >>>>
>
> I'm not really surprised - I think you need to supply
> some parameters:
>
>     hostname="essle"
>                 username="boud"
>                 password=""
>                 databasename="languages"
>     self.dbConnection = MySQL.connect(hostname,username,password)
>           self.dbConnection.selectdb(databasename)
>
> Which is what I did when I used MySQLmodule; however, I've since
> began using the DB-API II compliant MySQLdb, but I miss some of
> the conveniences of MySQLmodule.
>
> --
>
> Boudewijn Rempt  | http://www.valdyas.org

--
Jim Conger
Project Manager
Silicon Valley Oil Co.
jimc at regnoc.com, 925-842-6729