{"id":951,"date":"2020-07-12T15:33:06","date_gmt":"2020-07-12T15:33:06","guid":{"rendered":"https:\/\/www.how2shout.com\/linux\/?p=951"},"modified":"2021-09-20T08:08:26","modified_gmt":"2021-09-20T08:08:26","slug":"how-to-access-remote-mysql-database-in-local-phpmyadmin","status":"publish","type":"post","link":"https:\/\/linux.how2shout.com\/how-to-access-remote-mysql-database-in-local-phpmyadmin\/","title":{"rendered":"How to access remote MySQL database in local phpMyAdmin"},"content":{"rendered":"<p>In most cases, the MySQL server and phpMyAdmin both are installed on the same server so that the management of the database becomes easy. However, do you know? We can even access the remote server in the phpMyAdmin with just a little tweak. If not, then here is the tutorial on that.<\/p>\n<p>phpMyAdmin is a PHP-based application to easily create, manage, edit, delete, import, and export MySQL databases. That\u2019s is the reason why most of the hosting companies are providing it as a default application either via cPanel or as manually installed on a cloud server. But what about the cloud hosting services especially such as<strong> Google, Amazon AWS Ec2 or LightSail<\/strong>, Digital Ocean, etc. where you manually create a server and separate database instances. Well, yes if we are using some pre-built stack such as Bitnami on them it will install the phpMyAdmin by default, or in case you are installing a database within the server instance then you can install phpMyAdmin as well. Both the setup will allow us to access the database application that resides on the same server.<\/p>\n<p>However, a separate database instance on the cloud is something different. It doesn\u2019t provide root access to the database server in most of the cases to make sure the security of it<\/p>\n<p>In such scenarios, if you still want to manage the cloud or any other web hosting MySQL database then simply install phpMyAdmin locally on your system. Yes, make sure the system you are going to use is secure without any malware. I recommend you should use Linux OS and those are on Windows 10 they can go for WSL (Windows system for Linux) because phpMyAdmin is natively a Linux tool.<\/p>\n<h2>Access Remote MySQL database on phpMyAdmin<\/h2>\n<p><strong>Note<\/strong>: if you already have phpMyAdmin installed on your local system or on Webhosting with root access to the server then simply jump to <strong>step 4<\/strong> of this tutorial.<\/p>\n<p><strong>Pre-requisites:<\/strong><\/p>\n<ul>\n<li>Internet connection<\/li>\n<li>A non-root user with <code>sudo<\/code> access.<\/li>\n<li>Remote MySQL database server address or endpoint.<\/li>\n<\/ul>\n<p><strong>\u00a0<\/strong><\/p>\n<h3>Step 1: Enable WSL on Window 10 ( Linux user skip this)<\/h3>\n<p>Those are using Windows 10 system can install phpMyAdmin on its built-in Linux system safely with just a single command. In case you already have installed WSL 1 or WSL 2 on your system then move to the next step otherwise see this <a href=\"https:\/\/www.how2shout.com\/how-to\/how-to-run-linux-distro-app-as-wsl2-running-on-wsl1.html\" target=\"_blank\" rel=\"noopener noreferrer\">tutorial first on installing WSL.<\/a><\/p>\n<h3>Step 2: \u00a0Install MySQL<\/h3>\n<p>As phpMyAdmin itself needs a database to work, thus we a one for it on the local machine or server where you are planning to use phpMyAdmin. Hence, use the below command:<\/p>\n<p><strong>For Debian, Ubuntu or similar Linux uses an APT package manager<\/strong><\/p>\n<pre>sudo apt install mysql-server<\/pre>\n<p><strong>For CentOS or RedHat systems<\/strong><\/p>\n<pre>yum install mysql<\/pre>\n<p>or<\/p>\n<pre>dnf install mysql<\/pre>\n<h3>Step 3: Install phpMyAdmin locally or on a remote server<\/h3>\n<p>Next, step is to set up this PHP based open-source MySQL database management application. Again its installation is not a cumbersome job.<\/p>\n<p><strong>For Ubuntu servers:<\/strong><\/p>\n<pre>sudo apt install phpMyAdmin<\/pre>\n<p><strong>For CentOS<\/strong><\/p>\n<p>First and EPEL repository and then run <em>yum install phpmyadmin<\/em>.<\/p>\n<h3>Step 4: Edit configuration file<\/h3>\n<p>Now, before logging in to phpMyAdmin, we need to perform some changes. So, simply on your server command line terminal type the below command to edit the configuration file of this DB management system.<\/p>\n<pre>sudo vim \/etc\/phpmyadmin\/config.inc.php<\/pre>\n<p>\u21d2User arrow key and scroll down to the <strong>end<\/strong> of the file.<\/p>\n<p>\u21d2Press the <strong>INSERT<\/strong> key on the keyboard and add the following lines:<\/p>\n<pre>$i++;\r\n$cfg['Servers'][$i]['host']\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = '';\r\n$cfg['Servers'][$i]['port']\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = '';\r\n$cfg['Servers'][$i]['socket']\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = '';\r\n$cfg['Servers'][$i]['connect_type']\u00a0 = 'tcp';\r\n$cfg['Servers'][$i]['extension']\u00a0\u00a0\u00a0\u00a0 = 'mysql';\r\n$cfg['Servers'][$i]['compress']\u00a0\u00a0\u00a0\u00a0\u00a0 = FALSE;\r\n$cfg['Servers'][$i]['auth_type']\u00a0\u00a0\u00a0\u00a0 = 'config';\r\n$cfg['Servers'][$i]['user']\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = '';\r\n$cfg['Servers'][$i]['password']\u00a0\u00a0\u00a0\u00a0\u00a0 = '';<\/pre>\n<p><strong>After that:<\/strong><\/p>\n<p><strong>Host<\/strong>: Inside the two single columns given in front of the host value enter the address of the<strong> remote database<\/strong>. For example, in the below-given image, we used the address of a MySQL database created on Amazon Cloud. In the same way, you just need to provide the address, it could be IP address as well.<\/p>\n<p><strong>Port<\/strong>: The default ports is <strong>3306<\/strong>. If you have changed it then use that instead.<\/p>\n<p>Next, for security reasons leave the username and password of the Mysql database blank and enter the same while logging phpMyadmin. However, if you know that nobody else is going to access your computer and it is secure. Then simply, add the credential of the MySQL database, <strong>user<\/strong>= <em>you-mysql-username<\/em>, and <strong>password<\/strong>= y<em>our-myslqdatabase-password<\/em>.<\/p>\n<p>Now, save and exit the file. For that press <strong>Esc<\/strong> button, type <code>:wq<\/code>\u00a0 and then hit the <strong>Enter<\/strong> key.<\/p>\n<p><a href=\"https:\/\/www.how2shout.com\/linux\/wp-content\/uploads\/2020\/07\/ubuntu2004_bgg5hsFxN5-min.jpg\"><img loading=\"lazy\" loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-953\" title=\"access phpMyadmin for remote databases\" src=\"https:\/\/www.how2shout.com\/linux\/wp-content\/uploads\/2020\/07\/ubuntu2004_bgg5hsFxN5-min.jpg\" alt=\"ubuntu2004 bgg5hsFxN5 min\" width=\"979\" height=\"718\" \/><\/a><\/p>\n<h3>Step 5: Run phpMyAdmin to access a remote database<\/h3>\n<p>Whether you have installed it on the local or some remote cloud\/hosting server, after installing the phpMyAdmin; open the browser and type the server&#8217;s<em> ip-address\/phpmyadmin.\u00a0<\/em><\/p>\n<p><strong>Note<\/strong>: replace the IP-address text with real IP of yours.<\/p>\n<p>Once the interface of this open-source database management tool appears you will see the<strong> login screen<\/strong>. Enter the <strong>username<\/strong> and <strong>password<\/strong> of the remote server, in case you haven&#8217;t added in the phpMyAdmin configuration file above. And then click on the<strong> Server Choice<\/strong> drop-down box to select the <strong>remote server IP address or endpoint link.<\/strong><\/p>\n<p>Finally, click on the <strong>Go<\/strong> button and this will enable you to access the <strong>MySQL<\/strong> database on your locally installed phpMyAdmin.<\/p>\n<p><a href=\"https:\/\/www.how2shout.com\/linux\/wp-content\/uploads\/2020\/07\/chrome_p4e0jtJA0e-min.jpg\"><img loading=\"lazy\" loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-955\" title=\"Run phpMyAdmin to access a remote database\" src=\"https:\/\/www.how2shout.com\/linux\/wp-content\/uploads\/2020\/07\/chrome_p4e0jtJA0e-min.jpg\" alt=\"Run phpMyAdmin to access a remote database\" width=\"1239\" height=\"827\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In most cases, the MySQL server and phpMyAdmin both are installed on the same server so that the management of the database becomes easy. However, do you know? We can even access the remote server in the phpMyAdmin with just a little tweak. If not, then here is the tutorial on that. phpMyAdmin is a [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":955,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_sitemap_exclude":false,"_sitemap_priority":"","_sitemap_frequency":"","_mbp_gutenberg_autopost":false,"footnotes":""},"categories":[4],"tags":[980,28,979,2373,2374,31],"class_list":{"0":"post-951","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-linux","8":"tag-database","9":"tag-linux","10":"tag-mysql","11":"tag-phpmyadmin","12":"tag-remote-database","13":"tag-tutorial"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v22.9 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>How to access remote MySQL database in local phpMyAdmin<\/title>\n<meta name=\"description\" content=\"Steps to acess and manage remteoly installed MySQL database server using local phpMyAdmin tool for creating and deleting database schemas.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/linux.how2shout.com\/how-to-access-remote-mysql-database-in-local-phpmyadmin\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to access remote MySQL database in local phpMyAdmin\" \/>\n<meta property=\"og:description\" content=\"Steps to acess and manage remteoly installed MySQL database server using local phpMyAdmin tool for creating and deleting database schemas.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/linux.how2shout.com\/how-to-access-remote-mysql-database-in-local-phpmyadmin\/\" \/>\n<meta property=\"og:site_name\" content=\"LinuxShout\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/how2shout\" \/>\n<meta property=\"article:published_time\" content=\"2020-07-12T15:33:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-09-20T08:08:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/linux.how2shout.com\/wp-content\/uploads\/2020\/07\/chrome_p4e0jtJA0e-min.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1239\" \/>\n\t<meta property=\"og:image:height\" content=\"827\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Heyan Maurya\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@h2smedia\" \/>\n<meta name=\"twitter:site\" content=\"@h2smedia\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Heyan Maurya\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"TechArticle\",\"@id\":\"https:\\\/\\\/linux.how2shout.com\\\/how-to-access-remote-mysql-database-in-local-phpmyadmin\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/linux.how2shout.com\\\/how-to-access-remote-mysql-database-in-local-phpmyadmin\\\/\"},\"author\":{\"name\":\"Heyan Maurya\",\"@id\":\"https:\\\/\\\/linux.how2shout.com\\\/#\\\/schema\\\/person\\\/102d73e20384ea409022d5bafddc0f72\"},\"headline\":\"How to access remote MySQL database in local phpMyAdmin\",\"datePublished\":\"2020-07-12T15:33:06+00:00\",\"dateModified\":\"2021-09-20T08:08:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/linux.how2shout.com\\\/how-to-access-remote-mysql-database-in-local-phpmyadmin\\\/\"},\"wordCount\":822,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\\\/\\\/linux.how2shout.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/linux.how2shout.com\\\/how-to-access-remote-mysql-database-in-local-phpmyadmin\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/linux.how2shout.com\\\/wp-content\\\/uploads\\\/2020\\\/07\\\/chrome_p4e0jtJA0e-min.jpg\",\"keywords\":[\"database\",\"Linux\",\"mysql\",\"phpmyadmin\",\"remote database\",\"tutorial\"],\"articleSection\":[\"Linux\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/linux.how2shout.com\\\/how-to-access-remote-mysql-database-in-local-phpmyadmin\\\/#respond\"]}],\"copyrightYear\":\"2020\",\"copyrightHolder\":{\"@id\":\"https:\\\/\\\/linux.how2shout.com\\\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/linux.how2shout.com\\\/how-to-access-remote-mysql-database-in-local-phpmyadmin\\\/\",\"url\":\"https:\\\/\\\/linux.how2shout.com\\\/how-to-access-remote-mysql-database-in-local-phpmyadmin\\\/\",\"name\":\"How to access remote MySQL database in local phpMyAdmin\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/linux.how2shout.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/linux.how2shout.com\\\/how-to-access-remote-mysql-database-in-local-phpmyadmin\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/linux.how2shout.com\\\/how-to-access-remote-mysql-database-in-local-phpmyadmin\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/linux.how2shout.com\\\/wp-content\\\/uploads\\\/2020\\\/07\\\/chrome_p4e0jtJA0e-min.jpg\",\"datePublished\":\"2020-07-12T15:33:06+00:00\",\"dateModified\":\"2021-09-20T08:08:26+00:00\",\"description\":\"Steps to acess and manage remteoly installed MySQL database server using local phpMyAdmin tool for creating and deleting database schemas.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/linux.how2shout.com\\\/how-to-access-remote-mysql-database-in-local-phpmyadmin\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/linux.how2shout.com\\\/how-to-access-remote-mysql-database-in-local-phpmyadmin\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/linux.how2shout.com\\\/how-to-access-remote-mysql-database-in-local-phpmyadmin\\\/#primaryimage\",\"url\":\"https:\\\/\\\/linux.how2shout.com\\\/wp-content\\\/uploads\\\/2020\\\/07\\\/chrome_p4e0jtJA0e-min.jpg\",\"contentUrl\":\"https:\\\/\\\/linux.how2shout.com\\\/wp-content\\\/uploads\\\/2020\\\/07\\\/chrome_p4e0jtJA0e-min.jpg\",\"width\":1239,\"height\":827,\"caption\":\"Run phpMyAdmin to access a remote database\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/linux.how2shout.com\\\/how-to-access-remote-mysql-database-in-local-phpmyadmin\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/linux.how2shout.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to access remote MySQL database in local phpMyAdmin\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/linux.how2shout.com\\\/#website\",\"url\":\"https:\\\/\\\/linux.how2shout.com\\\/\",\"name\":\"LinuxShout\",\"description\":\"Find the open source solutions\",\"publisher\":{\"@id\":\"https:\\\/\\\/linux.how2shout.com\\\/#organization\"},\"alternateName\":\"Linux how2shout\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/linux.how2shout.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/linux.how2shout.com\\\/#organization\",\"name\":\"LinuxShout\",\"url\":\"https:\\\/\\\/linux.how2shout.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/linux.how2shout.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/linux.how2shout.com\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/Linux-Shout-Logo.png\",\"contentUrl\":\"https:\\\/\\\/linux.how2shout.com\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/Linux-Shout-Logo.png\",\"width\":503,\"height\":349,\"caption\":\"LinuxShout\"},\"image\":{\"@id\":\"https:\\\/\\\/linux.how2shout.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/how2shout\",\"https:\\\/\\\/x.com\\\/h2smedia\",\"https:\\\/\\\/instagram.com\\\/h2smedia\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/h2smedia\\\/\",\"https:\\\/\\\/www.pinterest.com\\\/how2shout\",\"https:\\\/\\\/youtube.com\\\/h2smedia\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/linux.how2shout.com\\\/#\\\/schema\\\/person\\\/102d73e20384ea409022d5bafddc0f72\",\"name\":\"Heyan Maurya\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b07b375c19891b0589da722cb1e3dff333ec63dd8467afc114611044e87cfe9a?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b07b375c19891b0589da722cb1e3dff333ec63dd8467afc114611044e87cfe9a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b07b375c19891b0589da722cb1e3dff333ec63dd8467afc114611044e87cfe9a?s=96&d=mm&r=g\",\"caption\":\"Heyan Maurya\"},\"description\":\"I have a keen interest in all kinds of technologies, from consumer-tech to enterprise solutions. However, I am still trying to learn Linux and whatever the problems I face, trying to give solutions for the same, here...\",\"sameAs\":[\"https:\\\/\\\/www.how2shout.com\\\/\"],\"url\":\"https:\\\/\\\/linux.how2shout.com\\\/author\\\/heyan\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to access remote MySQL database in local phpMyAdmin","description":"Steps to acess and manage remteoly installed MySQL database server using local phpMyAdmin tool for creating and deleting database schemas.","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:\/\/linux.how2shout.com\/how-to-access-remote-mysql-database-in-local-phpmyadmin\/","og_locale":"en_US","og_type":"article","og_title":"How to access remote MySQL database in local phpMyAdmin","og_description":"Steps to acess and manage remteoly installed MySQL database server using local phpMyAdmin tool for creating and deleting database schemas.","og_url":"https:\/\/linux.how2shout.com\/how-to-access-remote-mysql-database-in-local-phpmyadmin\/","og_site_name":"LinuxShout","article_publisher":"https:\/\/www.facebook.com\/how2shout","article_published_time":"2020-07-12T15:33:06+00:00","article_modified_time":"2021-09-20T08:08:26+00:00","og_image":[{"width":1239,"height":827,"url":"https:\/\/linux.how2shout.com\/wp-content\/uploads\/2020\/07\/chrome_p4e0jtJA0e-min.jpg","type":"image\/jpeg"}],"author":"Heyan Maurya","twitter_card":"summary_large_image","twitter_creator":"@h2smedia","twitter_site":"@h2smedia","twitter_misc":{"Written by":"Heyan Maurya","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"TechArticle","@id":"https:\/\/linux.how2shout.com\/how-to-access-remote-mysql-database-in-local-phpmyadmin\/#article","isPartOf":{"@id":"https:\/\/linux.how2shout.com\/how-to-access-remote-mysql-database-in-local-phpmyadmin\/"},"author":{"name":"Heyan Maurya","@id":"https:\/\/linux.how2shout.com\/#\/schema\/person\/102d73e20384ea409022d5bafddc0f72"},"headline":"How to access remote MySQL database in local phpMyAdmin","datePublished":"2020-07-12T15:33:06+00:00","dateModified":"2021-09-20T08:08:26+00:00","mainEntityOfPage":{"@id":"https:\/\/linux.how2shout.com\/how-to-access-remote-mysql-database-in-local-phpmyadmin\/"},"wordCount":822,"commentCount":2,"publisher":{"@id":"https:\/\/linux.how2shout.com\/#organization"},"image":{"@id":"https:\/\/linux.how2shout.com\/how-to-access-remote-mysql-database-in-local-phpmyadmin\/#primaryimage"},"thumbnailUrl":"https:\/\/linux.how2shout.com\/wp-content\/uploads\/2020\/07\/chrome_p4e0jtJA0e-min.jpg","keywords":["database","Linux","mysql","phpmyadmin","remote database","tutorial"],"articleSection":["Linux"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/linux.how2shout.com\/how-to-access-remote-mysql-database-in-local-phpmyadmin\/#respond"]}],"copyrightYear":"2020","copyrightHolder":{"@id":"https:\/\/linux.how2shout.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/linux.how2shout.com\/how-to-access-remote-mysql-database-in-local-phpmyadmin\/","url":"https:\/\/linux.how2shout.com\/how-to-access-remote-mysql-database-in-local-phpmyadmin\/","name":"How to access remote MySQL database in local phpMyAdmin","isPartOf":{"@id":"https:\/\/linux.how2shout.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/linux.how2shout.com\/how-to-access-remote-mysql-database-in-local-phpmyadmin\/#primaryimage"},"image":{"@id":"https:\/\/linux.how2shout.com\/how-to-access-remote-mysql-database-in-local-phpmyadmin\/#primaryimage"},"thumbnailUrl":"https:\/\/linux.how2shout.com\/wp-content\/uploads\/2020\/07\/chrome_p4e0jtJA0e-min.jpg","datePublished":"2020-07-12T15:33:06+00:00","dateModified":"2021-09-20T08:08:26+00:00","description":"Steps to acess and manage remteoly installed MySQL database server using local phpMyAdmin tool for creating and deleting database schemas.","breadcrumb":{"@id":"https:\/\/linux.how2shout.com\/how-to-access-remote-mysql-database-in-local-phpmyadmin\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/linux.how2shout.com\/how-to-access-remote-mysql-database-in-local-phpmyadmin\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/linux.how2shout.com\/how-to-access-remote-mysql-database-in-local-phpmyadmin\/#primaryimage","url":"https:\/\/linux.how2shout.com\/wp-content\/uploads\/2020\/07\/chrome_p4e0jtJA0e-min.jpg","contentUrl":"https:\/\/linux.how2shout.com\/wp-content\/uploads\/2020\/07\/chrome_p4e0jtJA0e-min.jpg","width":1239,"height":827,"caption":"Run phpMyAdmin to access a remote database"},{"@type":"BreadcrumbList","@id":"https:\/\/linux.how2shout.com\/how-to-access-remote-mysql-database-in-local-phpmyadmin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/linux.how2shout.com\/"},{"@type":"ListItem","position":2,"name":"How to access remote MySQL database in local phpMyAdmin"}]},{"@type":"WebSite","@id":"https:\/\/linux.how2shout.com\/#website","url":"https:\/\/linux.how2shout.com\/","name":"LinuxShout","description":"Find the open source solutions","publisher":{"@id":"https:\/\/linux.how2shout.com\/#organization"},"alternateName":"Linux how2shout","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/linux.how2shout.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/linux.how2shout.com\/#organization","name":"LinuxShout","url":"https:\/\/linux.how2shout.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/linux.how2shout.com\/#\/schema\/logo\/image\/","url":"https:\/\/linux.how2shout.com\/wp-content\/uploads\/2020\/06\/Linux-Shout-Logo.png","contentUrl":"https:\/\/linux.how2shout.com\/wp-content\/uploads\/2020\/06\/Linux-Shout-Logo.png","width":503,"height":349,"caption":"LinuxShout"},"image":{"@id":"https:\/\/linux.how2shout.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/how2shout","https:\/\/x.com\/h2smedia","https:\/\/instagram.com\/h2smedia","https:\/\/www.linkedin.com\/company\/h2smedia\/","https:\/\/www.pinterest.com\/how2shout","https:\/\/youtube.com\/h2smedia"]},{"@type":"Person","@id":"https:\/\/linux.how2shout.com\/#\/schema\/person\/102d73e20384ea409022d5bafddc0f72","name":"Heyan Maurya","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/b07b375c19891b0589da722cb1e3dff333ec63dd8467afc114611044e87cfe9a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/b07b375c19891b0589da722cb1e3dff333ec63dd8467afc114611044e87cfe9a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b07b375c19891b0589da722cb1e3dff333ec63dd8467afc114611044e87cfe9a?s=96&d=mm&r=g","caption":"Heyan Maurya"},"description":"I have a keen interest in all kinds of technologies, from consumer-tech to enterprise solutions. However, I am still trying to learn Linux and whatever the problems I face, trying to give solutions for the same, here...","sameAs":["https:\/\/www.how2shout.com\/"],"url":"https:\/\/linux.how2shout.com\/author\/heyan\/"}]}},"_links":{"self":[{"href":"https:\/\/linux.how2shout.com\/wp-json\/wp\/v2\/posts\/951","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/linux.how2shout.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/linux.how2shout.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/linux.how2shout.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/linux.how2shout.com\/wp-json\/wp\/v2\/comments?post=951"}],"version-history":[{"count":8,"href":"https:\/\/linux.how2shout.com\/wp-json\/wp\/v2\/posts\/951\/revisions"}],"predecessor-version":[{"id":7212,"href":"https:\/\/linux.how2shout.com\/wp-json\/wp\/v2\/posts\/951\/revisions\/7212"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/linux.how2shout.com\/wp-json\/wp\/v2\/media\/955"}],"wp:attachment":[{"href":"https:\/\/linux.how2shout.com\/wp-json\/wp\/v2\/media?parent=951"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/linux.how2shout.com\/wp-json\/wp\/v2\/categories?post=951"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/linux.how2shout.com\/wp-json\/wp\/v2\/tags?post=951"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}