phpmyadmin and Access denied

[Nicolas Blais]

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.
-- 
FreeBSD 7.0-CURRENT #0: Sat Apr  1 10:05:34 EST 2006     
root at clk01a:/usr/obj/usr/src/sys/CLK01A 
PGP? : http://www.clkroot.net/security/nb_root.asc
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
Url : http://lists.freebsd.org/pipermail/freebsd-questions/attachments/20060402/c3c54ec5/attachment.pgp