Last active
February 2, 2023 20:35
-
-
Save jedihe/6117009 to your computer and use it in GitHub Desktop.
PhpMyAdmin config file with autologin enabled (user/pass: root/root). Useful for private development environments, USE AT YOUR OWN RISK. Copied from install on Ubuntu Server 12.04.
This file contains 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 | |
/** | |
* Debian local configuration file | |
* | |
* This file overrides the settings made by phpMyAdmin interactive setup | |
* utility. | |
* | |
* For example configuration see | |
* /usr/share/doc/phpmyadmin/examples/config.sample.inc.php | |
* or | |
* /usr/share/doc/phpmyadmin/examples/config.manyhosts.inc.php | |
* | |
* NOTE: do not add security sensitive data to this file (like passwords) | |
* unless you really know what you're doing. If you do, any user that can | |
* run PHP or CGI on your webserver will be able to read them. If you still | |
* want to do this, make sure to properly secure the access to this file | |
* (also on the filesystem level). | |
*/ | |
// Load secret generated on postinst | |
include('/var/lib/phpmyadmin/blowfish_secret.inc.php'); | |
// Load autoconf local config | |
include('/var/lib/phpmyadmin/config.inc.php'); | |
/** | |
* Server(s) configuration | |
*/ | |
$i = 0; | |
// The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use $cfg['Servers'][0]. | |
// You can disable a server config entry by setting host to ''. | |
$i++; | |
/** | |
* Read configuration from dbconfig-common | |
* You can regenerate it using: dpkg-reconfigure -plow phpmyadmin | |
*/ | |
if (is_readable('/etc/phpmyadmin/config-db.php')) { | |
require('/etc/phpmyadmin/config-db.php'); | |
} else { | |
error_log('phpmyadmin: Failed to load /etc/phpmyadmin/config-db.php.' | |
. ' Check group www-data has read access.'); | |
} | |
/* Configure according to dbconfig-common if enabled */ | |
if (!empty($dbname)) { | |
/* Authentication type */ | |
$cfg['Servers'][$i]['auth_type'] = 'cookie'; | |
/* Server parameters */ | |
if (empty($dbserver)) $dbserver = 'localhost'; | |
$cfg['Servers'][$i]['host'] = $dbserver; | |
if (!empty($dbport) || $dbserver != 'localhost') { | |
$cfg['Servers'][$i]['connect_type'] = 'tcp'; | |
$cfg['Servers'][$i]['port'] = $dbport; | |
} | |
//$cfg['Servers'][$i]['compress'] = false; | |
/* Select mysqli if your server has it */ | |
$cfg['Servers'][$i]['extension'] = 'mysqli'; | |
/* Optional: User for advanced features */ | |
$cfg['Servers'][$i]['controluser'] = $dbuser; | |
$cfg['Servers'][$i]['controlpass'] = $dbpass; | |
/* Optional: Advanced phpMyAdmin features */ | |
$cfg['Servers'][$i]['pmadb'] = $dbname; | |
$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]['designer_coords'] = 'pma_designer_coords'; | |
$cfg['Servers'][$i]['tracking'] = 'pma_tracking'; | |
$cfg['Servers'][$i]['userconfig'] = 'pma_userconfig'; | |
/* Uncomment the following to enable logging in to passwordless accounts, | |
* after taking note of the associated security risks. */ | |
// $cfg['Servers'][$i]['AllowNoPassword'] = TRUE; | |
// Enable auto-login | |
$cfg['Servers'][$i]['auth_type'] = 'config'; | |
$cfg['Servers'][$i]['username'] = 'root'; | |
$cfg['Servers'][$i]['password'] = 'root'; | |
/* Advance to next server for rest of config */ | |
$i++; | |
} | |
/* Authentication type */ | |
//$cfg['Servers'][$i]['auth_type'] = 'cookie'; | |
/* Server parameters */ | |
//$cfg['Servers'][$i]['host'] = 'localhost'; | |
//$cfg['Servers'][$i]['connect_type'] = 'tcp'; | |
//$cfg['Servers'][$i]['compress'] = false; | |
/* Select mysqli if your server has it */ | |
//$cfg['Servers'][$i]['extension'] = 'mysql'; | |
/* Optional: User for advanced features */ | |
// $cfg['Servers'][$i]['controluser'] = 'pma'; | |
// $cfg['Servers'][$i]['controlpass'] = 'pmapass'; | |
/* Optional: Advanced phpMyAdmin features */ | |
// $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]['designer_coords'] = 'pma_designer_coords'; | |
/* Uncomment the following to enable logging in to passwordless accounts, | |
* after taking note of the associated security risks. */ | |
// $cfg['Servers'][$i]['AllowNoPassword'] = TRUE; | |
/* | |
* End of servers configuration | |
*/ | |
/* | |
* Directories for saving/loading files from server | |
*/ | |
$cfg['UploadDir'] = ''; | |
$cfg['SaveDir'] = ''; |
In summary, change
$cfg['Servers'][$i]['auth_type'] = 'cookie';
to
$cfg['Servers'][$i]['auth_type'] = 'config';
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Alternative:
https://gist.github.com/ricardojlrufino/0bfddc33e172c8fc1f127f8b439ced18