Date: Sun, 2 Apr 2006 17:51:50 -0500 From: Gerard Seibert <gerard@seibercom.net> To: freebsd-questions@freebsd.org Subject: Re: phpmyadmin and Access denied Message-ID: <200604021851.51547.gerard@seibercom.net> In-Reply-To: <200604021822.01679.nb_root@videotron.ca> References: <20060403001830.4ca28857@khumuleka> <200604021822.01679.nb_root@videotron.ca>
next in thread | previous in thread | raw e-mail | index | archive | help
Nicolas Blais wrote: > On Sunday 02 April 2006 18:18, Reinhold Platzoeder wrote: > > Hi > > > > I have a weird problem here > > > > I have installed phpMyAdmin 2.8.0.2 from port > > > > Apache version = apache-2.2.0_7 > > PHP version = php5-5.1.2_1 > > MySQL version = mysql-server-5.0.19 > > > > > > When I go to the index page I get the following error > > > > #1045 - Access denied for user 'root'@'localhost' (using password: > > NO) > > > > I have configured the config.inc.php file and this is whats in it > > > > > cat config.inc.php > > > > <?php > > /* $FreeBSD: > > ports/databases/phpmyadmin/files/config.inc.php.sample,v 1.1 > > 2005/12/05 11:37:27 garga Exp $ * > > * Skeleton configuration file -- this file is empty on a fresh > > * installaton of phpmyadmin. > > * > > * Copy any settings you want to override from config.defaults.php > > * > > */ > > $cfg['PmaAbsoluteUri'] = 'http://www.violetlan.net/phpmyadmin/'; > > > > $cfg['blowfish_secret'] = 'whatever'; > > > > $cfg['Servers'][$i]['host'] = 'localhost'; > > > > $cfg['Servers'][$i]['auth_type'] = 'cookie'; > > > > $cfg['Servers'][$i]['user'] = 'root'; > > > > $cfg['Servers'][$i]['password'] = ''; > > > > $cfg['Servers'][$i]['connect_type'] = 'socket'; > > > > $cfg['Servers'][$i]['socket'] = '/tmp/mysql.sock'; > > > > ?> > > > > Now the funny thing is that when I change the root password to > > having no password I can get into phpmyadmin > > > > Any ideas as to how I can fix this? > > > > Thanks > > Try generating your config.inc.php from > http://www.violetlan.net/phpmyadmin/scripts/setup.php > > instead of making one. I had the same problem after an update from > 2.7 to 2.8 and this fixed it. > > Nicolas. Make this change: $cfg['Servers'][$i]['auth_type'] = 'http'; I have that in my config file with a blank password field. It works fine. -- Gerard Seibert gerard@seibercom.net PGP: http://www.seibercom.net/sig/gerard.asc
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200604021851.51547.gerard>