CopyPastor

Detecting plagiarism made easy.

Score: 1; Reported for: Exact paragraph match Open both answers

Possible Plagiarism

Plagiarized on 2019-08-11
by mshomali

Original Post

Original - Posted on 2014-02-23
by Randy Cleary



            
Present in both answers; Present only in the new answer; Present only in the old answer;

It's a mistake for missing some defaults table for default phpmydamin database. For solve this mistake you must to run following queries in ***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 following code to **config.inc.php** file:
$cfg['Servers'][$i]['users'] = 'pma_users'; $cfg['Servers'][$i]['usergroups'] = 'pma_usergroups'; $cfg['Servers'][$i]['navigationhiding'] = 'pma_navigationhiding';
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.

        
Present in both answers; Present only in the new answer; Present only in the old answer;