Hello:
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]
---------------------------------------------------------------------
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
