[Zope] MySQL Connection String

Eric Walstad Eric@Walstads.net
Fri, 17 Nov 2000 09:25:40 -0800


I use the following format:

users@frankenstein privileged_user ThePassWord
- or in general terms -
TableName[@HostNameOfMachineMySQLIsRunningOn] MySQLUserName ThePassWord

I guess the "@HostNameOfMachineMySQLIsRunningOn" part is optional, but I
needed to put it in there for my setup.
The "privileged_user" is one that you've done a MySQL GRANT for. I.e.
something like:
GRANT SELECT,INSERT,UPDATE ON DatabaseName.TableName TO MySQLUserName
IDENTIFIED BY 'ThePassWord';

FYI, I found this info in ALANPOG's HowTo:
http://www.zope.org/Members/alanpog/zmysqlda_steps

hth, Eric.
-----Original Message-----
From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Aitor
Grajal Crespo
Sent: Friday, November 17, 2000 8:37 AM
To: zope@zope.org
Subject: [Zope] MySQL Connection String


  I have installed ZMySQLDA 1.1.4,
anybody knows the format of the database connection string???

I have put database user passw , and doesn't work

Thanks