"Naveen Yawanarajah (GTP)" wrote:
>
> Hi All,
>
> I'm new at this MySQL Administration thing. I'd like to add a user to the
> table
> and restrict the user's connection to come from one host, and only connect
> with one database. I also want to assign a password. How do I do all of this?
>
> Cheers,
>
> Naveen.
Hi Naveen
1) Start the MySQL client 'mysql' as MySQL user 'root'.
2) give the following query into the 'mysql' commandline:
GRANT
ALTER
, CREATE
, DROP
, INSERT
, DELETE
, SELECT
, UPDATE
, INDEX
ON
the_one_database.*
TO
new_user_name@stripped
IDENTIFIED BY
'password for the new_user_name'
3) close 'mysql' with:
quit
Tschau
Christian
