From owner-freebsd-questions@FreeBSD.ORG  Thu Jul 28 21:20:25 2005
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
X-Original-To: freebsd-questions@freebsd.org
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 F2F4C16A41F
	for <freebsd-questions@freebsd.org>;
	Thu, 28 Jul 2005 21:20:24 +0000 (GMT)
	(envelope-from gerard-seibert@suscom.net)
Received: from smtp4.suscom.net (smtp4.suscom.net [64.78.119.247])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 9B46F43D48
	for <freebsd-questions@freebsd.org>;
	Thu, 28 Jul 2005 21:20:24 +0000 (GMT)
	(envelope-from gerard-seibert@suscom.net)
Received: from localhost (unknown [127.0.0.1])
	by smtp4.suscom.net (Postfix) with ESMTP id 756C915018F
	for <freebsd-questions@freebsd.org>;
	Thu, 28 Jul 2005 17:20:22 -0400 (EDT)
Received: from smtp4.suscom.net ([127.0.0.1])
	by localhost (smtp4.suscom.net [127.0.0.1]) (amavisd-new, port 10024)
	with LMTP id 19746-01-34 for <freebsd-questions@freebsd.org>;
	Thu, 28 Jul 2005 17:20:19 -0400 (EDT)
Received: from Gerard.suscom.net (ip148.217.susc.suscom.net [216.45.217.148])
	by smtp4.suscom.net (Postfix) with SMTP id 387BD150149
	for <freebsd-questions@freebsd.org>;
	Thu, 28 Jul 2005 17:20:19 -0400 (EDT)
Date: Thu, 28 Jul 2005 17:20:21 -0400 (Eastern Standard Time)
From: Gerard Seibert <gerard-seibert@suscom.net>
To: freebsd-questions <freebsd-questions@freebsd.org>
Message-ID: <Pine.WNT.4.63.0507281719350.2756@Treneq>
X-X-Sender: beerstud@spamcop.net@mail.cesmail.net
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed
X-Virus-Scanned: amavisd-new at suscom.net
Subject: MySQL - Cannot access as root
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
Reply-To: Gerard Seibert <gerard-seibert@suscom.net>
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Thu, 28 Jul 2005 21:20:25 -0000

I have just installed MySQL 5. I can access the program as a regular user, 
but not as root. As I regular user I have no privileges. If I attempt to 
access as root, I receive this error message.

ERROR 1045 (28000) Access denied for user 'root'@'localhost' (using 
password: NO)

I can access the program as root using: mysql -u root -p and then 
supplying a password at the prompt, but that is about it.

What can I do to correct this problem? I tried deleting the entire package 
and reinstalling it, but the problem continues. When I first installed the 
program, it worked, but only one time. Obviously, I did something, but I 
do not know what.

-- 
Gerard