RE: [cobalt-users] mySQL

["Neil J. Kemp" <neil@xxxxxxxxxx>]

>I (root) have to create a database, one for each customer (who really needs
>it :-). Furthermore I create a mySQL user for each customer and delegate
the
>databases to the resp. users. Right ? I hope so...

Correct ;-)

>Is there any reasons why a customer needs more than one database ? As far
as
>I understood mySQL, the customer can create tables without any action from
>me...

Sure. Maybe one database for a guestbook, another for a contact database,
another for... whether you want to let them have multiple databases though
is upto you ;-)

>What about the mySQL administration. Can I do this via a web interface
>(creating tables, adding users...) ? And: Where are the settings stored.

I think you can do this via PhpMyAdmin (which you mentioned below) but
there's no built in web GUI for MySQL

>What about database limitations. Can I set a size limit for each database,
>or are their sizes calculated with the user's quota on the RaQ2 ?

I honestly don't know. Try looking on http://www.mysql.org/

>What about accessing a database from outside. Can my customers access
>"their" databases other than via Telnet (but not phpmyadmin), e.g. via
>MS-ODBC ?

There is a thing called MyODBC but that's rather for your server to connect
to Access databases etc (to my understanding - I've never actually used it).
I don't believe there is anyway to access the databases EXCEPT from MySQL
(local or remote), but I could be wrong as I'm more used to Microsoft SQL
server 7 (it's MUCH MUCH nicer!)

--Neil