From owner-freebsd-questions Tue Jun 11 14:11:33 2002 Delivered-To: freebsd-questions@freebsd.org Received: from infinity.aesredfish.net (ns1.aesredfish.net [65.168.0.12]) by hub.freebsd.org (Postfix) with ESMTP id 4DAAF37B400 for ; Tue, 11 Jun 2002 14:11:29 -0700 (PDT) Received: from potentialtech.com (mhope-dhcp-65-168-1-181.dashfast.com [65.168.1.181]) by infinity.aesredfish.net (8.11.6/8.11.0) with ESMTP id g5BLBHU08501; Tue, 11 Jun 2002 17:11:17 -0400 Message-ID: <3D0668DF.7080906@potentialtech.com> Date: Tue, 11 Jun 2002 17:17:19 -0400 From: Bill Moran User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.0rc1) Gecko/20020502 X-Accept-Language: en-us, en MIME-Version: 1.0 To: jehova Cc: FreeBSD-Questions Subject: Re: MySQL:connect to server at 'localhost' failed References: <200206110724.16234.tornadox@telnor.net> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit 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 jehova wrote: > i just installed MySQL from ports collection as usual (make > install clean) when i start server and check status i got this: > > kris[/usr/ports/databases/mysql323-server]# > /usr/local/etc/rc.d/mysql-server.sh start > mysqldkris[/usr/ports/databases/mysql323-server]# mysqladmin -p > status > Enter password: > mysqladmin: connect to server at 'localhost' failed > error: 'Access denied for user: 'root@localhost' (Using password: > YES)' > kris[/usr/ports/databases/mysql323-server]# Did you try entering your root password when it prompted you? If so, that's your mistake. If I remember correctly, the default MySQL install creates a root user with full privies, but NO PASSWORD. Thus, initially when you log in, you must NOT enter a password. It's a VERY good idea to fix this first thing. -- Bill Moran Potential Technology http://www.potentialtech.com To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message