From owner-freebsd-questions@FreeBSD.ORG Sun Jan 30 11:48:16 2005 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 5E9ED16A4CE for ; Sun, 30 Jan 2005 11:48:16 +0000 (GMT) Received: from mail.adept.biz (adept.biz [67.106.14.154]) by mx1.FreeBSD.org (Postfix) with ESMTP id 13C9243D60 for ; Sun, 30 Jan 2005 11:48:14 +0000 (GMT) (envelope-from phill@adept.biz) Received: from [192.168.1.101] (c-67-183-124-1.client.comcast.net [67.183.124.1]) by mail.adept.biz (Postfix) with ESMTP id 4A7B460D1 for ; Sun, 30 Jan 2005 03:48:11 -0800 (PST) Message-ID: <41FCC95F.20407@adept.biz> Date: Sun, 30 Jan 2005 03:47:43 -0800 From: Phillip Hocking User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: questions@freebsd.org Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Subject: MySQL update from 4.1 to 4.7 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: Sun, 30 Jan 2005 11:48:16 -0000 Now it will not allow me to login to the database with any of the usernames that I remember here is the error in the log 2:58:29 [Warning] Found 4.1 style password for user 'root@localhost'. Ignoring user. You should change password for this user. How do I flush the tables to resolve this issue and change all the passwords around? Any help would be much appreciated. Phill Hocking Information Systems Manager www.adept.biz