Re: MYSQL Help
| From: | Johannes Janson | Date: | Wed, 25 Apr 2001 09:34:34 +0000 |
| Subject: | Re: MYSQL Help | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-7040@lists.php.net to get a copy of this message | ||
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"" <edwinx@home.com> schrieb im Newsbeitrag
news:9c60eq$p5b$1@toye.p.sourceforge.net...
> 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: php-windows-unsubscribe@lists.php.net
> For additional commands, e-mail: php-windows-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>