Zope-MySQL Connectivity (Windows)

Follow the instructions given  below to connect to MySQL from Zope in Windows

1.Install MySQL (Run both setup files ‘MySQL Setup’ and 'MySQL GUI Tools')

2.Install MySQL ODBC Connector( Run setup file ‘MySQL ODBC Connector’)

3.Install MySQL Python Library (Run setup file ‘MySQL Python Library’)

4.Stop Zope if running.

5.Extract files and directories from 'MySQL Package' and copy it to ‘site-packages’ directory inside ‘python/lib’
6.Copy the directory ‘ZMySQLDA’ to ‘Products’ directory of Zope (This is the database adaptor used inside Zope.

7.Restart Zope

8.Now ‘Z MySQL Database Connection’ can be added from “add” drop-down list to connect to MySQL database
Note: At least one database needs to be created to use Z MySQL Database Connection.

9.The connection string is ‘database user password’. Like ‘iks root root00’.

10.After adding ‘Z MySQL Database Connection’, click on ‘test’ button to start writing SQL Statements in the text area.

after this follow the zmysql db connection tutorial : link1 for further
for page templates download any one page template from net and open in zope and do the modification ...