From owner-freebsd-questions@FreeBSD.ORG Mon Jul 7 12:46:56 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 73ED937B401 for ; Mon, 7 Jul 2003 12:46:56 -0700 (PDT) Received: from hercules.icarz.com (ns1.icarz.com [207.99.22.7]) by mx1.FreeBSD.org (Postfix) with ESMTP id 4E92A43FAF for ; Mon, 7 Jul 2003 12:46:55 -0700 (PDT) (envelope-from kenm@icarz.com) Received: from jefferies.icarz.com (jefferies.icarz.com [207.99.22.38]) by hercules.icarz.com (8.11.6/8.10.1) with SMTP id h67Jkr806880 for ; Mon, 7 Jul 2003 15:46:54 -0400 (EDT) Received: FROM kenxp BY jefferies.icarz.com ; Mon Jul 07 15:38:57 2003 -0400 Message-ID: <11d601c344bf$6809a250$c4db7bd1@icarz.com> From: "Ken Menzel" To: "Xpression" , "FreeBSD-questions" References: <005601c344b4$119e3990$0501a8c0@bloodlust> Date: Mon, 7 Jul 2003 15:38:56 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Subject: Re: Users question... 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: Mon, 07 Jul 2003 19:46:56 -0000 This is really a MySQL question, But you need to GRANT the user you created permissions to use the MYSQL database. Use the root user to do the grant. see: http://www.mysql.com/doc/en/Adding_users.html Get Paul Dubois' excellent book. MySQL Second Edition ( Sams Publishing). It's great! Also try mysql@lists.mysql.com Hope this helps Ken ----- Original Message ----- From: "Xpression" To: "FreeBSD-questions" Sent: Monday, July 07, 2003 2:17 PM Subject: Users question... > Can I have a special account to manage a specific service, > specifically MySQL. I mean, I running MySQL as mysql user, but when I want > to update the database I have to login as root, made changes and so on, > then, I want to create another user to this job, I have added a user as > member of wheel and assigned permissions in the current database directory > of MySQL and nothing happens...when I try to connect to the database it give > me an ERROR... > > _______________________________________________ > 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" >