phpmyadmin and Access denied

Reinhold Platzoeder reinhold at violetlan.net
Sun Apr 2 22:18:12 UTC 2006


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

-- 
Reinhold Platzoeder



More information about the freebsd-questions mailing list