RE: [cobalt-users] MySQL

["Isa Alemdag" <isa@xxxxxxxxx>]

Mark,

Thank you for your online help to get this one working. I suggest other
people having similar problems to consult Mark for quick and very
accommodating work. Well done, great work.

Isa.

-----Original Message-----
From: Mark Middleton [mailto:mark@xxxxxxxxxxxxxx]
Sent: Friday, April 05, 2002 12:29 AM
To: isa@xxxxxxxxx
Subject: RE: [cobalt-users] MySQL


Isa,

I'm glad I can help.

phpMyAdmin is not installed by default, it is available here:

http://phpmyadmin.sourceforge.net/download.html

...

The httpd.conf file is located at /etc/httpd/conf/httpd.conf (there is
another httpd.conf that is used exclusively for the admin tool, DO NOT make
changes to that file, just the one listed above.)

After making the changes to the httpd.conf file, you must restart the web
server:

you can do that from a telnet/SSH session:

/etc/rc.d/init.d/httpd restart

...

phpMyAdmin has an interface for adding and removing users, you can
experiment with it, and let me know if you have problems.  It took us a
while to get this system down, and it's working out great for us now.

Hope this helps,
Mark

-----Original Message-----
From: Isa Alemdag [mailto:isa@xxxxxxxxx]
Sent: Thursday, April 04, 2002 12:58 PM
To: mark@xxxxxxxxxxxxxx
Subject: FW: [cobalt-users] MySQL


Hi Mark,

Thanks for the info. Can you make this for a none Linux user so that I can
try it out. In my previous hosting, they did similar thing I think and we
could use an alias to access to DB.

Do I need to install phpMyAdmin or is it already installed? Where is this
http.conf resides? If I get this sorted out I think rest can be easy to
follow and setup DBs.

Cheers, Isa.

-----Original Message-----
From: cobalt-users-admin@xxxxxxxxxxxxxxx
[mailto:cobalt-users-admin@xxxxxxxxxxxxxxx]On Behalf Of Mark Middleton
Sent: Thursday, April 04, 2002 7:25 PM
To: cobalt-users@xxxxxxxxxxxxxxx
Subject: RE: [cobalt-users] MySQL


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/
-----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/