Why?
? Legacy and Common Architectures
? Access data in non-python languages
? Easy ad-hoc reporting
? ZODB optimized for reads not writes
? Relational has a proven track record

Requirements
? Python MySQL
– Python module
? Zope MySQL Database Adapter
– aka ZMySQLDA
– Zope product

Prepare MySQL
? Insure MySQL server is running
? Add a new user for zope
– mysql ­p root ­e ”GRANT SELECT, INSERT, UPDATE, DELETE ON mydb.* TO ‘zope’@'localhost’ IDENTIFIED BY ‘zope’;”
– mysql ­p root ­e ”FLUSH PRIVILEGES;”
? Test database access

Download pdf Using MySQL in Plone