Mang :

\nThe phpMyAdmin configuration storage is not completely configured,\nsome extended features have been deactivated. Find out why. Or\nalternately go to 'Operations' tab of any database to set it up there.\n\nAfter did some searching on Google, it worked for me.\nFirst,go to folder xampp > phpmyadmin > config.inc.php\nThen, search (ctrl + F) for $cfg['Servers'][$i]['controluser']. Change it to root or any user you have added. I just put root.\nAnd for $cfg['Servers'][$i]['controlpass'], I left it blank because my root user doesn't have password. This will make the error/warning above dissapear.\nLastly, there will probably warning like\n\nThe secret passphrase in configuration (blowfish_secret) is too short,\n\nJust replace the $cfg['blowfish_secret'] with a random string that is at least 32 characters long. For reference,\nhttps://www.mysysadmintips.com/linux/servers/779-the-secret-passphrase-in-configuration-blowfish-secret-is-too-short",

2022-01-25T06:41:00

Isaac Bennetch :

The officially distributed create_tables.sql script includes a line to create and use the 'phpmyadmin' database, so perhaps XAMPP changes things.\n\nNote that I don't use XAMPP and I expected that their installer would have set this all up for you, so there may be something wrong there that should be fixed in a more proper way, but one possible solution might be to download the official phpMyAdmin version of create_tables.sql and use that, or you could just add the following line at the top of your sql file:\n\nCREATE DATABASE IF NOT EXISTS `phpmyadmin`\n DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;\nUSE phpmyadmin;\n",

2015-11-23T20:40:04

Snehal More :

First in phpMyAdmin go to users -> search the user \"root\" and host \"localhost\".\nthen select option -> edit privileges \nafter that go to -> change password\nset your password for root there.\n\nthen go to \nxampp folder -> phpmyadmin -> config.inc.php \nchange config to cookie.\nand password to your new password.\n$cfg['Servers'][$i]['auth_type'] = 'config'; ----> cookie\n$cfg['Servers'][$i]['user'] = 'root';\n$cfg['Servers'][$i]['password'] = ''; -----> new password(what you set for user root)",

2019-07-15T13:02:08

Pappu Kumar Pashi :

Visit the C:\\xampp\\phpMyAdmin\\config.inc.php and open this and set your own username and password, by default the username - 'root' and password - ' ',\nand then restart your xammp server.\nwhen you create the database schema at that time you have to remember the username and password for the next process",

2020-07-04T01:22:50

Maulik Prajapati :

This is what I did to enable the advanced features (using the latest version 3.4.x)\nFirst login to phpmyadmin and create a new database called phpmadmin. When you have created the database select the import tab at the top of the page. Click the Browse/Choose file button and navigate to your phpmyadmin folder and open the scripts directory and select the create_tables.sql file. Click open to close the window. Then press Go (bottom of page). The database for the control user has been setup.\nNext to setup the control user. Go to the phpmyadmin home screen and click the privileges tab. Click the add a new user link. For the username type phpmyadmin. Set anything as the password (Make sure you remember it). Choose the option to Create database with same name and grant all privileges And then click the Go button.\nYou have now setup the control user and the database for phpmyadmin. You now need to configure phpmyadmin. Open the config file (called config.inc.php). And remove the // from the start of the following lines\n/* User used to manipulate with storage */\n// $cfg['Servers'][$i]['controluser'] = 'pma';\n// $cfg['Servers'][$i]['controlpass'] = 'pmapass';\n\n/* Storage database and tables */\n// $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';\n// $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';\n// $cfg['Servers'][$i]['relation'] = 'pma_relation';\n// $cfg['Servers'][$i]['table_info'] = 'pma_table_info';\n// $cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';\n// $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';\n// $cfg['Servers'][$i]['column_info'] = 'pma_column_info';\n// $cfg['Servers'][$i]['history'] = 'pma_history';\n// $cfg['Servers'][$i]['tracking'] = 'pma_tracking';\n// $cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';\n// $cfg['Servers'][$i]['userconfig'] = 'pma_userconfig';\n\nMake sure you set $cfg['Servers'][$i]['controluser'] to phpmyadmin and apply the password to $cfg['Servers'][$i]['controlpass']. Log out of phpmyadmin, then log back in (not as the control user). The advanced features should now be enabled.",

2016-09-02T06:17:29

irwan sah :

IMAGE , set like this\neasy, go to user account and change user pma@localhost to all privileges",

2021-12-23T22:58:53

xmoooz :

resolving configuration storage problem in xampp in windows :\ngo to import tab in localhost/phpmyadmin and\nbrowse xampp\\phpMyAdmin\\sql folder and select create_tables.sql and\nthen click go button\nnow phpmyadmin db added to your db list\nnow we must create user account for this db :\nusers tab and click add user\n\nname : pma\n\n\npassword : pmapass\n\nand click go\nfor privilege of this user create a file : pma_privileges.sql\nwith this content :\nGRANT USAGE \nON mysql.* TO 'pma'@'localhost';\nGRANT \nSELECT\n( Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv, Execute_priv, Repl_slave_priv, Repl_client_priv ) \n ON mysql.user TO 'pma'@'localhost';\nGRANT \nSELECT\n ON mysql.db TO 'pma'@'localhost';\nGRANT \nSELECT\n(Host, Db, User, Table_name, Table_priv, Column_priv) \n ON mysql.tables_priv TO 'pma'@'localhost';\nGRANT \nSELECT\n,\n INSERT,\n UPDATE\n,\n DELETE\n ON phpmyadmin.* TO 'pma'@'localhost';\n\n\nand import it by import tab\nnow we create db and user with privilege so now\nwe must add them to config.inc.php file in xampp\\phpMyAdmin folder\nso add these :\n $cfg['Servers'][$i]['controluser'] = 'pma';\n $cfg['Servers'][$i]['controlpass'] = 'pmapass';\n \n /* Storage database and tables */\n $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';\n $cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';\n $cfg['Servers'][$i]['relation'] = 'pma__relation';\n $cfg['Servers'][$i]['table_info'] = 'pma__table_info';\n $cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';\n $cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';\n $cfg['Servers'][$i]['column_info'] = 'pma__column_info';\n $cfg['Servers'][$i]['history'] = 'pma__history';\n $cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';\n $cfg['Servers'][$i]['tracking'] = 'pma__tracking';\n $cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';\n $cfg['Servers'][$i]['recent'] = 'pma__recent';\n $cfg['Servers'][$i]['favorite'] = 'pma__favorite';\n $cfg['Servers'][$i]['users'] = 'pma__users';\n $cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';\n $cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';\n $cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';\n $cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';\n\nnow restart the mysql and browser and the configuration storage error disappear and\ncolumns after comment in creating table are visible",

2016-09-04T15:49:08