Skip to main content
W
wgrayson
Participating Frequently
January 30, 2010
Question

Unable to launch PhPAdmin w/ previous version of mySQL?

  • January 30, 2010
  • 1 reply
  • 560 views

I completed a course recently using a textbook that covered Dreamweaver's use with Coldfusion, ASP, and Php.  The actual course only covered the Coldfusion section.  As part of the coldfusion exercises, I installed mySQL 5.1.39 using a generic username and password.

I decided last month to go back through the book and cover the PhP sections.  I've installed WAMP 2.0 on the same machine. (I also installed WAMP on a new computer where I hadn't installed mySQL yet, so I've identified the problem.) When I try to start phpAdmin I get thess "Access denied for user 'root@hocalhost' (using password : NO) with additional comments to check the username password configuration.  But I can't find where to configure this in WAMP.  Can anyone assist?

PhPAdmin launches just fine on the computer I haven't previously installed mySQL.

Thanks in advance,

W!

This topic has been closed for replies.

1 reply

David_Powers
David_Powers
Inspiring
January 30, 2010

I don't use WAMP, and their "documentation" looks awful. However, if WAMP uses a regular installation of phpMyAdmin, you should be able to locate config.inc.php in the phpMyAdmin root folder. The username and password are set here:

$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'not_telling';

If auth_type is set to 'config', phpMyAdmin launches like an ordinary website without the need to log in.

W
wgraysonAuthor
Participating Frequently
January 31, 2010

Mr. Powers, thanks for responding.  I've also been googling this issue all weekend, and it looks like I'm not the only one that's encountered this problem. Attached is my confguration.inc file.  Be advised the original file had no password value.  Even when I added the password value, I was unable to launch the program.  Please note that the "auth" line was already set to "config " as you had recommended.  Any other suggestions? In a google thread you participated in a year or so ago, one of the solutions was to uninstall, then reinstall the existing mySQL application already in place prior to installing WAMP.  I'm just a bt hesitant to do that because I have already set up a number of test and class sites using Coldfusion to connect to mySQL, and I'm afraid I'll have to replicate those connections in DW and / or recreate the schemas in mySQL.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices