From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from lists.gentoo.org ([140.105.134.102] helo=robin.gentoo.org) by nuthatch.gentoo.org with esmtp (Exim 4.54) id 1F9uNX-0005Je-M7 for garchives@archives.gentoo.org; Fri, 17 Feb 2006 01:25:48 +0000 Received: from robin.gentoo.org (localhost [127.0.0.1]) by robin.gentoo.org (8.13.5/8.13.5) with SMTP id k1H1OkNf029032; Fri, 17 Feb 2006 01:24:46 GMT Received: from imf21aec.mail.bellsouth.net (imf21aec.mail.bellsouth.net [205.152.59.69]) by robin.gentoo.org (8.13.5/8.13.5) with ESMTP id k1H1KiTL002073 for ; Fri, 17 Feb 2006 01:20:45 GMT Received: from ibm63aec.bellsouth.net ([65.12.196.191]) by imf21aec.mail.bellsouth.net with ESMTP id <20060217012044.GSMP4163.imf21aec.mail.bellsouth.net@ibm63aec.bellsouth.net> for ; Thu, 16 Feb 2006 20:20:44 -0500 Received: from mrk.schroder ([65.12.196.191]) by ibm63aec.bellsouth.net with ESMTP id <20060217012043.BACS5432.ibm63aec.bellsouth.net@mrk.schroder> for ; Thu, 16 Feb 2006 20:20:43 -0500 From: Ernie Schroder To: gentoo-user@lists.gentoo.org Subject: Re: [gentoo-user] OT: phpmyadmin Date: Thu, 16 Feb 2006 20:20:54 -0500 User-Agent: KMail/1.9.1 References: <200602152230.45762.schroder@ntplx.net> <43F479E7.7050302@veldy.net> In-Reply-To: <43F479E7.7050302@veldy.net> Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-user@gentoo.org Reply-to: gentoo-user@lists.gentoo.org MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200602162020.55005.schroder@ntplx.net> X-Archives-Salt: 6a502f4b-169e-4438-86f8-cc31ea087453 X-Archives-Hash: 1095611dec5c89176c9132df02e8468b On Thursday 16 February 2006 08:11, a tiny voice compelled Thomas T. Veldhouse to write: > Ernie Schroder wrote: > >I am just starting to play with php and mysql. I've got mysql working and > > can log into root accounts using a password. php scripts work on > >http://localhost. For example, http://localhost/php/index.php in a browser > >shows a whole lot of info re php, mysql and apache2. However, I can't seem > > to get phpmyadmin working. > >Going to http://localhost/phpmyadmin, gives me a window asking for > > username and password. If I insert my mysql username (root) and root's > > mysql password, I just get the same box with no error. I've tried adding > > a small > >config.inc.php file to /var/www/localhost/htdocs that is configured like > > so" > > > > >$cfg['PmaAbsoluteUri'] = 'http://localhost/phpmyadmin/'; > > Try 'http://127.0.0.1/phpmyadmin/ Tried that too. As well as hostname.domainname/phpmyadmin/ > > >$cfg['Servers'][$i]['host'] = 'MySQL.localhost'; > > '127.0.0.1' > > >$cfg['Servers'][$i]['auth_type'] = 'config'; > > 'cookie' > > >$cfg['Servers'][$i]['user'] = 'root'; > >$cfg['Servers'][$i]['password'] = 'password'; > > don't set the user and password Tried that too. > > >$cfg['blowfish_secret'] = '1234'; > >?> > >I restarted mysql and apache2 and still no joy > >Obviously, I'm missing something, but I can't find anything after many > > hours of searching that points me in the right direction. HELP ;>) > > When prompted for username and password, you probably want to start with > a superuser that you created in MySQL. > > Tom Veldhouse What I hadn't noticed when I emerged phpmyadmin, and none of the documentation I had read had told me, was there is a script installed by phpmyadmin located at: /usr/share/webapps/phpmyadmin/2.7.0_p1/sqlscripts/mysql/2.7.0_p1_create.sql that needs to be run to setup a database for phpmyadmin. I had to delete my previously created tables by doing: # rm -r /var/lib/mysql/* then, after starting mysql, # /usr/bin/mysql_install_db then I could login to mysql, set the root password and run the above script. All is well. I can now run phpmyadmin in the browser at: http://localhost/phpmyadmin/, http://127.0.0.1/phpmyadmin/ or hostname.domainname/phpmyadmin Only thing left to do is learn how to use all this neat stuff. -- Regards, Ernie -- gentoo-user@gentoo.org mailing list