[cobalt-users] MySQL & PHP

[mncs@xxxxxxxxxxxx]

Many thanks to Debbie Doerrlamm and Brett C. for their emails and helpful
information regarding the correct files etc... for installation.   I have
now installed PHP and MySQL on a few servers.

I have downloaded and read most of the pertinent parts of the MySQL manual
and have a few more questions.

1. Should a new DB be created for each client asking for MySQL support?

2. What information will the client need to access the MySQL server?  I
realize domain name and password but do they need any particulars on file
locations etc...?

It looks like I can restrict access to a particular user from a particular
domain.  I am having some issues with the syntax to get this accomplished.
If so can someone help me with the statements for creating the DB giving
their user id only the permissions necessary for them to work on it?  I do
not want them to be able to mess up anything other than their own stuff.

I am learning this stuff at breakneck speed but I do not want to make a
costly mistake by screwing up.

Mike