From owner-freebsd-questions@FreeBSD.ORG Thu Jun 12 01:44:38 2008 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id BE2FB106566C for ; Thu, 12 Jun 2008 01:44:38 +0000 (UTC) (envelope-from rjgonzale@gmail.com) Received: from yw-out-2324.google.com (yw-out-2324.google.com [74.125.46.28]) by mx1.freebsd.org (Postfix) with ESMTP id 6E83E8FC13 for ; Thu, 12 Jun 2008 01:44:38 +0000 (UTC) (envelope-from rjgonzale@gmail.com) Received: by yw-out-2324.google.com with SMTP id 9so1707670ywe.13 for ; Wed, 11 Jun 2008 18:44:33 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from :user-agent:mime-version:to:cc:subject:references:in-reply-to :content-type:content-transfer-encoding; bh=gpS0KK5lP2Fd7GYCTZZm5pCfUxiigkMlpweHfQfYkg0=; b=XJ1sghFrVOMx50T7dPluo5ZWpIXOggRO5DbwA72BdecI3jaPS+g1T5ue9VV1f4h32I cSy8wWu4NHptVL8lBC/YGDV5IjO7lHEUs3fofSA4pGpVpD9IAJSCQZ5vpLl1l3QDDLph eVN/Xfhv1q8bXbEjBamqEx78bPBZR9ObMjgyc= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:cc:subject :references:in-reply-to:content-type:content-transfer-encoding; b=dOlV9d5UY65tNLrvdHBQfFYbp19Psfkx3uNBZko0LyCqAseghZmtEVWfdW4+fBnDf8 CaO+hEPbWm8gpoRCBonsA+AE+jZwKqo4nZivlOfJKyaUKvq8nBjJ39MVDMSwhVeqNCx8 QFiI2MGJ1hImjFY4e6YMYiLYQLERRQxYRmW60= Received: by 10.150.198.20 with SMTP id v20mr1275508ybf.151.1213233459183; Wed, 11 Jun 2008 18:17:39 -0700 (PDT) Received: from ?192.168.1.100? ( [190.18.168.30]) by mx.google.com with ESMTPS id 6sm652752ywp.3.2008.06.11.18.17.36 (version=TLSv1/SSLv3 cipher=RC4-MD5); Wed, 11 Jun 2008 18:17:38 -0700 (PDT) Message-ID: <4850792C.7050200@gmail.com> Date: Wed, 11 Jun 2008 22:17:32 -0300 From: Rodrigo Gonzalez User-Agent: Thunderbird 2.0.0.14 (X11/20080505) MIME-Version: 1.0 To: Gary Kline References: <20080612010303.GA81167@thought.org> In-Reply-To: <20080612010303.GA81167@thought.org> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Cc: FreeBSD Mailing List Subject: Re: need mysql help setting passwd X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 12 Jun 2008 01:44:38 -0000 Gary Kline wrote: > this failed: > > > mysqladmin -u root password > mysqladmin: connect to server at 'localhost' failed > error: 'Access denied for user 'root'@'localhost' (using password: NO)' > > > according to my logs it has been about 5 years since i did this last. > > advice please! > > gary > > > Your mysql server already has a password for user root. 2 options 1 - mysqladmin -u root -p password Of course I think you dont know current password or you wouldnt be asking....so second option Read http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html#resetting-permissions-unix with that steps you will reset root password Best regards Rodrigo Gonzalez