From owner-freebsd-questions@FreeBSD.ORG Thu Feb 3 08:24:21 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 5BFAF16A4CF for ; Thu, 3 Feb 2005 08:24:21 +0000 (GMT) Received: from mail.freebsd-corp-net-guide.com (mail.freebsd-corp-net-guide.com [65.75.192.90]) by mx1.FreeBSD.org (Postfix) with ESMTP id B565243D1F for ; Thu, 3 Feb 2005 08:24:20 +0000 (GMT) (envelope-from tedm@toybox.placo.com) Received: from tedwin2k (nat-rtr.freebsd-corp-net-guide.com [65.75.197.130]) j138OBj81001; Thu, 3 Feb 2005 00:24:12 -0800 (PST) (envelope-from tedm@toybox.placo.com) From: "Ted Mittelstaedt" To: "Technical Director" , "Positive Negative" Date: Thu, 3 Feb 2005 00:24:10 -0800 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.6604 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 In-Reply-To: <20050202211111.D64563@server1.ultratrends.com> Importance: Normal cc: freebsd-questions@freebsd.org Subject: RE: Access denied for user 'root'@'localhost' (using password: NO) 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: Thu, 03 Feb 2005 08:24:21 -0000 > -----Original Message----- > From: owner-freebsd-questions@freebsd.org > [mailto:owner-freebsd-questions@freebsd.org]On Behalf Of Technical > Director > Sent: Wednesday, February 02, 2005 8:15 PM > To: Positive Negative > Cc: freebsd-questions@freebsd.org > Subject: Re: Access denied for user 'root'@'localhost' (using password: > NO) > > > > Positive Negative, > > You might seriously consider not using 'root@localhost' as > well I would bet 10 to 1 that he's installing an application that already is designed NOT to use the mysql root user to access it's database. This is a case of someone who isn't understanding the design of the app he's setting up. It worked only because he was running an out-of-box sql server install which had nothing for a root password. He probably misread the instructions and used root instead of the username that he was supposed to use. > since most > php scripts read the username/password information in clear text on a > nobody:nobody read filesystem. IOW other people can read your files. > Do you run php database driven apps on the same server as you use to provide shell services? I don't. If the webserver is configured right it won't allow remote clients to read the scripts, only execute them. Ted