Re: MySql 4.0.12 Connection to WebObjects ... need URL info please
Re: MySql 4.0.12 Connection to WebObjects ... need URL info please
- Subject: Re: MySql 4.0.12 Connection to WebObjects ... need URL info please
- From: Tomek Klas <email@hidden>
- Date: Wed, 30 Apr 2003 10:34:24 +0100
Hey,
this should help
http://www.prnet.de/RegEx/mysql-wo.html
i have tried it with the latest driver and remote mysql database and it
worked fine.
as far as for the user details, these are specified in mysql 'users'
table and for the security reasons should be set. root is generally bad
idea because this user have too much privileges, from my experience
(with mysql/php) it is best to set a new user with privileges just for
the database/table/row needed. this ensures, that 'accidents' can not
go horribly wrong, e.g. root user can delete the 'users' table, which
would effectively leave you (and any website) lock out
as far as the driver shipped with WO, i have never tried it....
let me know how it goes...
tomek
On Wednesday, April 30, 2003, at 06:04 AM, Kieran Kelleher wrote:
I need help on how to connect to MySql databases from WebObjects.
EOModeler
guide does not show URL connection string for MySql.
I have WO 5.2.1 on OS X 10.2.4.
Do I need to also install latest JDBC driver from www.mysql.com ???
.... or
is the one that shipped with the WO 5.2 installation OK?
In any case, if anyone could tell me what the JDBC Connection fields
should
contain for Username (root?), Password (the mysql root password?), URL
and
the optional Driver and Plugin fields, I would really appreciate it.
Thanks, Kieran
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.