RE: [cobalt-users] MySQL

["Mark Middleton" <mark@xxxxxxxxxxxxxx>]

Here's how we do it (suggestions on improvement welcome)

1.  I have one master copy of the latest stable phpMyAdmin installed in a
subdirectory such as "/mysql" of the main site.
2.  In phpMyAdmin configuration:

$cfgServers[1]['auth_type'] = 'http'; // Authentication method (config, http
or cookie based)?

3.  In my httpd.conf, I've created an alias (for the entire server) of

Alias /mysql /home/sites/home/web/mysql

4.  Now, whenever you go to http://www.domainname.com/mysql you are greeted
with a prompt for your mysql username and password.  You will have access to
the databases for which your username has granted priviledges for.

5.  When a client requests a database, we create a new database, create a
new user and give that user control over that database.  If they want
additional databases, we add grants for those as well. (make sure to "reload
mysql" or the user will not show up)

Thusly, If I log in with my "master" username and password, even on one of
the virtual host's sites, I can make modifications to any database I have
rights to.

I hope this helps,
Mark


-----Original Message-----
From: cobalt-users-admin@xxxxxxxxxxxxxxx
[mailto:cobalt-users-admin@xxxxxxxxxxxxxxx]On Behalf Of Steve Werby
Sent: Thursday, April 04, 2002 4:15 AM
To: cobalt-users@xxxxxxxxxxxxxxx
Subject: Re: [cobalt-users] MySQL


"Isa Alemdag" <isa@xxxxxxxxx> wrote:
> Can anybody point to a resource or say how to use MySQL for VSs?

I'd consult the MySQL manual at mysql.com.  MySQL's access control system is
completed separate from the access control system of the operating system of
the server.  So there is really no such thing as using MySQL for virtual
sites; you setup MySQL users, MySQL databases and grant MySQL users specific
privileges to specific databases.

--
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.com/


_______________________________________________
cobalt-users mailing list
cobalt-users@xxxxxxxxxxxxxxx
To Subscribe or Unsubscribe, please go to:
http://list.cobalt.com/mailman/listinfo/cobalt-users