PMA Database ... not OK in phpMyAdmin upgrade

Question

I have just been wrangling with phpMyAdmin and MySQL server on my Win8 PC IIS localhost (there was no connection between these, which I think was due to MySQL service not starting so I reinstalled MySQL and reran the config setup and reestablished a connection between them, which fixed that).

However phpMyAdmin advised an update which I did by overwriting the files with the new version and including the previous config file.

I now have:
The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. To find out why click here.
and on clicking I get
PMA Database ... not OK [ Documentation ]
General relation features Disabled
When I click the link I get a http 404 page which gives this:

Physical path C:\inetpub\wwwroot\phpMyAdmin\pmadb 

So what is the pmadb in phpMyAdmin and should I be bothered by this? As it stands I'm a bit fed up at having to have had to spend time tweaking all of this (ie it has not been a smooth trouble free event/install). Is it some DB for the old version or what? I do not think I created it!

I do not feel very bothered by this as hopefully I can setup my databases for my localhost IIS websites and press on with my webdeverry(!) but I don't really like having this unknown error and wouldn't mind fixing it/getting rid of it.

Answer 1

There are a few google links on this same issue that I have followed that have helped me fix this (I should have spent more time googling before posting!). So to solve the problem I needed to create a phpmyadmin database and import create_tables.sql and assign a new user with full privileges and then uncomment the config.inc.php file at:

/* User used to manipulate with storage */ $cfg['Servers'][$i]['controlhost'] = ''; $cfg['Servers'][$i]['controluser'] = 'phpmyadmin';

and uncomment lines below

/* Storage database and tables */ $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';

I also needed to add some lines from the new version config.sample.inc There was a good link describing this I wanted to save but I had to clear my browser cache to reload localhost/phpMyAdmin and in doing so I lost my history & that link!

I know this explanation is not exactly described but I hope it may help anyone else who gets a similar issue after updating phpMyAdmin. I'm still not sure what all these features do but it is all fixed now, thanks!