From owner-freebsd-questions Wed Sep 25 13:49:22 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 0592D37B401 for ; Wed, 25 Sep 2002 13:49:21 -0700 (PDT) Received: from mail.space2u.com (mail.space2u.com [62.20.1.135]) by mx1.FreeBSD.org (Postfix) with ESMTP id E499743E8A for ; Wed, 25 Sep 2002 13:49:18 -0700 (PDT) (envelope-from div@newcode.se) Received: from newcode.se (as5-3-5.hn.g.bonet.se [194.236.55.145]) by mail.space2u.com (8.11.6/8.11.6) with ESMTP id g8PKqh522444 for ; Wed, 25 Sep 2002 22:52:43 +0200 Date: Wed, 25 Sep 2002 22:49:20 +0200 Subject: Connecting to mysqld Content-Type: text/plain; charset=US-ASCII; format=flowed Mime-Version: 1.0 (Apple Message framework v546) From: Carl-Johan Kihlbom To: questions@FreeBSD.ORG Content-Transfer-Encoding: 7bit In-Reply-To: <20020923154717.K16000-100000@boris.st.hmc.edu> Message-Id: <43D6BC90-D0C8-11D6-A206-00039363CBAA@newcode.se> X-Mailer: Apple Mail (2.546) 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 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