Re: Server Setup

Well, the short answer is: read and understand the security chapter of the 
MySQL manual (http://www.mysql.com/).

We have a similar situation, where a number of clients are hosted on a 
single server, and have shell access (telnet/ssh/ftp) to their account (a 
cgi hosting account essentially). They can also have a MySQL database 
configured on request. The way this works is that a separate database is 
created for each user (the database has the same name as their account 
login id for convinience), and a MySQL user created (also with the as the 
account login id/password) and access is granted for that user only to 
their database. This is done through a combination of records in the 
db/host/tables_priv/user mysql databases. You will find some examples on 
the MySQL web site, and the manual is pretty good, assuming you know the 
basic principles behind SQL databases.

At 15:20 06/14/2001 -0400, Mike Lessar wrote:
>Hi, I have a question for the group.
>
>I am just about ready to do a co-host with a local isp for my web server.
>
>My agreement with the local isp is that, they will have nothing to do with
>the box other than connect it to the internet and their back-up power source
>and place it behind their firewall, anything else is my responsibility.
>
>I do not know how to setup the box so that each client has one database with
>mySQL and I don't want them to see the other databases.
>
>I have everything on the box pretty much figured out except the mySQL.
>
>It is loaded on the box and is running fine.
>
>The box is a Pentium III w/ RH 7.0 with all the latest patches and updates
>of the available software.
>
>Any help would be appreciated.
>Mike Lessar
>---------------------------------------------
>Lessar Designs - (610) 476-3586
>Building Interactive Web Sites and Scripts
>http://www.lessar.com
>
>International Webmaster Association - http://www.iwanet.org
>HTML Writers Guild - http://www.hwg.org

--
   Marius Zydyk -- pod(at)null.net -- http://www.domainofdarkness.com/

HWG: hwg-servers mailing list archives, maintained by Webmasters @ IWA