can't login to pypmyadmin

Problems with the Windows version of XAMPP, questions, comments, and anything related.

can't login to pypmyadmin

Postby krd » 04. February 2010 05:15

I reinstalled xampp and changed Listen to 8080 in httpd.conf and changed Listen to 4499 in the httpd-ssl.conf as was suggested when installing iis sql server and apache on the same machine.

Well that seemed to work except that when I go into apache admin and click on status, all components say "deactivated". I don't know if this is good or bad. I can still do sql tasks just fine.

My latest problem is I changed my root password in config.inc.php and also from the phpmyadmin. Now I can not bring up phpmyadmin, I get the message #1045 - Access denied for user 'root'@'localhost' (using password: NO). Does the "deactivated" status have anything to do with this? I can still access the mysql client from root using the new password I set. I'm confused. Any help would be appreciated.
Thanks
krd
 
Posts: 6
Joined: 03. February 2010 18:22

Re: can't login to pypmyadmin

Postby 172upgrade » 04. February 2010 23:46

My latest problem is I changed my root password in config.inc.php and also from the phpmyadmin. Now I can not bring up phpmyadmin, I get the message #1045 - Access denied for user 'root'@'localhost' (using password: NO).


lucky you! i solved this problem this morning when i failed to upgrade my server and was trying to get it working. You need to set auth type to http, and put your password in as ROOTPASSWORD.

Code: Select all
/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'http';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'ROOTPASSWORD';
$cfg['Servers'][$i]['extension'] = 'mysql';


Doing that got my phpmyadmin working again. it just wasnt prompting for the password because the auth type was set to something else.
172upgrade
 
Posts: 5
Joined: 04. February 2010 23:20

Re: can't login to pypmyadmin

Postby krd » 05. February 2010 07:26

It used to work fine, I simply changed the root password by selecting privilages in the phpmyadmin and in the config.inc.php file password field. And it JUST WORKED. Now It does not. What has changed?????? You can tell I'm frustrated.......
krd
 
Posts: 6
Joined: 03. February 2010 18:22

Re: can't login to pypmyadmin

Postby krd » 05. February 2010 17:35

Good Morning,
I brought up apache and mysql from the xampp console and was able to login into phpmyadmin from the console without that dreadful message "#1045 - Access denied for user 'root'@'localhost' (using password: NO).". Any explanation as to why it magically worked this morning and not last evening after numerious installs/uninstalls/rebooting and resetting password in phpmyadmin/config.inc.php ? Could this be some cache issue that can only be resolved by physically turning off the machine?
krd
 
Posts: 6
Joined: 03. February 2010 18:22


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 129 guests