Newbie: How to connect to MySQL?

[Steve Holden]

The problem appears to be either that MySQl itself is not installed, or that
it's installed in a non-standard location.

Obviously you can get over the former problem by installing it! The latter
will require a little editing of the setup.py file to tell it where to find
MySQL. I seem to remember that Andy Dustman has commented the code fairly
well to make this possible.

Good luck!

regards
--
Steve Holden                                  http://www.holdenweb.com/
Python Web Programming                 http://pydish.holdenweb.com/pwp/
Bring your musical instrument to PyCon!    http://www.python.org/pycon/

----- Original Message -----
From: "Eduardo Cancino" <webmaster at ciceana.org.mx>
To: "Steve Holden" <sholden at holdenweb.com>; <python-list at python.org>
Sent: Wednesday, January 15, 2003 2:23 PM
Subject: Re: Newbie: How to connect to MySQL?


> What i meant about it doesn't find my compiler is:
>
> when i type "python setup.py build"
>
> this is the end of the message:
>
> ld: warning -L: directory name (/usr/lib/mysql) does not exist
> ld: warning -L: directory name (/usr/local/lib/mysql) does not exist
> ld: warning -L: directory name (/usr/local/mysql/lib/mysql) does not
> exist
> ld: warning -L: directory name (/sw/lib) does not exist
> ld: can't locate file for: -lmysqlclient_r
> error: command 'gcc' failed with exit status 1
>
> and gcc is installed in /usr/bin/gcc
>
> not the python interpreter, that was installed by me from source
> and it is working flawlessly
>
> i really wan't to know about CGI Module, because that's is my primary
> intention.
>
> Thank you.
>
>
>
> On Wednesday, January 15, 2003, at 10:43 AM, Steve Holden wrote:
>
> > "Eduardo Cancino" <lalo at ciceana.org.mx> wrote in message
> > news:mailman.1042643607.2959.python-list at python.org...
> >> Hi everybody!
> >>
> >> I downloaded the mysql-python from sourceforge, and I tried to install
> >> it on my Mac0S 10.2.1
> >> but even i have the Developer tools the:
> >>
> >> python setup.py build
> >> python setup.py install
> >>
> >> commands doesn't find my compiler.
> >>
> >> I looked in www.python.org, some of this but didn't find it.
> >>
> >> Where I cand find a installing tutorial or something i can get to
> >> start
> >> programming python with databases?
> >>
> >> Is there a db module like dbi in perl?
> >> And the cgi module works as the perl one?
> >>
> >>
> >
> > Eduardo:
> >
> > I can't answer your question as to why your command-line isn't finding
> > the
> > Python interpreter. That's another issue. However, if you're sure you
> > have
> > /usr/bin/python then as long as setup.py is marked as executable the
> > command
> >
> >     setup.py build
> >
> > should work.
> >
> > As far as your questions about "is there a db module", Python database
> > modules should conform the the Python DB API version 2, thereby
> > offering a
> > reasonably standard interface. You can find a description at
> >
> >     http://www.python.org/peps/pep-0249.html
> >
> > The MySQLdb module you have downloaded offers a fairly complete
> > implementation, along wiht a few added tweaks and wrinkles like
> > "dictionary
> > cursors".
> >
> > As for the CGI module: walk before you run! ;-)
> >
> > regards
> > --
> > Steve Holden                                  http://www.holdenweb.com/
> > Python Web Programming                 http://pydish.holdenweb.com/pwp/
> > Bring your musical instrument to PyCon!    http://www.python.org/pycon/
> >
> >
> >
> > --
> > http://mail.python.org/mailman/listinfo/python-list
> >
>
>
>