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
On 17/11/00 4:36 pm, "Aitor Grajal Crespo" <Aitor.Grajal@inetsysonline.com> wrote:
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
database@host user passwd 'host' can be 'localhost' for database servers on the same machine as Zope... hth Tone ------ Dr Tony McDonald, Assistant Director, FMCC, http://www.fmcc.org.uk/ The Medical School, Newcastle University Tel: +44 191 222 5116 A Zope list for UK HE/FE http://www.fmcc.org.uk/mailman/listinfo/zope
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
participants (3)
-
Aitor Grajal Crespo -
Eric Walstad -
Tony McDonald