From owner-freebsd-questions@FreeBSD.ORG Mon Nov 30 19:19:37 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 E06651065679 for ; Mon, 30 Nov 2009 19:19:37 +0000 (UTC) (envelope-from tajudd@gmail.com) Received: from mail-px0-f190.google.com (mail-px0-f190.google.com [209.85.216.190]) by mx1.freebsd.org (Postfix) with ESMTP id 87A708FC1A for ; Mon, 30 Nov 2009 19:19:37 +0000 (UTC) Received: by pxi28 with SMTP id 28so2876116pxi.7 for ; Mon, 30 Nov 2009 11:19:37 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type; bh=6+OW3I+rQs21WGGCMBaxYUdpm86HdnryD/VEEmvUaz8=; b=cJwAsMellgLcDaA2TrPIaxLLhW8PFMU3eRo/joxtn+jGkh1b1h1vw9EwDHJmI92CTJ p7C3uJyu+eONoj/Z1EmS6pGgEbVh664LBMuJOhn8m3tsgdpjG/Z3eSwGu8v6otjIBRkY T3sAzL9Z0K6sdpBZshXCXQVFgNF3t8YI0pxzM= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=ctOrbjlJusopoB9xtps5ZvFPAsOymF16AjiUkj911ZzjzTclpl8xiMIaqg+6I/0E6k fAygCqXMKyYeRBOk5GXxBjAADpNrjCLivQTH2WrqjDjvPut7HndgHx6ErHijUyJrkikV CPNm2XrAUgMdcrQ41TaU0hoTf6N7Tj4gypi7o= MIME-Version: 1.0 Received: by 10.115.113.6 with SMTP id q6mr8532069wam.55.1259608777253; Mon, 30 Nov 2009 11:19:37 -0800 (PST) In-Reply-To: <4B134C50.5050104@a1poweruser.com> References: <4B134C50.5050104@a1poweruser.com> Date: Mon, 30 Nov 2009 12:19:37 -0700 Message-ID: From: Tim Judd To: Fbsd1 Content-Type: text/plain; charset=ISO-8859-1 Cc: FreeBSD Questions Subject: Re: 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 19:19:38 -0000 On 11/29/09, Fbsd1 wrote: > 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. Two issues, mysqladmin tries to connect to the mysql server -- i see in your message above it can't connect if it can't connect, how can it authorize? second, the undocumented mysql_install_db must be run to install the default database. But if you run this as root, you should change ownership of everything in /var/db/mysql to allow the mysql server access to the files. Those are two problems I'm seeing with your post. Correct me if I'm wrong, but try these first. > > Is anyone else having this problem? > Has the package for mysql50-server been changed to force securing user > root with a password? > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.org" >