From owner-freebsd-questions@FreeBSD.ORG Mon Mar 1 00:03:03 2004 Return-Path: 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 DD1A216A4CE for ; Mon, 1 Mar 2004 00:03:03 -0800 (PST) Received: from bayok.msumain.edu.ph (unknown [203.177.105.166]) by mx1.FreeBSD.org (Postfix) with SMTP id 9A8A143D1D for ; Mon, 1 Mar 2004 00:02:55 -0800 (PST) (envelope-from rfa@msumain.edu.ph) Received: (qmail 36716 invoked from network); 1 Mar 2004 08:25:22 -0000 Received: from unknown (HELO bayok.msumain.edu.ph) (203.177.105.166) by bayok.msumain.edu.ph with SMTP; 1 Mar 2004 08:25:22 -0000 Received: from 203.177.105.170 (proxying for 192.168.16.12) (SquirrelMail authenticated user rfa) by bayok.msumain.edu.ph with HTTP; Mon, 1 Mar 2004 16:25:22 +0800 (PHT) Message-ID: <4080.203.177.105.170.1078129522.squirrel@bayok.msumain.edu.ph> Date: Mon, 1 Mar 2004 16:25:22 +0800 (PHT) From: rfa@msumain.edu.ph To: freebsd-questions@freebsd.org User-Agent: SquirrelMail/1.4.0 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 X-Priority: 3 Importance: Normal Subject: mysqladmin won't work X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 01 Mar 2004 08:03:04 -0000 First of all im running FreeBSD 4.8 and mysql-server-3.23.56 Im planning to install phpmyadmin and phpnuke on my webserver for content and I forgot the root password for mysql and Im not the first maintainer of this server so I have no idea what the password could be. I was thinking to override the previous root password so I checked the documentation for mysql and it said do this as root: QUOTE: 5.5.6 Assigning Account Passwords Passwords may be assigned from the command line by using the mysqladmin command: shell> mysqladmin -u user_name -h host_name password "newpwd" The account for which this command resets the password is the one with a user table record that matches user_name in the User column and the client host from which you connect in the Host column. ENDQUOTE so i tried that and..... #mysqladmin -u root -h localhost password "mysql" mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' # mysqladmin -h localhost password mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' I don't get it, whats happening? Btw im using putty to ssh into the server, could that be a cause?