PhpmtAdmin broken after upgrade

[colbyt]

I needed to upgrade so I download xampp Windows 8.1.10 and did what I've done the last 3 upgrades.

I renamed the c:\xampp to xampp-old and installed 8.1.10 in a new empty folder named xampp. Then I copied all my Db folders from old to new being careful not overwrite any existing folders.

I used the terminal to and verify my mysqli password. All my local host sites loaded fine.

I had to manually open phpmyadmin\config.inc.php and set the password there.

It still does not work. When loading I get:
Error in processing request
Error code 200
Error text: OK (rejected)

it seems that the connection to the sever has been lost
Please check your network connectivity and server status.
Click to dismiss this notification

Additional info:
Error in processing request
Error code 200
Error text: OK (rejected)
it seems that the connectio to the sever has been lost
Please check your network connectivity and server status.
Click to dismiss this notification

Can anyone point me towards a solution?

[Altrea]

Hi,

Often this can happen if your browser has cached old ragments from the previous installation.
Please clear your browser cache and cookies and try again.

[colbyt]

Altrea, thanks for the reply. Problem resolved and here is the solution for others who may follow.

I actually had 2 different problems going on and it was a browser issue that was causing the one posted above. Somehow FF had an entry to allow no cookies from localhost. Once that was deleted all was fine. I did not post the second part 'cause I thought one might be causing the other.

So my suggestion to other who experience this is to try a different browser first.

The second problem was the error message at the bottom of the screen that said:

"The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. Find out why.
Or alternately go to 'Operations' tab of any database to set it up there."

This one took a bit of research but the answer is to make sure that your username, usually root for most of us has ALL PRIVILEGES on all databases. This can be done from the terminal within the xaampp control panel using this query: GRANT ALL PRIVILEGES ON *.* TO 'username'@localhost IDENTIFIED BY 'your-password';

The final step is to open phpmyadmin\config.inc.php in a text editor and go to line 30, copy lines 31 and 32, paste them immediately below, remark out the original 2 lines and insert your info into the 2 new lines as shown in the example.

/* User for advanced features */

/*$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = '';*/

$cfg['Servers'][$i]['controluser'] = 'your-user-name';
$cfg['Servers'][$i]['controlpass'] = 'your-password';

I can't be sure that this final step is necessary because now that it is working I am not taking a chance on breaking it again.

EDIT: I hate leaving things undecided, so I went back and changed my config file. The 'pma' is coded into the scripts somewhere as current user and those changes are not required.

In summary the 2 problems I encounter with this install were browser cookie settings (my fault) and ALL PRIVILEGES on all databases not being granted to the root user as it it has in the past (fault unknown).