pcplantdb

[Richard Morris <webmaster@pfaf.org>]

Don Sizemore wrote:
> 
> |Could you create one user account: pcplantdb
> |and two databases, one called pcplantdb and one called pfaf.
> 
>   done. if you logged in to login.ibiblio.org, you would want to:
> 
>   mysql -u pcplantdb -p -h mysql.ibiblio.org pfaf
> 
>   "pfafr00lz" will get you in for the pcplantdb user
> 
> |Q1. Can we have multiple people using the same user id, or would
> |       it be better to have multiple user id one for each of
> |       the people involved in the project.
> 
>   For database purposes, if accountability won't be a problem, then
> you're welcome to have multiple people using the db account.  We do
> prefer individual accounts for ibiblio logins, though.
> 
> |Q2. Will we need to ask you to if we need more databases created?
> 
>   Yes, but I'll be happy to do them :)  jem and fred can also create
> them if I'm not around.
> 
> |Q3. I'm not sure about the security side of MySQL databases.
> |       Whats your policy on this? Is it possible to have more than
> |       one user id with full access rights to a particular DB?
> 
>   We usually give two users per database:  one with read/write
> privileges, and one with read-only privileges so read-only web pages
> need not put the password out there.  You may have multiple accounts
> with full access, no problem.
> 
>   I'll be happy to create more accounts for you, just let me know if
> you need them?  Also, feel free to write me with any questions or
> problems.
> 
>   Thanks,
>   Donald                                           ibiblio.org
>                                             formerly known as SunSITE
>   919.843.8215                                      and stoof.

-- 
p.s. Can I take this opportunity to encourage to you to join our 
friends of Plants For A Future membership scheme. Membership is only
£10 a year (£15 overseas) and we are trying to recruit 1000 friends 
in the coming year. If we can reach this target then we will be
able to secure the land for our demonstration gardens and visitors
centre in Devon which could become a shining example of woodland
gardening, sustainability, and the use of perennial plants.
See http://www.comp.leeds.ac.uk/pfaf/friends.html for details.

--
Plants for a Future: 7000 useful plants
Web:       http://www.pfaf.org/  or  http://www.comp.leeds.ac.uk/pfaf/
Main Site: Blagdon Cross, Ashwater, Beaworthy, Devon, EX21 5DF, England
           Tel: (+44 845) 458 4719
Email:     webmaster@pfaf.org (web related queries only)
PFAF electronic mailing list http://groups.yahoo.com/group/pfaf