Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- go to config.inc.php in xampp(root folder)/phpMyAdmin
- open and add this lines
- $cfg['Servers'][$i]['users'] = 'pma_users';
- $cfg['Servers'][$i]['usergroups'] = 'pma_usergroups';
- $cfg['Servers'][$i]['navigationhiding'] = 'pma_navigationhiding';
- $cfg['Servers'][$i]['savedsearches'] = 'pma_savedsearches';
- in the end of file
- then go to http://localhost/phpmyadmin select phpmyadmin database and in top bar menu select SQL and copy this code
- -- --------------------------------------------------------
- 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;
- -- --------------------------------------------------------
- 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;
- -- --------------------------------------------------------
- then click Execute and logout phpmyadmin, and login again!
- Fine ;)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement