[Zope] mysql connection string

Oleg Broytmann Oleg Broytmann <phd@mail2.phd.pp.ru>
Mon, 15 Jan 2001 19:07:34 +0300 (MSK)


On Mon, 15 Jan 2001, Olaf Zanger wrote:
> right now my setup uses a connection string "db root" which doesn't seam
> to give a lot of savety :-).
> at my provider i have a login, but sure no root access to the db.
> * how does the connection string look for user name "peter-hauser" and
> password "test3-.2"?

   db@provider.host.domain peter-hauser test3-.2 <----------------------\
                                                                        |
> * has the user to be set up in "linux" ?                              |
                                                                        |
   No, only in mysql.                                                   |
                                                                        |
> * how is the setup made in "mysql"?                                   |
                                                                        |
   GRANT select,insert,update,delete,create,alter,drop,index            |
ON db.* TO peter-hauser@his.peter.host.domain INDENTIFIED BY 'test3-.2';|
                                                                        |
> * has zope to be run by user "peter-hauser"?                          |
                                                                        |
   No, you pass peter-hauser in the connection string >-----------------/

Oleg.
----
     Oleg Broytmann     http://www.zope.org/Members/phd/     phd@phd.pp.ru
           Programmers don't die, they just GOSUB without RETURN.