phpmyadmin and Access denied

[Gerard Seibert]

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 at seibercom.net

PGP: http://www.seibercom.net/sig/gerard.asc