"Naveen Yawanarajah (GTP)" wrote:
> Hi All,
> I'm new at this MySQL Administration thing. I'd like to add a user to the
> 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?
1) Start the MySQL client 'mysql' as MySQL user 'root'.
2) give the following query into the 'mysql' commandline:
'password for the new_user_name'
3) close 'mysql' with: