From owner-freebsd-questions Thu Sep 26 1:53:21 2002 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 9942937B404 for ; Thu, 26 Sep 2002 01:53:20 -0700 (PDT) Received: from hotmail.com (oe47.pav2.hotmail.com [64.4.36.19]) by mx1.FreeBSD.org (Postfix) with ESMTP id 3F56043E6A for ; Thu, 26 Sep 2002 01:53:20 -0700 (PDT) (envelope-from unixtools@hotmail.com) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Thu, 26 Sep 2002 01:53:20 -0700 X-Originating-IP: [202.41.224.36] From: "Unix Tools" To: "Carl-Johan Kihlbom" , References: <43D6BC90-D0C8-11D6-A206-00039363CBAA@newcode.se> Subject: Re: Connecting to mysqld Date: Thu, 26 Sep 2002 02:22:08 +0530 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.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Message-ID: X-OriginalArrivalTime: 26 Sep 2002 08:53:20.0212 (UTC) FILETIME=[29B65940:01C2653A] Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG ya flush privileges OR restart the mysql server ----- Original Message ----- From: "Carl-Johan Kihlbom" To: Sent: Thursday, September 26, 2002 02:19 AM Subject: Connecting to mysqld > I'm having trouble connecting to mysqld on my FreeBSD server. > > If i connect as root using mysql -u root -p it works just fine, but if > I try as any other user, e.g. mysql -u kihlbom -p I get the following > error message: > > ERROR 1045: Access denied for user: 'kihlbom@localhost' (Using > password: YES) > > I created the users with "GRANT ALL ON *.* TO kihlbom IDENTIFIED BY > 'password';". The users show up fine in the mysql.user table. > > Is there a config file somewhere that states that only root may connect? > > How can I allow connections from all users with a valid password? > > > To Unsubscribe: send mail to majordomo@FreeBSD.org > with "unsubscribe freebsd-questions" in the body of the message > To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message