{"id":4841,"date":"2023-11-22T14:11:36","date_gmt":"2023-11-22T14:11:36","guid":{"rendered":"https:\/\/sparksupport.com\/blog\/?p=4841"},"modified":"2024-06-21T11:28:34","modified_gmt":"2024-06-21T11:28:34","slug":"access-aws-rds-mysql-instance-with-phpmyadmin","status":"publish","type":"post","link":"https:\/\/sparksupport.com\/blog\/access-aws-rds-mysql-instance-with-phpmyadmin\/","title":{"rendered":"Access AWS RDS MySQL Instance with phpMyAdmin"},"content":{"rendered":"
\n

When you have your application’s database hosted on your server, you normally install phpmyadmin on the server and access it via the browser to perform administration tasks such as running queries, adding user accounts, creating new databases, etc.
\nBut what will you do when you are asked to move the database to a distributed database service like Amazon RDS? Nothing to worry about; phpmyadmin can be configured to access RDS databases by tweaking the configuration file. Creating and configuring RDS on AWS is a different topic and is not discussed here.
\nIf you are running on Ubuntu 20 or 22, simply edit the file \/etc\/phpmyadmin\/config.inc.php and locate the below-mentioned code.
\n\/** * phpMyAdmin configuration storage settings. *\/ Above that, insert the details of the RDS server. A typical entry would look like this:<\/p>\n

$cfg['Servers'][$i]['host'] = 'xxxxxxxxxxxxxxxxxxx-west-2.rds.amazonaws.com'; $cfg['Servers'][$i]['port'] = '3306'; $cfg['Servers'][$i]['verbose'] = 'RDS HOST'; $cfg['Servers'][$i]['connect_type'] = 'tcp'; $cfg['Servers'][$i]['extension'] = 'mysql'; $cfg['Servers'][$i]['compress'] = TRUE;<\/pre>\n
xxxxxxxxxxxxxxxxxxx-west-2.rds.amazonaws.com is the RDS server name.
\nNow, you may simply access your phpmyadmin login page and enter the RDS credentials to access the database.
\nIn most cases, you might not have moved all the databases from the server to RDS. So you would still need to access those databases via the phpmyadmin interface. How will you manage that?
\nDo you need another PHPMyAdmin installation? Fortunately, the answer is no. PHPMyAdmin allows you to select the host before attempting to make the connection.<\/p>\n
How do I enable multi-host selection?<\/h2>\n
Simply edit the same conf file, config.inc.php, and under the details of the RDS server we recently added, insert the details of the extra host you want to add. But note that you have to increment the value of the variable $i by one. i.e $i++. Each server is added as an array element, and we increment the array index before storing the host details. So you will be adding the below text to your conf under the previous block.<\/p>\n
$i++; $cfg['Servers'][$i]['host'] = 'localhost'; $cfg['Servers'][$i]['port'] = '3306'; $cfg['Servers'][$i]['verbose'] = 'LOCALHOST'; $cfg['Servers'][$i]['connect_type'] = 'tcp'; $cfg['Servers'][$i]['extension'] ='mysql'; $cfg['Servers'][$i]['compress'] = TRUE;\r\n<\/pre>\n
Note: Don’t forget the $i++.
\nThis will enable the “Server Choice” dropdown option on the login page of phpmyadmin. It will display the options set in the’verbose’ variable of the server sections.<\/p>\n
\"\"<\/p>\n
In our example, the dropdown will show two “Server Choice” options: RDS and Localhost.
\nYou may extend this logic to add as many hosts as you want.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
When you have your application’s database hosted on your server, you normally install phpmyadmin on the server and access it via the browser to perform<\/p>\n","protected":false},"author":1,"featured_media":4843,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[261,262],"class_list":["post-4841","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized","tag-access-aws","tag-phpmyadmin"],"acf":[],"yoast_head":"\nAccess AWS RDS MySQL Instance with phpMyAdmin -<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sparksupport.com\/blog\/access-aws-rds-mysql-instance-with-phpmyadmin\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Access AWS RDS MySQL Instance with phpMyAdmin -\" \/>\n<meta property=\"og:description\" content=\"When you have your application’s database hosted on your server, you normally install phpmyadmin on the server and access it via the browser to perform\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sparksupport.com\/blog\/access-aws-rds-mysql-instance-with-phpmyadmin\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-22T14:11:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-06-21T11:28:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sparksupport.com\/blog\/wp-content\/uploads\/2023\/11\/Access-AWS-RDS-MySQL-Instance-with-phpMyAdmin.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"SparkSupport\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SparkSupport\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/sparksupport.com\/blog\/access-aws-rds-mysql-instance-with-phpmyadmin\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/sparksupport.com\/blog\/access-aws-rds-mysql-instance-with-phpmyadmin\/\"},\"author\":{\"name\":\"SparkSupport\",\"@id\":\"https:\/\/sparksupport.com\/blog\/#\/schema\/person\/b359b1e8bc00b1d71637775f13a9ec44\"},\"headline\":\"Access AWS RDS MySQL Instance with phpMyAdmin\",\"datePublished\":\"2023-11-22T14:11:36+00:00\",\"dateModified\":\"2024-06-21T11:28:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/sparksupport.com\/blog\/access-aws-rds-mysql-instance-with-phpmyadmin\/\"},\"wordCount\":375,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/sparksupport.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/sparksupport.com\/blog\/access-aws-rds-mysql-instance-with-phpmyadmin\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sparksupport.com\/blog\/wp-content\/uploads\/2023\/11\/Access-AWS-RDS-MySQL-Instance-with-phpMyAdmin.png\",\"keywords\":[\"access aws\",\"phpmyadmin\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/sparksupport.com\/blog\/access-aws-rds-mysql-instance-with-phpmyadmin\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/sparksupport.com\/blog\/access-aws-rds-mysql-instance-with-phpmyadmin\/\",\"url\":\"https:\/\/sparksupport.com\/blog\/access-aws-rds-mysql-instance-with-phpmyadmin\/\",\"name\":\"Access AWS RDS MySQL Instance with phpMyAdmin -\",\"isPartOf\":{\"@id\":\"https:\/\/sparksupport.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/sparksupport.com\/blog\/access-aws-rds-mysql-instance-with-phpmyadmin\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/sparksupport.com\/blog\/access-aws-rds-mysql-instance-with-phpmyadmin\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sparksupport.com\/blog\/wp-content\/uploads\/2023\/11\/Access-AWS-RDS-MySQL-Instance-with-phpMyAdmin.png\",\"datePublished\":\"2023-11-22T14:11:36+00:00\",\"dateModified\":\"2024-06-21T11:28:34+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/sparksupport.com\/blog\/access-aws-rds-mysql-instance-with-phpmyadmin\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/sparksupport.com\/blog\/access-aws-rds-mysql-instance-with-phpmyadmin\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/sparksupport.com\/blog\/access-aws-rds-mysql-instance-with-phpmyadmin\/#primaryimage\",\"url\":\"https:\/\/sparksupport.com\/blog\/wp-content\/uploads\/2023\/11\/Access-AWS-RDS-MySQL-Instance-with-phpMyAdmin.png\",\"contentUrl\":\"https:\/\/sparksupport.com\/blog\/wp-content\/uploads\/2023\/11\/Access-AWS-RDS-MySQL-Instance-with-phpMyAdmin.png\",\"width\":1200,\"height\":628},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/sparksupport.com\/blog\/access-aws-rds-mysql-instance-with-phpmyadmin\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/sparksupport.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Access AWS RDS MySQL Instance with phpMyAdmin\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/sparksupport.com\/blog\/#website\",\"url\":\"https:\/\/sparksupport.com\/blog\/\",\"name\":\"SparkSupport Blog\",\"description\":\"SparkSupport Blogs\",\"publisher\":{\"@id\":\"https:\/\/sparksupport.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/sparksupport.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/sparksupport.com\/blog\/#organization\",\"name\":\"SparkSupport\",\"url\":\"https:\/\/sparksupport.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/sparksupport.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/sparksupport.com\/blog\/wp-content\/uploads\/2019\/08\/cropped-logo-1.jpg\",\"contentUrl\":\"https:\/\/sparksupport.com\/blog\/wp-content\/uploads\/2019\/08\/cropped-logo-1.jpg\",\"width\":216,\"height\":44,\"caption\":\"SparkSupport\"},\"image\":{\"@id\":\"https:\/\/sparksupport.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/sparksupport.com\/blog\/#\/schema\/person\/b359b1e8bc00b1d71637775f13a9ec44\",\"name\":\"SparkSupport\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/4d86cc3c0d188e40e99abec16795ed658b95c89ab15427bd7254315e8115b40b?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/4d86cc3c0d188e40e99abec16795ed658b95c89ab15427bd7254315e8115b40b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/4d86cc3c0d188e40e99abec16795ed658b95c89ab15427bd7254315e8115b40b?s=96&d=mm&r=g\",\"caption\":\"SparkSupport\"},\"url\":\"https:\/\/sparksupport.com\/blog\/author\/spark_wp_admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Access AWS RDS MySQL Instance with phpMyAdmin -","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/sparksupport.com\/blog\/access-aws-rds-mysql-instance-with-phpmyadmin\/","og_locale":"en_US","og_type":"article","og_title":"Access AWS RDS MySQL Instance with phpMyAdmin -","og_description":"When you have your application’s database hosted on your server, you normally install phpmyadmin on the server and access it via the browser to perform","og_url":"https:\/\/sparksupport.com\/blog\/access-aws-rds-mysql-instance-with-phpmyadmin\/","article_published_time":"2023-11-22T14:11:36+00:00","article_modified_time":"2024-06-21T11:28:34+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/sparksupport.com\/blog\/wp-content\/uploads\/2023\/11\/Access-AWS-RDS-MySQL-Instance-with-phpMyAdmin.png","type":"image\/png"}],"author":"SparkSupport","twitter_card":"summary_large_image","twitter_misc":{"Written by":"SparkSupport","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sparksupport.com\/blog\/access-aws-rds-mysql-instance-with-phpmyadmin\/#article","isPartOf":{"@id":"https:\/\/sparksupport.com\/blog\/access-aws-rds-mysql-instance-with-phpmyadmin\/"},"author":{"name":"SparkSupport","@id":"https:\/\/sparksupport.com\/blog\/#\/schema\/person\/b359b1e8bc00b1d71637775f13a9ec44"},"headline":"Access AWS RDS MySQL Instance with phpMyAdmin","datePublished":"2023-11-22T14:11:36+00:00","dateModified":"2024-06-21T11:28:34+00:00","mainEntityOfPage":{"@id":"https:\/\/sparksupport.com\/blog\/access-aws-rds-mysql-instance-with-phpmyadmin\/"},"wordCount":375,"commentCount":0,"publisher":{"@id":"https:\/\/sparksupport.com\/blog\/#organization"},"image":{"@id":"https:\/\/sparksupport.com\/blog\/access-aws-rds-mysql-instance-with-phpmyadmin\/#primaryimage"},"thumbnailUrl":"https:\/\/sparksupport.com\/blog\/wp-content\/uploads\/2023\/11\/Access-AWS-RDS-MySQL-Instance-with-phpMyAdmin.png","keywords":["access aws","phpmyadmin"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sparksupport.com\/blog\/access-aws-rds-mysql-instance-with-phpmyadmin\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sparksupport.com\/blog\/access-aws-rds-mysql-instance-with-phpmyadmin\/","url":"https:\/\/sparksupport.com\/blog\/access-aws-rds-mysql-instance-with-phpmyadmin\/","name":"Access AWS RDS MySQL Instance with phpMyAdmin -","isPartOf":{"@id":"https:\/\/sparksupport.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sparksupport.com\/blog\/access-aws-rds-mysql-instance-with-phpmyadmin\/#primaryimage"},"image":{"@id":"https:\/\/sparksupport.com\/blog\/access-aws-rds-mysql-instance-with-phpmyadmin\/#primaryimage"},"thumbnailUrl":"https:\/\/sparksupport.com\/blog\/wp-content\/uploads\/2023\/11\/Access-AWS-RDS-MySQL-Instance-with-phpMyAdmin.png","datePublished":"2023-11-22T14:11:36+00:00","dateModified":"2024-06-21T11:28:34+00:00","breadcrumb":{"@id":"https:\/\/sparksupport.com\/blog\/access-aws-rds-mysql-instance-with-phpmyadmin\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sparksupport.com\/blog\/access-aws-rds-mysql-instance-with-phpmyadmin\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/sparksupport.com\/blog\/access-aws-rds-mysql-instance-with-phpmyadmin\/#primaryimage","url":"https:\/\/sparksupport.com\/blog\/wp-content\/uploads\/2023\/11\/Access-AWS-RDS-MySQL-Instance-with-phpMyAdmin.png","contentUrl":"https:\/\/sparksupport.com\/blog\/wp-content\/uploads\/2023\/11\/Access-AWS-RDS-MySQL-Instance-with-phpMyAdmin.png","width":1200,"height":628},{"@type":"BreadcrumbList","@id":"https:\/\/sparksupport.com\/blog\/access-aws-rds-mysql-instance-with-phpmyadmin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sparksupport.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Access AWS RDS MySQL Instance with phpMyAdmin"}]},{"@type":"WebSite","@id":"https:\/\/sparksupport.com\/blog\/#website","url":"https:\/\/sparksupport.com\/blog\/","name":"SparkSupport Blog","description":"SparkSupport Blogs","publisher":{"@id":"https:\/\/sparksupport.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sparksupport.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/sparksupport.com\/blog\/#organization","name":"SparkSupport","url":"https:\/\/sparksupport.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/sparksupport.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/sparksupport.com\/blog\/wp-content\/uploads\/2019\/08\/cropped-logo-1.jpg","contentUrl":"https:\/\/sparksupport.com\/blog\/wp-content\/uploads\/2019\/08\/cropped-logo-1.jpg","width":216,"height":44,"caption":"SparkSupport"},"image":{"@id":"https:\/\/sparksupport.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/sparksupport.com\/blog\/#\/schema\/person\/b359b1e8bc00b1d71637775f13a9ec44","name":"SparkSupport","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4d86cc3c0d188e40e99abec16795ed658b95c89ab15427bd7254315e8115b40b?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4d86cc3c0d188e40e99abec16795ed658b95c89ab15427bd7254315e8115b40b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4d86cc3c0d188e40e99abec16795ed658b95c89ab15427bd7254315e8115b40b?s=96&d=mm&r=g","caption":"SparkSupport"},"url":"https:\/\/sparksupport.com\/blog\/author\/spark_wp_admin\/"}]}},"_links":{"self":[{"href":"https:\/\/sparksupport.com\/blog\/wp-json\/wp\/v2\/posts\/4841","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sparksupport.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sparksupport.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sparksupport.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sparksupport.com\/blog\/wp-json\/wp\/v2\/comments?post=4841"}],"version-history":[{"count":0,"href":"https:\/\/sparksupport.com\/blog\/wp-json\/wp\/v2\/posts\/4841\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sparksupport.com\/blog\/wp-json\/wp\/v2\/media\/4843"}],"wp:attachment":[{"href":"https:\/\/sparksupport.com\/blog\/wp-json\/wp\/v2\/media?parent=4841"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sparksupport.com\/blog\/wp-json\/wp\/v2\/categories?post=4841"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sparksupport.com\/blog\/wp-json\/wp\/v2\/tags?post=4841"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}