title: phpMyAdmin with RDS & Elastic Beanstalk
body: <p>I have an app loaded with Amazon Elastic Beanstalk and DB at Amazon RDS. My Application is able to contact Database which is functioning well and I can connect to mySQL from AWS EC2 CLI.</p>
  
  <p>Problem:    I can't get phpMyAdmin to connect to my Amazon RDS instance.
              (Error #2002 Cannot log in to the MySQL server)</p>
  
  <blockquote>
    <p>/etc/httpd/conf.d/phpMyAdmin.conf</p>
  </blockquote>
  
  <pre><code>Alias /phpMyAdmin /usr/share/phpMyAdmin
  Alias /phpmyadmin /usr/share/phpMyAdmin
  &lt;Directory /usr/share/phpMyAdmin/&gt;
     AddDefaultCharset UTF-8
  
     &lt;IfModule mod_authz_core.c&gt;
       &lt;RequireAny&gt;
         Require ip 127.0.0.1
         Require ip xx.xx.xx.xx
         Require ip ::1
  
       &lt;/RequireAny&gt;
     &lt;/IfModule&gt;
     &lt;IfModule !mod_authz_core.c&gt;
       Order Deny,Allow
       Allow from 127.0.0.1
       Allow from xx.xx.xx.xx
       Allow from ::1
     &lt;/IfModule&gt;
  &lt;/Directory&gt;
  
  &lt;Directory /usr/share/phpMyAdmin/setup/&gt;
     &lt;IfModule mod_authz_core.c&gt;
       &lt;RequireAny&gt;
         Require ip 127.0.0.1
         Require ip xx.xx.xx.xx
         Require ip ::1
       &lt;/RequireAny&gt;
     &lt;/IfModule&gt;
     &lt;IfModule !mod_authz_core.c&gt;
       Order Deny,Allow
       Allow from 127.0.0.1
       Allow from xx.xx.xx.xx
       Allow from ::1
     &lt;/IfModule&gt;
  &lt;/Directory&gt;
  
  &lt;Directory /usr/share/phpMyAdmin/libraries/&gt;
      Order Deny,Allow
      Allow from All
  &lt;/Directory&gt;
  
  &lt;Directory /usr/share/phpMyAdmin/setup/lib/&gt;
      Order Deny,Allow
      Allow from All
  &lt;/Directory&gt;
  
  &lt;Directory /usr/share/phpMyAdmin/setup/frames/&gt;
      Order Deny,Allow
      Deny from All
      Allow from All
  &lt;/Directory&gt;
  </code></pre>
  
  <p><br>
  <code>/etc/phpMyAdmin/config.inc.php</code></p>
  
  <pre><code>$i = 0;
  
  
  $i++;
  $cfg['Servers'][$i]['host']          = 'MYAWSRDS.rds.amazonaws.com'; // MySQL hostname or IP address
  $cfg['Servers'][$i]['port']          = '3306';          // MySQL port - leave blank for default port
  $cfg['Servers'][$i]['socket']        = '';          // Path to the socket - leave blank for default socket
  $cfg['Servers'][$i]['connect_type']  = 'tcp';       // How to connect to MySQL server ('tcp' or 'socket')
  $cfg['Servers'][$i]['extension']     = 'mysqli';    // The php MySQL extension to use ('mysql' or 'mysqli')
  $cfg['Servers'][$i]['compress']      = FALSE;       // Use compressed protocol for the MySQL connection
                                                      // (requires PHP &gt;= 4.3.0)
  $cfg['Servers'][$i]['controluser']   = '';          // MySQL control user settings
                                                      // (this user must have read-only
  $cfg['Servers'][$i]['controlpass']   = '';          // access to the "mysql/user"
                                                      // and "mysql/db" tables).
                                                      // The controluser is also
                                                      // used for all relational
                                                      // features (pmadb)
  $cfg['Servers'][$i]['auth_type']     = 'cookie';    // Authentication method (config, http or cookie based)?
  $cfg['Servers'][$i]['user']          = 'username'  // MySQL user
  $cfg['Servers'][$i]['password']      = '';          // MySQL password (only needed
                                                      // with 'config' auth_type)
  $cfg['Servers'][$i]['only_db']       = '';          // If set to a db-name, only
                                                      // this db is displayed in left frame
                                                      // It may also be an array of db-names, where sorting order is relevant.
  $cfg['Servers'][$i]['hide_db']       = '';          // Database name to be hidden from listings
  $cfg['Servers'][$i]['verbose']       = '';          // Verbose name for this host - leave blank to show the hostname
  
  $cfg['Servers'][$i]['pmadb']         = '';          // Database used for Relation, Bookmark and PDF Features
                                                      // (see scripts/create_tables.sql)
                                                      //   - leave blank for no support
                                                      //     DEFAULT: 'phpmyadmin'
  $cfg['Servers'][$i]['bookmarktable'] = '';          // Bookmark table
                                                      //   - leave blank for no bookmark support
                                                      //     DEFAULT: 'pma_bookmark'
  $cfg['Servers'][$i]['relation']      = '';          // table to describe the relation between links (see doc)
                                                      //   - leave blank for no relation-links support
                                                      //     DEFAULT: 'pma_relation'
  $cfg['Servers'][$i]['table_info']    = '';          // table to describe the display fields
                                                      //   - leave blank for no display fields support
                                                      //     DEFAULT: 'pma_table_info'
  $cfg['Servers'][$i]['table_coords']  = '';          // table to describe the tables position for the PDF schema
                                                      //   - leave blank for no PDF schema support
                                                      //     DEFAULT: 'pma_table_coords'
  $cfg['Servers'][$i]['pdf_pages']     = '';          // table to describe pages of relationpdf
                                                      //   - leave blank if you don't want to use this
                                                      //     DEFAULT: 'pma_pdf_pages'
  $cfg['Servers'][$i]['column_info']   = '';          // table to store column information
                                                      //   - leave blank for no column comments/mime types
                                                      //     DEFAULT: 'pma_column_info'
  $cfg['Servers'][$i]['history']       = '';          // table to store SQL history
                                                      //   - leave blank for no SQL query history
                                                      //     DEFAULT: 'pma_history'
  $cfg['Servers'][$i]['verbose_check'] = TRUE;        // set to FALSE if you know that your pma_* tables
                                                      // are up to date. This prevents compatibility
                                                      // checks and thereby increases performance.
  $cfg['Servers'][$i]['AllowRoot']     = TRUE;        // whether to allow root login
  $cfg['Servers'][$i]['AllowDeny']['order']           // Host authentication order, leave blank to not use
                                       = '';
  $cfg['Servers'][$i]['AllowDeny']['rules']           // Host authentication rules, leave blank for defaults
                                       = array();
  $cfg['Servers'][$i]['AllowNoPassword']              // Allow logins without a password. Do not change the FALSE
                                       = FALSE;       // default unless you're running a passwordless MySQL server
  $cfg['Servers'][$i]['designer_coords']              // Leave blank (default) for no Designer support, otherwise
                                       = '';          // set to suggested 'pma_designer_coords' if really needed
  $cfg['Servers'][$i]['bs_garbage_threshold']         // Blobstreaming: Recommented default value from upstream
                                       = 50;          //   DEFAULT: '50'
  $cfg['Servers'][$i]['bs_repository_threshold']      // Blobstreaming: Recommented default value from upstream
                                       = '32M';       //   DEFAULT: '32M'
  $cfg['Servers'][$i]['bs_temp_blob_timeout']         // Blobstreaming: Recommented default value from upstream
                                       = 600;         //   DEFAULT: '600'
  $cfg['Servers'][$i]['bs_temp_log_threshold']        // Blobstreaming: Recommented default value from upstream
                                       = '32M';       //   DEFAULT: '32M'
  
  
  $cfg['UploadDir'] = '/var/lib/phpMyAdmin/upload';
  $cfg['SaveDir']   = '/var/lib/phpMyAdmin/save';
  
  
  $cfg['PmaNoRelation_DisableWarning'] = TRUE;
  </code></pre>