warning phpmyadmin configuration storage

Problems with the Windows version of XAMPP, questions, comments, and anything related.

warning phpmyadmin configuration storage

Postby ygwolf » 01. June 2015 04:56

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.
ygwolf
 
Posts: 3
Joined: 25. May 2015 11:47
Operating System: windows

Re: warning phpmyadmin configuration storage

Postby Altrea » 01. June 2015 08:28

ygwolf wrote:Is this really necessary?

Do you have any problems?
Do you miss these extended features?
no, this is not necessary.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8286
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 50 guests