MySQL White Page after new root password

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

MySQL White Page after new root password

Postby fox_2k » 27. December 2015 15:59

Hey,

I already looked through the Forum but couldn`t find a solution to my problem. I wanted to change my root password and did the following (Methode 2):

http://veerasundar.com/blog/2009/01/how-to-change-the-root-password-for-mysql-in-xampp/

In this line:

Code: Select all
UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='root'; FLUSH PRIVILEGES;


I changed it to this:

Code: Select all
UPDATE mysql.user SET Password=PASSWORD('HERE WAS MY NEW PASSWORD') WHERE User='root'; FLUSH PRIVILEGES;


Additionally I also changed $cfg['Servers'][$i]['auth_type'] = 'cookie'; in the config.inc.php

Now I can`t access http://localhost/phpmyadmin/ anymore. It`s showing a blank white page with no possibillity to log in.
Restart is done, Cache is cleared. I have no idea what to do.

I hope you can help me solve this issue.

Thank you,
fox_2k
fox_2k
 
Posts: 2
Joined: 27. December 2015 15:51
Operating System: Win 10

Re: MySQL White Page after new root password

Postby fox_2k » 27. December 2015 16:12

Hey, directly after writing this, I had an idea which didn`t make much sense in the first place I think, but worked. Gladly I made an copy of the config.inc.php and restored that one.

There I just changed the 'config' to 'cookie' under
Code: Select all
$cfg['Servers'][$i]['auth_type'] = 'cookie';

and now I was able to log in again.

Really happy that it works, but does anyone know what the actual problem was?
fox_2k
 
Posts: 2
Joined: 27. December 2015 15:51
Operating System: Win 10


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 152 guests