From owner-freebsd-questions@FreeBSD.ORG Tue Sep 23 08:11:59 2003 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 37BB516A4BF for ; Tue, 23 Sep 2003 08:11:59 -0700 (PDT) Received: from server1.ultratrends.com (server1.ultratrends.com [205.206.59.239]) by mx1.FreeBSD.org (Postfix) with ESMTP id DA2DF43F93 for ; Tue, 23 Sep 2003 08:11:57 -0700 (PDT) (envelope-from trodat@ultratrends.com) Received: from server1.ultratrends.com (localhost [127.0.0.1]) h8NG9wRE036842; Tue, 23 Sep 2003 09:09:58 -0700 (MST) Received: from localhost (trodat@localhost)h8NG9vqv036839; Tue, 23 Sep 2003 09:09:57 -0700 (MST) X-Authentication-Warning: server1.ultratrends.com: trodat owned process doing -bs Date: Tue, 23 Sep 2003 09:09:57 -0700 (MST) From: Technical Director To: "H. Bartel" In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII cc: freebsd-questions@freebsd.org Subject: Re: Users & mySQL User X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 23 Sep 2003 15:11:59 -0000 Holgar, No. MySQL supports users through the database manager itself. Once MySQL is running on the system you can add users to the user table found in the mysql database. Remember to 'flush privileges' once this is done to make the changes apply. It would also be a really good idea to think/learn about this process before implementing a production level system using this setup. eg: -- Checking out the MySQL documentation at http://www.mysql.com/, a sample of this: http://www.mysql.com/doc/en/General_security.html -- Planning 'how' your databases will work as far as access privileges. R. On Tue, 23 Sep 2003, H. Bartel wrote: > Hi, > > I have installed mySQL-Server on my freeBSD 4.8, and now I want to set it up. I can connect to the database with root@localhost and the according password, but I would like to add another user, which would then only be used to connect to the database server. > Does this need to be another user on my system, or just an "internal" mySQL User? Any hints on how to set this up? > > Thanks, Holger > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.org" >