Last active
November 21, 2020 10:50
-
-
Save sudopower/0198cd338523835aab92a6b0103afc1d to your computer and use it in GitHub Desktop.
phpmyadmin (xampp) connect to AWS RDS or any remote db
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 | |
//CHANGE STARTS FROM LINE NO 60, you could replace the file if you're using xampp (pls backup existing one just in case) | |
/* | |
* This is needed for cookie based authentication to encrypt password in | |
* cookie | |
*/ | |
$cfg['blowfish_secret'] = 'xampp'; /* YOU SHOULD CHANGE THIS FOR A MORE SECURE COOKIE AUTH! */ | |
/* | |
* Servers configuration | |
*/ | |
$i = 0; | |
/* | |
* First server | |
*/ | |
$i++; | |
/* Authentication type and info */ | |
$cfg['Servers'][$i]['auth_type'] = 'config'; | |
$cfg['Servers'][$i]['user'] = 'root'; | |
$cfg['Servers'][$i]['password'] = ''; | |
$cfg['Servers'][$i]['extension'] = 'mysqli'; | |
$cfg['Servers'][$i]['AllowNoPassword'] = true; | |
$cfg['Lang'] = ''; | |
/* Bind to the localhost ipv4 address and tcp */ | |
$cfg['Servers'][$i]['host'] = '127.0.0.1'; | |
$cfg['Servers'][$i]['connect_type'] = 'tcp'; | |
/* User for advanced features */ | |
$cfg['Servers'][$i]['controluser'] = 'pma'; | |
$cfg['Servers'][$i]['controlpass'] = ''; | |
/* 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'; | |
$cfg['Servers'][$i]['tracking'] = 'pma__tracking'; | |
$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig'; | |
$cfg['Servers'][$i]['recent'] = 'pma__recent'; | |
$cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs'; | |
$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'; | |
$cfg['Servers'][$i]['favorite'] = 'pma__favorite'; | |
/*This will create a dropdown to select between the databases keep adding as many dbs you like */ | |
$i++; | |
$cfg['Servers'][$i]['host'] = 'exampledb.blah.rds.amazonaws.com'; | |
$cfg['Servers'][$i]['user'] = 'username'; | |
$cfg['Servers'][$i]['password'] = 'password'; | |
$cfg['Servers'][$i]['port'] = '3306'; | |
$cfg['Servers'][$i]['auth_type'] = 'config'; | |
/* | |
* End of servers configuration | |
*/ | |
?> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment