Date: Mon, 3 Apr 2006 02:07:27 +0200 From: Reinhold Platzoeder <reinhold@violetlan.net> To: freebsd-questions@freebsd.org Subject: Re: phpmyadmin and Access denied Message-ID: <20060403020727.7978e3db@khumuleka> In-Reply-To: <200604021851.51547.gerard@seibercom.net> References: <20060403001830.4ca28857@khumuleka> <200604021822.01679.nb_root@videotron.ca> <200604021851.51547.gerard@seibercom.net>
next in thread | previous in thread | raw e-mail | index | archive | help
On Sun, 2 Apr 2006 17:51:50 -0500 Gerard Seibert <gerard@seibercom.net> wrote: > 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. > Thanks I was not aware of the setup script That worked for me -- Reinhold Platzoeder
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20060403020727.7978e3db>