phpmyadmin and Access denied

[Reinhold Platzoeder]

On Sun, 2 Apr 2006 17:51:50 -0500
Gerard Seibert <gerard at 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