From owner-freebsd-questions@FreeBSD.ORG Thu Feb 3 04:15:24 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 E359416A4CE for ; Thu, 3 Feb 2005 04:15:24 +0000 (GMT) Received: from server1.ultratrends.com (S01060004e20310fa.rd.shawcable.net [70.65.87.221]) by mx1.FreeBSD.org (Postfix) with ESMTP id 0480C43D41 for ; Thu, 3 Feb 2005 04:15:24 +0000 (GMT) (envelope-from technical@ultratrends.com) Received: from server1.ultratrends.com (localhost [127.0.0.1]) j134FMGQ064607; Wed, 2 Feb 2005 21:15:23 -0700 (MST) (envelope-from trodat@server1.ultratrends.com) Received: from localhost (trodat@localhost)j134FMjK064604; Wed, 2 Feb 2005 21:15:22 -0700 (MST) (envelope-from trodat@server1.ultratrends.com) Date: Wed, 2 Feb 2005 21:15:22 -0700 (MST) From: Technical Director To: Positive Negative In-Reply-To: <3ce33c85050202184176ca49ac@mail.gmail.com> Message-ID: <20050202211111.D64563@server1.ultratrends.com> References: <3ce33c85050202184176ca49ac@mail.gmail.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Milter: Spamilter (Reciever: server1.ultratrends.com; Sender-ip: 127.0.0.1; Sender-helo: server1.ultratrends.com;) 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 04:15:25 -0000 Positive Negative, You might seriously consider not using 'root@localhost' as well 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. Possibly making the username/password somewhat cryptic, say writing a function to "dizzify" the usually clear text or at least setting up a specific user/pass combination for specific databases is a very good idea. eg: $S_userName=__callDizzyFunc(); $S_passInfo=__callDizzyFunc(); At least this is SOMEWHAT more protective then: $S_userName='root'; $S_passInfo='password'; 2 cents. Rob. On Wed, 2 Feb 2005, Positive Negative wrote: > Warning: Access denied for user 'root'@'localhost' (using password: > NO) in /usr/local/www/sites/bender69/webcal/includes/php-dbi.php on > line 48 > Error connecting to database: > > Access denied for user 'root'@'localhost' (using password: NO) > > > ---- > > OK, how do i change it back. > > /usr/local/bin/mysqladmin -u root password > > This is where it got messed up.... > > how do i fix it? > > > -- > AIM: FucPsSht > _______________________________________________ > 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" >