On Tue, Oct 29, 2002 at 11:56:01AM +0200, Egor Egorov wrote:
> Marco,
> Tuesday, October 29, 2002, 7:22:44 AM, you wrote:
>
> MB> I need your expert and slow guided assistance.
>
> MB> I would some one to teach me how to do for that user
> MB> and allow him/website to have access to that database and that database
> MB> alone, having complete control over it.
>
> MB> Using the example I have given you please teach me how to do so in detail?.
> MB> I look forward to be taken a novice, As I have gone through the docs online.
> MB> and it was not a great teacher!.
>
> Online manual contains enough info about your question :)
> Read about GRANT:
> http://www.mysql.com/doc/en/GRANT.html
>
> It's easy to set permissions using GRANT. if you want to give all
> rights on the certain database you can do it like
I really had a question about this for a few weeks now:
> GRANT ALL ON database_name.* TO 'user_name'@'host_name' IDENTIFIED BY
> 'user_password';
I had to issue a command just like that to allow php vbulletin program to access its
database. Of course, the vbulletin software took it from there managing its own
users, all that, so many tables .... well, to allow the vbulletin program to access
that database I tried making a connection to the database by adding him to user table
insert into mysql.user (host,user,password) values (localhost,user,password('pass');
and
then granting specific rights on that one db with
MY QUESTION IS !!
GRANT ALL ON database_name.* TO 'user_name'@'host_name' IDENTIFIED BY
'user_password';
changes nothing in tables_priv, or in db table, why is it different from making every
column in db table = Y ?
I know it's a solved problem, but I'm an academic!!!
>
>
> --
> For technical support contracts, goto https://order.mysql.com/?ref=ensita
> This email is sponsored by Ensita.net http://www.ensita.net/
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Egor Egorov
> / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
> /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
> <___/ www.mysql.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
--
(210)326-1983 .... countdown! multiplication! a (good) year
Joe Speigle
[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
