Advertisement
obernardovieira

phpMyAdmin cfg['Servers'][$i]['users'] ... not OK

Jun 12th, 2014
501
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.24 KB | None | 0 0
  1. go to config.inc.php in xampp(root folder)/phpMyAdmin
  2. open and add this lines
  3.  
  4. $cfg['Servers'][$i]['users'] = 'pma_users';
  5. $cfg['Servers'][$i]['usergroups'] = 'pma_usergroups';
  6. $cfg['Servers'][$i]['navigationhiding'] = 'pma_navigationhiding';
  7. $cfg['Servers'][$i]['savedsearches'] = 'pma_savedsearches';
  8.  
  9. in the end of file
  10.  
  11. then go to http://localhost/phpmyadmin select phpmyadmin database and in top bar menu select SQL and copy this code
  12.  
  13.  
  14. -- --------------------------------------------------------
  15.  
  16. CREATE TABLE IF NOT EXISTS `pma_users` (
  17. `username` varchar(64) NOT NULL,
  18. `usergroup` varchar(64) NOT NULL,
  19. PRIMARY KEY (`username`,`usergroup`)
  20. )
  21. COMMENT='Users and their assignments to user groups'
  22. DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
  23.  
  24. -- --------------------------------------------------------
  25.  
  26. CREATE TABLE IF NOT EXISTS `pma_usergroups` (
  27. `usergroup` varchar(64) NOT NULL,
  28. `tab` varchar(64) NOT NULL,
  29. `allowed` enum('Y','N') NOT NULL DEFAULT 'N',
  30. PRIMARY KEY (`usergroup`,`tab`,`allowed`)
  31. )
  32. COMMENT='User groups with configured menu items'
  33. DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
  34.  
  35. -- --------------------------------------------------------
  36.  
  37. CREATE TABLE IF NOT EXISTS `pma_navigationhiding` (
  38. `username` varchar(64) NOT NULL,
  39. `item_name` varchar(64) NOT NULL,
  40. `item_type` varchar(64) NOT NULL,
  41. `db_name` varchar(64) NOT NULL,
  42. `table_name` varchar(64) NOT NULL,
  43. PRIMARY KEY (`username`,`item_name`,`item_type`,`db_name`,`table_name`)
  44. )
  45. COMMENT='Hidden items of navigation tree'
  46. DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
  47.  
  48. -- --------------------------------------------------------
  49.  
  50. CREATE TABLE IF NOT EXISTS `pma_savedsearches` (
  51. `id` int(5) unsigned NOT NULL auto_increment,
  52. `username` varchar(64) NOT NULL default '',
  53. `db_name` varchar(64) NOT NULL default '',
  54. `search_name` varchar(64) NOT NULL default '',
  55. `search_data` text NOT NULL,
  56. PRIMARY KEY (`id`),
  57. UNIQUE KEY `u_savedsearches_username_dbname` (`username`,`db_name`,`search_name`)
  58. )
  59. COMMENT='Saved searches'
  60. DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
  61.  
  62. -- --------------------------------------------------------
  63.  
  64. then click Execute and logout phpmyadmin, and login again!
  65.  
  66. Fine ;)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement