[Zope] How-to Connect MySQL database with zope

Holger Lehmann holle@www.catworkx.de
Tue, 13 Jun 2000 15:18:26 +0200


Hi Vikas,

it was kind of tricky ;-)

First: Create DB/User/Password in mysql

Then add a ZMySQLDA in your working folder and name it accordingly, make shure
the id is unique and contains no spaces.
The connection string is as follows:
<databasename>[@<hostname>] <username> <password>

Example:
foo bar baz
would connect to the database named foo on the "localhost" (local being local
for zserver) with the username bar and the password baz.
foo@here bar baz.
would connect to the database named foo in the host named here with the
username bar and the password baz.

When creating/editing the grant tables for mysql make check whether you need to
include the domainname (i.e. here.mydomain.com instead of just here). This was
neccessary for my mysql server. The IP-Adress might work, too.

- Holger

Am Die, 13 Jun 2000 schrieben Sie:
> Hello,
> I am a new user of zope. I want to use MySQL database with zope. But I am
> unable to do it myself. Can you give me some tips or complete process 
> regarding the installation of the adapter with zope. I have already read
> the installation instruction given at ZMySQLDA but, still I am unsucessful
> Thanking you in anticipation. 
> Best Regards,
> Vikas
> 
> 
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://lists.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists - 
>  http://lists.zope.org/mailman/listinfo/zope-announce
>  http://lists.zope.org/mailman/listinfo/zope-dev )
-- 
-----------------------------------
catWorkX GmbH Hamburg
Dipl.-Ing. Holger Lehmann
Stresemannstr. 364
22761 Hamburg
Tel: +49 40 890 646-0
Fax: +49 40 890 646-66
mailto:lehmann@catworkx.de
http://www.catworkx.de
http://www.catbridge.de