Question 63918 in PhpMyAdmin Question posted in
The official documentation can be found here.

How to setup AWS rds with SSL with phpmyadmin

I want to encrypt the connection to db from phpmyadmin using SSL. I am confused on how to use bundle certificate

Tags:

3

Answers


  1. 0

    You have to set it up as described in the docs using $cfg[‘Servers’][$i][‘ssl’] option:

    Whether to enable SSL for the connection between phpMyAdmin and the MySQL server to secure the connection.

    Login or Signup to reply.
  2. 0

    This worked for me:

    Upload the rds-combined-ca-bundle.pem to some path that phpMyAdmin can access.

    Then set the following configuration vars in config.inc.php:

    $cfg['Servers'][$i]['ssl_ca_path'] = '/path/to/';
$cfg['Servers'][$i]['ssl_key'] = 'rds-combined-ca-bundle.pem';
$cfg['Servers'][$i]['ssl_cert'] = 'rds-combined-ca-bundle.pem';
$cfg['Servers'][$i]['ssl_ca'] = '/path/to/rds-combined-ca-bundle.pem';
    Login or Signup to reply.
  3. 0

    First you have to download the certificate by visiting here:
    Download an SSL certificate for your managed database in Amazon Lightsail

    Here is a direct link for combined ca bundle:
    rds-combined-ca-bundle.pem

    Now copy this ‘rds-combined-ca-bundle.pem’ file to your phpMyAdmin folder and search for config.inc.php file.

    open this file (config.inc.php) in notepad or in any text editor and write the below lines:

    $cfg['Servers'][$i]['ssl'] = true;
$cfg['Servers'][$i]['ssl_ca'] = 'rds-combined-ca-bundle.pem';
$cfg['Servers'][$i]['ssl_mode'] = 'VERIFY_IDENTITY';

    Now save the file and visit you host (http://localhost/phpMyAdmin).

    enter image description here

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search