Date: Sun, 02 Apr 2006 17:34:46 -0500 From: Kevin Kinsey <kdk@daleco.biz> To: Reinhold Platzoeder <reinhold@violetlan.net> Cc: "freebsd-questions@freebsd.org" <freebsd-questions@freebsd.org> Subject: Re: phpmyadmin and Access denied Message-ID: <44305186.5070403@daleco.biz> In-Reply-To: <20060403001830.4ca28857@khumuleka> References: <20060403001830.4ca28857@khumuleka>
next in thread | previous in thread | raw e-mail | index | archive | help
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 > > Run "mysql -u root" at the system's CLI, and you should get a clue. My guess is that phpadmin is attempting to use "root" and "" as its account name and pw for a MySQL login, and you have a password for the root account other than "" (much as it should be). Hence, when you make the SQL root password into <NULL>, it works .... HTH, Kevin Kinsey -- Pure drivel tends to drive ordinary drivel off of the TV screen.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?44305186.5070403>