PHPMyAdmin For AWS RDS

PHPMyAdmin For AWS RDS

sudo apt install nginx-full mysql-client apache2-utils php7.4-{apcu,bcmath,bz2,curl,fpm,intl,json,gd,mbstring,mysql,xml,zip} phpmyadmin -y
or
sudo wget https://files.phpmyadmin.net/phpMyAdmin/5.1.1/phpMyAdmin-5.1.1-english.zip && sudo unzip phpMyAdmin-5.1.1-english.zip
mv phpMyAdmin-5.1.1-english phpmyadmin
mv phpmyadmin /usr/share/
sudo htpasswd -c /etc/nginx/.htpasswd username

wget -q https://gist.githubusercontent.com/amanjuman/595ba5ec6494a03e8b0544986cafb092/raw/2c078604ac65ee4aee2f58b89f3239817c89e2d3/phpmyadmin.conf -O /etc/nginx/conf.d/phpmyadmin.conf

sudo chown -R www-data:www-data /usr/share/phpmyadmin/
sudo mkdir /usr/share/phpmyadmin/upload -p
sudo mkdir /usr/share/phpmyadmin/save -p
sudo mkdir /usr/share/phpmyadmin/tmp -p
sudo chown -R www-data:www-data /usr/share/phpmyadmin/

wget -q https://s3.amazonaws.com/rds-downloads/rds-ca-2019-root.pem -O /etc/ssl/certs/aws-rds-ca-2019.pem

sudo nano /etc/phpmyadmin/config.inc.php
or
sudo cp /usr/share/phpmyadmin/config.sample.inc.php /usr/share/phpmyadmin/config.inc.php && sudo nano /usr/share/phpmyadmin/config.inc.php

$cfg['blowfish_secret'] = 'sPs:{ZC-.[n9c3gc{v8AZE0HF;w6pLc}';
$cfg['LoginCookieValidity'] = 7200;
$cfg['UploadDir'] = '/usr/share/phpmyadmin/upload';
$cfg['SaveDir'] = '/usr/share/phpmyadmin/save';


/* Server parameters */
$i++;
$cfg['Servers'][$i]['verbose'] = 'rds server name';
$cfg['Servers'][$i]['host'] = 'rds-host-name';
$cfg['Servers'][$i]['port'] = '3306';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['AllowNoPassword'] = false;
$cfg['Servers'][$i]['ssl']= true;
$cfg['Servers'][$i]['ssl_verify'] = true;
$cfg['Servers'][$i]['ssl_ca'] = '/etc/ssl/certs/aws-rds-ca-2019.pem';
$cfg['Servers'][$i]['ssl_cert'] = '/etc/letsencrypt/live/yourdomain.tld/fullchain.pem';
$cfg['Servers'][$i]['ssl_key'] = '/etc/letsencrypt/live/yourdomain.tld/privkey.pem';