From owner-freebsd-questions Tue Jun 11 8:41:36 2002 Delivered-To: freebsd-questions@freebsd.org Received: from kumprang.or.id (wl-kumprang-5.teras.net.id [202.143.103.229]) by hub.freebsd.org (Postfix) with SMTP id B82E737B409 for ; Tue, 11 Jun 2002 08:41:12 -0700 (PDT) Received: (qmail 2117 invoked by uid 1000); 11 Jun 2002 15:41:07 -0000 Date: Tue, 11 Jun 2002 22:41:07 +0700 From: budsz To: jehova Cc: freebsd-questions Subject: Re: MySQL:connect to server at 'localhost' failed Message-ID: <20020611224107.A1111@bdg.centrin.net.id> Reply-To: budsz Mail-Followup-To: budsz , jehova , freebsd-questions References: <200206110724.16234.tornadox@telnor.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5.1i In-Reply-To: <200206110724.16234.tornadox@telnor.net>; from tornadox@telnor.net on Tue, Jun 11, 2002 at 07:24:16AM -0700 X-Uptime: 10:32PM up 7 mins, 1 user, load averages: 0.00, 0.01, 0.00 X-Operation-System: FreeBSD 4.6-RC i386 X-Geekcode: "GMU d- s++:+ a- C++ UL++ P+ L++ E- W++ N o+ K- w+ O+ M V++ PS PE Y+ PGP++ t 5 X+++ R+ tv b++ DI- D+ G++ e++ h+ r+ y+" X-Pubkey-Linux: "http://www.kumprang.or.id/~budsz/pubkey_Linux.txt" X-Pubkey-FreeBSD: "http://www.kumprang.or.id/~budsz/pubkey_FreeBSD.txt" X-Company: "Internet Cafe & Game Kumprang" 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 On Tue, Jun 11, 2002 at 07:24:16AM -0700, 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)' ^^^^^^^^^^^^^^ Default MySQL'll deny login with root, so you should create new user then grant/revoke some privileges to that user. check out the doc or manual. -- budsz To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message