Access AWS RDS database from phpmyadmin







If you want to access AWS RDS database from phpmyadmin,
follow the steps to access this:


  •   change your config.inc.php

add the lines at the end of the file,

/* End of servers configuration */
$i++;
$cfg['Servers'][$i]['verbose'] = 'Database Server 2';
$cfg['Servers'][$i]['host'] = '----.rds.amazonaws.com';
$cfg['Servers'][$i]['port'] = '3306';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['compress'] = TRUE;

$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = '------';  // user name
$cfg['Servers'][$i]['password'] = '----------------'; // password
 



  •   Now access your localhost phpmyadmin and then change "server choice":



Now, enjoy your AWS RDS database from your localhost phpmyadmin.







Comments