From owner-freebsd-questions  Wed May 16 14:45:36 2001
Delivered-To: freebsd-questions@freebsd.org
Received: from h24-69-46-74.gv.shawcable.net (h24-69-46-74.gv.shawcable.net [24.69.46.74])
	by hub.freebsd.org (Postfix) with ESMTP id 8372637B423
	for <freebsd-questions@FreeBSD.ORG>; Wed, 16 May 2001 14:45:30 -0700 (PDT)
	(envelope-from michael@327.ca)
Received: from h24-69-46-74.gv.shawcable.net (localhost.gv.shawcable.net [127.0.0.1])
	by h24-69-46-74.gv.shawcable.net (8.11.3/8.11.3) with SMTP id f4GLmUY00837;
	Wed, 16 May 2001 14:48:31 -0700 (PDT)
	(envelope-from michael@327.ca)
Content-Type: text/plain;
  charset="iso-8859-1"
From: "Michael O'Henly" <michael@327.ca>
Reply-To: michael@327.ca
To: Tony Wells <awells@journalstar.com>, michael@327.ca
Subject: Re: Problem with MySQL port
Date: Wed, 16 May 2001 14:48:30 -0700
X-Mailer: KMail [version 1.2]
Cc: freebsd-questions@FreeBSD.ORG
References: <01051612525900.00561@h24-69-46-74.gv.shawcable.net> <3B02E3E4.C012CAE1@journalstar.com>
In-Reply-To: <3B02E3E4.C012CAE1@journalstar.com>
MIME-Version: 1.0
Message-Id: <01051614483002.00561@h24-69-46-74.gv.shawcable.net>
Content-Transfer-Encoding: 8bit
Sender: owner-freebsd-questions@FreeBSD.ORG
Precedence: bulk
X-Loop: FreeBSD.ORG

Thanks for the reply, Tony.

OK, I've tried: # mysqladmin -u root -p -password "[password]"
I get the "Enter password: " prompt.
Then I hit <Return>

...and I get:

mysqladmin: Unknown command: "[password]"

So, I think there must be more to it than this. I'll take a closer look at 
the Changelog to try to figure out how the client's default behaviour has 
changed. (This makes sense because MySQL has been updated since I last 
installed it.)

Thanks again.

M.

On Wednesday 16 May 2001 13:32, Tony Wells wrote:
> 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

-- 
Michael O'Henly

To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-questions" in the body of the message