Xampp 1.8.3 with phpmyadmin 4.1.12 Storage Configuration NOT Complete

I recently installed the latest Xampp with phpMyAdmin version 4.1.12 and noticed the following error messages after the installation process:

The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. To find out why click [here].

… and clicking the link showed the following errors:

$cfg[‘Servers’][$i][‘users’] … not OK [ Documentation ]

$cfg[‘Servers’][$i][‘usergroups’] … not OK [ Documentation ] Configurable menus: Disabled

$cfg[‘Servers’][$i][‘navigationhiding’] … not OK [ Documentation ] Hide/show navigation items: Disabled

The fix is simple:

STEP1:

Run the following query on the phpmyadmin database:

==================== START ===================

CREATE TABLE IF NOT EXISTS `pma_users` (

  `username` varchar(64) NOT NULL,

  `usergroup` varchar(64) NOT NULL,

  PRIMARY KEY (`username`,`usergroup`)

) 

  COMMENT=’Users and their assignments to user groups’

  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

 

CREATE TABLE IF NOT EXISTS `pma_usergroups` (

  `usergroup` varchar(64) NOT NULL,

  `tab` varchar(64) NOT NULL,

  `allowed` enum(‘Y’,’N’) NOT NULL DEFAULT ‘N’,

  PRIMARY KEY (`usergroup`,`tab`,`allowed`)

) 

  COMMENT=’User groups with configured menu items’

  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

 

CREATE TABLE IF NOT EXISTS `pma_navigationhiding` (

  `username` varchar(64) NOT NULL,

  `item_name` varchar(64) NOT NULL,

  `item_type` varchar(64) NOT NULL,

  `db_name` varchar(64) NOT NULL,

  `table_name` varchar(64) NOT NULL,

  PRIMARY KEY (`username`,`item_name`,`item_type`,`db_name`,`table_name`)

) 

  COMMENT=’Hidden items of navigation tree’

  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

==================== STOP ===================

STEP2:

Add the following lines to your phpMyAdmin config.inc.php file:

$cfg[‘Servers’][$i][‘users’] = ‘pma_users’;

$cfg[‘Servers’][$i][‘usergroups’] = ‘pma_usergroups’;

$cfg[‘Servers’][$i][‘navigationhiding’] = ‘pma_navigationhiding’;

STEP3:

Logout and log back into phpMyAdmin

That’s it!

Enjoy 😉

 

Update:

Upgrading to phpMyAdmin 4.2.5 caused a similar problem but with ONLY one error.

$cfg[‘Servers’][$i][‘savedsearches’] … not OK [ Documentation ] Saved searches: Disabled

The solution is simply the same as above…

Execute the following query:

==================== START ===================

CREATE TABLE IF NOT EXISTS `pma_savedsearches` (

  `id` int(5) unsigned NOT NULL auto_increment,

  `username` varchar(64) NOT NULL default ”,

  `db_name` varchar(64) NOT NULL default ”,

  `search_name` varchar(64) NOT NULL default ”,

  `search_data` text NOT NULL,

  PRIMARY KEY  (`id`),

  UNIQUE KEY `u_savedsearches_username_dbname` (`username`,`db_name`,`search_name`)

)

  COMMENT=’Saved searches’

  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

==================== STOP ===================

STEP2:

Add the following lines to your phpMyAdmin config.inc.php file:

$cfg[‘Servers’][$i][‘savedsearches’] = ‘pma_savedsearches’;

STEP3:

Logout and log back into phpMyAdmin


Posted in Vista, Web Design, Windows, Windows 7, Windows Vista, Windows XP and tagged , , , , , by with comments disabled.