[buug] MySQL permissions question

Alex M alex at myzona.net
Fri Jul 27 12:41:11 PDT 2001


While i havent been playing with MySQL much, i had to do the same stuff, and
docs on www.devshed.com helped me a lot. Its the least i can do.

good luck.

----- Original Message -----
From: "Robert Roberts" <info at gooddoggygrafx.com>
To: <buug at weak.org>
Sent: Friday, July 27, 2001 12:12 PM
Subject: [buug] MySQL permissions question

> Hello:
> While this isn't strictly a Unix question, maybe someone out there is
> familiar enough with administering MySQL to clarify a permissions
> I have read and re-read the available documentation and a variety of
> tutorials regarding the MySQL Access Privelege System, but am still
> on a few details. I've also scoured what I've been able to find via
> MySQL is successfully installed, and I am able to connect, create
> tables, etc.
> The scenario:
> ---I'm running a small server with FreeBSD 3.4, Apache 1.3.17, PHP
> and have just migrated to MySQL 3.23.40 [yes, I must now re-build
> Apache/php].
> ---The server hosts my own sites, plus a few others.
> The goal:
> ---I want to set up a database for one of my hosting clients. They would
> like to use a php-based application for events announcements, which
> access to a database. The php application sets up a browser-based
> administration gui. I would do all set-up for them, and show them how to
> it.
> My assumption:
> mysql> GRANT SELECT, INSERT, UPDATE ON client_db.*
>             TO db_user at localhost IDENTIFIED BY 'password';
> Now this is where I get a bit confused. It's not clear to me where the
> client is connecting from. I assume they are connecting from  localhost
> because everything is all on the same server. But:
> ---are they, in actuality, connecting from their own virtual host, "
> db_user at virtual_host.com "?
> ---they are connecting from a remote machine, so are they, then,
> from some other host?
> ---if they are connecting from a remote machine with a dial-up connection,
> then it is undoubtedly a dynamic IP address, so there would be no
> "host" to connect from.
> I believe I've supplied all relevant info, so if someone is able to shed
> some light on this, I will be most appreciative.
> Thanks,
> Robert Roberts
> info at gooddoggygrafx.com
> _______________________________________________
> Buug mailing list
> Buug at weak.org
> http://www.weak.org/mailman/listinfo/buug

More information about the buug mailing list