php - phpMyAdmin with RDS & Elastic Beanstalk -

php - phpMyAdmin with RDS & Elastic Beanstalk -

i have app loaded amazon elastic beanstalk , db @ amazon rds. application able contact database functioning , can connect mysql aws ec2 cli.

problem: can't phpmyadmin connect amazon rds instance. (error #2002 cannot log in mysql server)

/etc/httpd/conf.d/phpmyadmin.conf

alias /phpmyadmin /usr/share/phpmyadmin alias /phpmyadmin /usr/share/phpmyadmin <directory /usr/share/phpmyadmin/> adddefaultcharset utf-8 <ifmodule mod_authz_core.c> <requireany> require ip 127.0.0.1 require ip xx.xx.xx.xx require ip ::1 </requireany> </ifmodule> <ifmodule !mod_authz_core.c> order deny,allow allow 127.0.0.1 allow xx.xx.xx.xx allow ::1 </ifmodule> </directory> <directory /usr/share/phpmyadmin/setup/> <ifmodule mod_authz_core.c> <requireany> require ip 127.0.0.1 require ip xx.xx.xx.xx require ip ::1 </requireany> </ifmodule> <ifmodule !mod_authz_core.c> order deny,allow allow 127.0.0.1 allow xx.xx.xx.xx allow ::1 </ifmodule> </directory> <directory /usr/share/phpmyadmin/libraries/> order deny,allow allow </directory> <directory /usr/share/phpmyadmin/setup/lib/> order deny,allow allow </directory> <directory /usr/share/phpmyadmin/setup/frames/> order deny,allow deny allow </directory>

/etc/phpmyadmin/config.inc.php

$i = 0; $i++; $cfg['servers'][$i]['host'] = 'myawsrds.rds.amazonaws.com'; // mysql hostname or ip address $cfg['servers'][$i]['port'] = '3306'; // mysql port - leave blank default port $cfg['servers'][$i]['socket'] = ''; // path socket - leave blank default socket $cfg['servers'][$i]['connect_type'] = 'tcp'; // how connect mysql server ('tcp' or 'socket') $cfg['servers'][$i]['extension'] = 'mysqli'; // php mysql extension utilize ('mysql' or 'mysqli') $cfg['servers'][$i]['compress'] = false; // utilize compressed protocol mysql connection // (requires php >= 4.3.0) $cfg['servers'][$i]['controluser'] = ''; // mysql command user settings // (this user must have read-only $cfg['servers'][$i]['controlpass'] = ''; // access "mysql/user" // , "mysql/db" tables). // controluser // used relational // features (pmadb) $cfg['servers'][$i]['auth_type'] = 'cookie'; // authentication method (config, http or cookie based)? $cfg['servers'][$i]['user'] = 'username' // mysql user $cfg['servers'][$i]['password'] = ''; // mysql password (only needed // 'config' auth_type) $cfg['servers'][$i]['only_db'] = ''; // if set db-name, // db displayed in left frame // may array of db-names, sorting order relevant. $cfg['servers'][$i]['hide_db'] = ''; // database name hidden listings $cfg['servers'][$i]['verbose'] = ''; // verbose name host - leave blank show hostname $cfg['servers'][$i]['pmadb'] = ''; // database used relation, bookmark , pdf features // (see scripts/create_tables.sql) // - leave blank no back upwards // default: 'phpmyadmin' $cfg['servers'][$i]['bookmarktable'] = ''; // bookmark table // - leave blank no bookmark back upwards // default: 'pma_bookmark' $cfg['servers'][$i]['relation'] = ''; // table describe relation between links (see doc) // - leave blank no relation-links back upwards // default: 'pma_relation' $cfg['servers'][$i]['table_info'] = ''; // table describe display fields // - leave blank no display fields back upwards // default: 'pma_table_info' $cfg['servers'][$i]['table_coords'] = ''; // table describe tables position pdf schema // - leave blank no pdf schema back upwards // default: 'pma_table_coords' $cfg['servers'][$i]['pdf_pages'] = ''; // table describe pages of relationpdf // - leave blank if don't want utilize // default: 'pma_pdf_pages' $cfg['servers'][$i]['column_info'] = ''; // table store column info // - leave blank no column comments/mime types // default: 'pma_column_info' $cfg['servers'][$i]['history'] = ''; // table store sql history // - leave blank no sql query history // default: 'pma_history' $cfg['servers'][$i]['verbose_check'] = true; // set false if know pma_* tables // date. prevents compatibility // checks , thereby increases performance. $cfg['servers'][$i]['allowroot'] = true; // whether allow root login $cfg['servers'][$i]['allowdeny']['order'] // host authentication order, leave blank not utilize = ''; $cfg['servers'][$i]['allowdeny']['rules'] // host authentication rules, leave blank defaults = array(); $cfg['servers'][$i]['allownopassword'] // allow logins without password. not alter false = false; // default unless you're running passwordless mysql server $cfg['servers'][$i]['designer_coords'] // leave blank (default) no designer support, otherwise = ''; // set suggested 'pma_designer_coords' if needed $cfg['servers'][$i]['bs_garbage_threshold'] // blobstreaming: recommented default value upstream = 50; // default: '50' $cfg['servers'][$i]['bs_repository_threshold'] // blobstreaming: recommented default value upstream = '32m'; // default: '32m' $cfg['servers'][$i]['bs_temp_blob_timeout'] // blobstreaming: recommented default value upstream = 600; // default: '600' $cfg['servers'][$i]['bs_temp_log_threshold'] // blobstreaming: recommented default value upstream = '32m'; // default: '32m' $cfg['uploaddir'] = '/var/lib/phpmyadmin/upload'; $cfg['savedir'] = '/var/lib/phpmyadmin/save'; $cfg['pmanorelation_disablewarning'] = true;

in config.inc.php seek using $cfg['servers'][$i]['host'] = 'localhost'; or $cfg['servers'][$i]['host'] = '127.0.0.1';

what happening mysql server not accepting connections outside ip addresses; when utilize total hostname in host directive appears come external connection (even though it's on same machine networking looks host differently). either of values forcefulness connect without going external address (though utilize different means why we'll seek both).

when trying 'localhost' may need alter connect_type 'socket'.

php mysql amazon-ec2 phpmyadmin amazon-rds