[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