List:General Discussion« Previous MessageNext Message »
From:Christian Mack Date:May 12 1999 3:29pm
Subject:Re: Adding a new User/DB/Host
View as plain text  
"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

Thread
Adding a new User/DB/HostGTP)12 May
  • Re: Adding a new User/DB/HostLuuk de Boer12 May
  • Re: Adding a new User/DB/HostChristian Mack12 May