From owner-freebsd-questions@FreeBSD.ORG Mon Nov 30 04:38:59 2009 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 A0BE6106566B for ; Mon, 30 Nov 2009 04:38:59 +0000 (UTC) (envelope-from fbsd1@a1poweruser.com) Received: from mail-03.name-services.com (mail-03.name-services.com [69.64.155.195]) by mx1.freebsd.org (Postfix) with ESMTP id 8DDDF8FC19 for ; Mon, 30 Nov 2009 04:38:59 +0000 (UTC) Received: from [10.0.10.3] ([202.69.172.43]) by mail-03.name-services.com with Microsoft SMTPSVC(6.0.3790.3959); Sun, 29 Nov 2009 20:38:56 -0800 Message-ID: <4B134C50.5050104@a1poweruser.com> Date: Mon, 30 Nov 2009 12:38:40 +0800 From: Fbsd1 User-Agent: Thunderbird 2.0.0.17 (Windows/20080914) MIME-Version: 1.0 To: FreeBSD Questions Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 30 Nov 2009 04:38:57.0181 (UTC) FILETIME=[075924D0:01CA7177] X-Sender: fbsd1@a1poweruser.com Subject: 8.0 & MYSQL50 denying access to user root no password 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: Mon, 30 Nov 2009 04:38:59 -0000 For many releases of Freebsd going back to 4.3 I have all ways used the default mysql user root localhost with no password which has been the default. With 8.0/mysql-server-5.0.86 I am denied access now. The mysql manual still says the normal install defaults to allowing access to user root with no password are in effect. After a fresh clean install of mysql Tried mysqladmin -u root drop test to delete the test db. Received this msg connect to srver at localhost failed access denied for user 'root@localost (using password: no) This in not suppose to happen. Is anyone else having this problem? Has the package for mysql50-server been changed to force securing user root with a password?