phpMyAdmin Configuration

Add/replace the lines below within the phpMyAdmin conf file (config.inc.php).

To view full table list in phpMyAdmin console, import the create_tables.sql file from the phpmyadmin/sql folder into the RDS database server (i.e. not selecting any specific database).

/* Authentication type - set to config, avoids login */
$cfg['Servers'][$i]['auth_type'] = 'config';

$cfg['Servers'][$i]['host'] = '<db endpoint address in RDS instance properties>';
$cfg['Servers'][$i]['port'] = '<port, 3306 for MariaDB>';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['user'] = '<master username, check RDS instance details>';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['password'] = '<master password, created during RDS instance creation>';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['AllowNoPassword'] = false;