CODEWITHSUNDEEP
mysqlphpmyadminxampp
user2447290
user2447290

Reputation:

Xampp 1.8.3.3 with phpmyadmin 4.1.8 phpMyAdmin configuration storage is not completely configured

and installed the xampp phpmyadmin and when I entered the following jump

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

and click show and here is 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

How can fix it?

Upvotes: 1

Views: 10456

Answers (2)

Mina Yekta
Mina Yekta

Reputation: 1

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;

Upvotes: 0

Randy Cleary
Randy Cleary

Reputation: 725

Run the following query in the phpmyadmin database:

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;

Then, add the following lines into your config.inc.php file:

$cfg['Servers'][$i]['users'] = 'pma_users';
$cfg['Servers'][$i]['usergroups'] = 'pma_usergroups';
$cfg['Servers'][$i]['navigationhiding'] = 'pma_navigationhiding';

Then, log out of phyMyAdmin and log back in.

NOTE: You may also need to create a 'pma' user and grant all permissions on the 'phpmyadmin' database.

Upvotes: 2

Related Questions