From owner-freebsd-questions@FreeBSD.ORG Sun Apr 2 22:22:04 2006 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 60A1116A400 for ; Sun, 2 Apr 2006 22:22:04 +0000 (UTC) (envelope-from nb_root@videotron.ca) Received: from relais.videotron.ca (relais.videotron.ca [24.201.245.36]) by mx1.FreeBSD.org (Postfix) with ESMTP id 04FE943D48 for ; Sun, 2 Apr 2006 22:22:03 +0000 (GMT) (envelope-from nb_root@videotron.ca) Received: from clk01a ([66.130.198.54]) by VL-MO-MR002.ip.videotron.ca (Sun Java System Messaging Server 6.2-2.05 (built Apr 28 2005)) with ESMTP id <0IX40008V8SQZK80@VL-MO-MR002.ip.videotron.ca> for freebsd-questions@freebsd.org; Sun, 02 Apr 2006 18:22:02 -0400 (EDT) Date: Sun, 02 Apr 2006 18:21:55 -0400 From: Nicolas Blais In-reply-to: <20060403001830.4ca28857@khumuleka> To: freebsd-questions@freebsd.org Message-id: <200604021822.01679.nb_root@videotron.ca> MIME-version: 1.0 Content-type: multipart/signed; boundary=nextPart4902824.emkFJyqYKa; protocol="application/pgp-signature"; micalg=pgp-sha1 Content-transfer-encoding: 7bit References: <20060403001830.4ca28857@khumuleka> User-Agent: KMail/1.9.1 Cc: Reinhold Platzoeder Subject: Re: phpmyadmin and Access denied X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 02 Apr 2006 22:22:04 -0000 --nextPart4902824.emkFJyqYKa Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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 =3D apache-2.2.0_7 > PHP version =3D php5-5.1.2_1 > MySQL version =3D 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 > > /* $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'] =3D 'http://www.violetlan.net/phpmyadmin/'; > > $cfg['blowfish_secret'] =3D 'whatever'; > > $cfg['Servers'][$i]['host'] =3D 'localhost'; > > $cfg['Servers'][$i]['auth_type'] =3D 'cookie'; > > $cfg['Servers'][$i]['user'] =3D 'root'; > > $cfg['Servers'][$i]['password'] =3D ''; > > $cfg['Servers'][$i]['connect_type'] =3D 'socket'; > > $cfg['Servers'][$i]['socket'] =3D '/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=20 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= =2E8=20 and this fixed it. Nicolas. =2D-=20 =46reeBSD 7.0-CURRENT #0: Sat Apr 1 10:05:34 EST 2006 =20 root@clk01a:/usr/obj/usr/src/sys/CLK01A=20 PGP? : http://www.clkroot.net/security/nb_root.asc --nextPart4902824.emkFJyqYKa Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2.2 (FreeBSD) iD8DBQBEME6J4wTBlvcsbJURAt9pAJ9d4uhFnyqmHxlJZZqrPcoq5cpD9QCgr5xm oWXsVmoLUf9zrMO9tdZRIUQ= =xsdL -----END PGP SIGNATURE----- --nextPart4902824.emkFJyqYKa--