hi,

the info in the manual about the command line in mysql apply also
for win2k. Assuming you have root access go to the mysql prompt
and type this:
GRANT select, insert, update, delete, WhatPrivYouWant ON YourDB.* TO
username
IDENTIFIED BY 'YourPassword';

This creates a user "username" with pasword "YourPassword" who has the
specified priviledges
on all tables in YourDB.


Johannes

""edwin"" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
9c60eq$p5b$[EMAIL PROTECTED]">news:9c60eq$p5b$[EMAIL PROTECTED]...
> hi,
>
> I got a very simple question. I have mysql under win2k and I need help
> adding a new user to be able to use the database. I looked through the
> manual but all the references are for *nix, can someone help me out or
point
> me to a place where i can read up on this??
>
> thanks!!
> edwin
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>



-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to