Last active
September 20, 2020 01:05
-
-
Save asheroto/ae2f951634d750561af4422b4760752d to your computer and use it in GitHub Desktop.
Working phpMyAdmin config.inc.php config with cookie based authentication
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
declare(strict_types=1); | |
/** | |
* This is needed for cookie based authentication to encrypt password in | |
* cookie. Needs to be 32 chars long. | |
*/ | |
$cfg['blowfish_secret'] = '32-character-random-secret'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */ | |
/* Authentication type */ | |
$cfg['Servers'][$i]['verbose'] = 'server-name-here'; | |
$cfg['Servers'][$i]['host'] = '127.0.0.1'; | |
$cfg['Servers'][$i]['port'] = '3306'; | |
$cfg['Servers'][$i]['socket'] = ''; | |
$cfg['Servers'][$i]['extension'] = 'mysqli'; | |
$cfg['Servers'][$i]['auth_type'] = 'cookie'; | |
$cfg['Servers'][$i]['compress'] = false; | |
$cfg['Servers'][$i]['AllowNoPassword'] = false; | |
$cfg['Servers'][$i]['ssl'] = false; | |
$cfg['ExecTimeLimit'] = 0; | |
$cfg['ForceSSL'] = true; | |
$cfg['LoginCookieRecall'] = true; | |
$cfg['LoginCookieValidity'] = 3599; | |
$cfg['LoginCookieStore'] = 3599; | |
$cfg['LoginCookieDeleteAll'] = false; | |
/** | |
* phpMyAdmin configuration storage settings. | |
*/ | |
/* User used to manipulate with storage */ | |
$cfg['Servers'][$i]['controlhost'] = '127.0.0.1'; | |
$cfg['Servers'][$i]['controlport'] = '3306'; | |
$cfg['Servers'][$i]['controluser'] = 'create-mysql-user-and-put-username-here'; | |
$cfg['Servers'][$i]['controlpass'] = 'control-user-password'; | |
/* Storage database and tables */ | |
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin'; | |
$cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark'; | |
$cfg['Servers'][$i]['relation'] = 'pma__relation'; | |
$cfg['Servers'][$i]['table_info'] = 'pma__table_info'; | |
$cfg['Servers'][$i]['table_coords'] = 'pma__table_coords'; | |
$cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages'; | |
$cfg['Servers'][$i]['column_info'] = 'pma__column_info'; | |
$cfg['Servers'][$i]['history'] = 'pma__history'; | |
$cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs'; | |
$cfg['Servers'][$i]['tracking'] = 'pma__tracking'; | |
$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig'; | |
$cfg['Servers'][$i]['recent'] = 'pma__recent'; | |
$cfg['Servers'][$i]['favorite'] = 'pma__favorite'; | |
$cfg['Servers'][$i]['users'] = 'pma__users'; | |
$cfg['Servers'][$i]['usergroups'] = 'pma__usergroups'; | |
$cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding'; | |
$cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches'; | |
$cfg['Servers'][$i]['central_columns'] = 'pma__central_columns'; | |
$cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings'; | |
$cfg['Servers'][$i]['export_templates'] = 'pma__export_templates'; | |
/** | |
* End of servers configuration | |
*/ | |
/** | |
* Directories for saving/loading files from server | |
*/ | |
$cfg['UploadDir'] = ''; | |
$cfg['SaveDir'] = ''; | |
/** | |
* Whether to display icons or text or both icons and text in table row | |
* action segment. Value can be either of 'icons', 'text' or 'both'. | |
* default = 'both' | |
*/ | |
//$cfg['RowActionType'] = 'icons'; | |
/** | |
* Defines whether a user should be displayed a "show all (records)" | |
* button in browse mode or not. | |
* default = false | |
*/ | |
//$cfg['ShowAll'] = true; | |
/** | |
* Number of rows displayed when browsing a result set. If the result | |
* set contains more rows, "Previous" and "Next". | |
* Possible values: 25, 50, 100, 250, 500 | |
* default = 25 | |
*/ | |
$cfg['MaxRows'] = 50; | |
/** | |
* Disallow editing of binary fields | |
* valid values are: | |
* false allow editing | |
* 'blob' allow editing except for BLOB fields | |
* 'noblob' disallow editing except for BLOB fields | |
* 'all' disallow editing | |
* default = 'blob' | |
*/ | |
//$cfg['ProtectBinary'] = false; | |
/** | |
* Default language to use, if not browser-defined or user-defined | |
* (you find all languages in the locale folder) | |
* uncomment the desired line: | |
* default = 'en' | |
*/ | |
$cfg['DefaultLang'] = 'en'; | |
//$cfg['DefaultLang'] = 'de'; | |
/** | |
* How many columns should be used for table display of a database? | |
* (a value larger than 1 results in some information being hidden) | |
* default = 1 | |
*/ | |
//$cfg['PropertiesNumColumns'] = 2; | |
/** | |
* Set to true if you want DB-based query history.If false, this utilizes | |
* JS-routines to display query history (lost by window close) | |
* | |
* This requires configuration storage enabled, see above. | |
* default = false | |
*/ | |
//$cfg['QueryHistoryDB'] = true; | |
/** | |
* When using DB-based query history, how many entries should be kept? | |
* default = 25 | |
*/ | |
//$cfg['QueryHistoryMax'] = 100; | |
/** | |
* Whether or not to query the user before sending the error report to | |
* the phpMyAdmin team when a JavaScript error occurs | |
* | |
* Available options | |
* ('ask' | 'always' | 'never') | |
* default = 'ask' | |
*/ | |
//$cfg['SendErrorReports'] = 'always'; | |
/** | |
* You can find more configuration options in the documentation | |
* in the doc/ folder or at <https://docs.phpmyadmin.net/>. | |
*/ |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment