Page 1 of 1

warning phpmyadmin configuration storage

PostPosted: 01. June 2015 04:56
by ygwolf
On the myadmin page appears awarning:
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.

In "stack overflow" there is a solution (appears below) that requires changes of code, I have no coding experience and reluctant to do it. Is this really necessary? Is there an easier way? What happens if I disregard it?

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.

Re: warning phpmyadmin configuration storage

PostPosted: 01. June 2015 08:28
by Altrea
ygwolf wrote:Is this really necessary?

Do you have any problems?
Do you miss these extended features?
no, this is not necessary.