Page 1 of 1

MySQL White Page after new root password

PostPosted: 27. December 2015 15:59
by fox_2k
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

Re: MySQL White Page after new root password

PostPosted: 27. December 2015 16:12
by fox_2k
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?