[Zope] HOw to Connect MySQl database to Zope

[Chris McDonough]

Hamdi,

You don't use a ZODBC database connector to access a MySQL database...
instead use a ZMySQL database connection.  You select this from the Add
Item dropdown menu within Zope.  If "Z MySQL Database Connection" isn't
an option within this dropdown box, then ZMySQLDA isn't installed
properly (note that after installing ZMySQLDA, for the change to "take",
you need to restart Zope).  

Once you've gotten MySQLDA working, when you add a ZMySQL Database
Connection, the Add dialog will ask you for a database connection
string.  This string has the syntax:

database[@host] user passwd

So for a database named "zopetestdb" on a host named
"sparky.digicool.com" where a MySQL login exists named "root" with a
password of "goodstuff", the database connection string would be:

zopetestdb@sparky.digicool.com root goodstuff

Chris McDonough
Digital Creations, Inc.
Zope - http://www.zope.org


> -----Original Message-----
> From: hamdi mulya [mailto:hamdi@cybermedia.com.bn]
> Sent: Tuesday, November 16, 1999 1:43 AM
> To: zope@zope.org
> Cc: wongikmg@esuria.com.bn
> Subject: [Zope] HOw to Connect MySQl database to Zope
> 
> 
> Hello,
> 
> I new in mysql database and zope , but i interesting about that.
> 
> I've followed the instructions as described in
> http://www.zope.org/Members/alanpog/zmysqlda_steps and I get the
> MySQLdb-0.1.1.
> 
> The system is a Linux Mandrake  6.1 Kernel 2.2.13-7mdk and I have
> installed MySQL 3.22.27, Python 1.5.2-1mdk from source, Zope 2.01 from
> source.
> 
> I confuse to use the Z ODBC data base connection, what i should do to
> make mysql database connect..?
> 
> 
> 
> 
> 
> _______________________________________________
> 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 )
>