aws rds import sql file code example

Example: using phpmyadmin on bitnami to access RDS instance

# Edit the phpMyAdmin configuration file at 
#  /opt/bitnami/apps/phpmyadmin/htdocs/config.inc.php 
#  and add the lines below to the end of the file:

$i++;
$cfg['Servers'][$i]['verbose'] = 'Amazon RDS';
$cfg['Servers'][$i]['host'] = 'RDS-ENDPOINT';
$cfg['Servers'][$i]['port'] = '3306';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['AllowNoPassword'] = false;