From owner-freebsd-questions Wed May 16 13:33:17 2001 Delivered-To: freebsd-questions@freebsd.org Received: from trinity.lee.net (trinity.lee.net [208.229.121.1]) by hub.freebsd.org (Postfix) with ESMTP id 012E237B422 for ; Wed, 16 May 2001 13:33:14 -0700 (PDT) (envelope-from awells@journalstar.com) Received: from journalstar.com (leepcC-018.sub-c.lee.net [208.205.126.18]) by trinity.lee.net (8.9.3/8.9.3) with ESMTP id PAA28647; Wed, 16 May 2001 15:33:16 -0500 Message-ID: <3B02E3E4.C012CAE1@journalstar.com> Date: Wed, 16 May 2001 15:32:36 -0500 From: Tony Wells X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.0.36 i386) X-Accept-Language: en MIME-Version: 1.0 To: michael@327.ca Cc: freebsd-questions@FreeBSD.ORG Subject: Re: Problem with MySQL port References: <01051612525900.00561@h24-69-46-74.gv.shawcable.net> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG They changed the default behavior of the client on MySQL recently. It used to let you connect without the -p argument if there wasn't a password set. Try this: # mysqladmin -u root -p -password "[password]" Just hit "Return" when it prompts you for a password. As far as I can tell the -p argument is now required for the client. Michael O'Henly wrote: > > I have installed the mysql323-server port before and I'm sure I followed the > same procedure this time...except, when I try to create a password for the > root user, I get: > > # mysqladmin -u root -password "[password]" > > mysqladmin: connect to server at 'localhost' failed > error: 'Access denied for user: 'root@localhost' (Using password: YES)' > > I'm fairly new to MySQL so I'm not sure how to interpret this. It looks as > though, by default, root isn't getting admin access, but I don't understand > why this should be. > > No doubt I'm overlooking something obvious. Suggestions appreciated! > > Thanks. > > M. > > -- > Michael O'Henly > > 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