Robert Roberts wrote:
>
> I am new to this list. I posted a perfectly honest question, but all I get
> back is an email from [EMAIL PROTECTED] saying NO SPAM PLEASE. I checked
> appua.com. The site is in Russian. I don't understand why I'm getting this.
> Perhaps someone can explain. In the meantime, here's my question -- again:
> ----------------
>
> I have read and re-read the available documentation and a variety of
> tutorials regarding the MySQL Access Privelege System, but am still unclear
> on a few details. MySQL is successfully installed, I am able to connect,
> create databases,
> tables, etc., and have so far been successful in obtaining results I've
> wanted.
>
> The scenario:
> ---I'm running a small server with FreeBSD 3.4, Apache 1.3.17, PHP 4.0.4pl1,
> 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 requires
> 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 use
> it.
>
> My assumption:
> mysql> GRANT SELECT, INSERT, UPDATE ON client_db.*
> TO db_user@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, "
> [EMAIL PROTECTED] "?
> ---they are connecting from a remote machine, so are they, then, connecting
> 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 consistent
> "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
> [EMAIL PROTECTED]
>
Hi,
>From mysql point of view, the client is your php application.
Since both are running on the same machine, your GRANT statement is OK
as long as you use 'localhost' as mysql hostname in your php scripts.
Regards
--
Joseph Bueno
NetClub/Trader.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
