{"id":8745,"date":"2020-07-01T07:47:44","date_gmt":"2020-07-01T11:47:44","guid":{"rendered":"http:\/\/local.brightwhiz\/?p=8745"},"modified":"2021-12-04T08:25:03","modified_gmt":"2021-12-04T08:25:03","slug":"install-latest-phpmyadmin-ubuntu-20-04","status":"publish","type":"post","link":"http:\/\/local.brightwhiz\/install-latest-phpmyadmin-ubuntu-20-04\/","title":{"rendered":"How to Install the Latest phpMyAdmin on Ubuntu 20.04"},"content":{"rendered":"\n<p>This tutorial will guide you in your quest to install the latest phpMyAdmin on your Ubuntu system.<\/p>\n\n\n\n<p>phpMyadmin is probably the best freely available web-based <a href=\"http:\/\/local.brightwhiz\/tag\/mysql\">MySQL<\/a> and <a href=\"http:\/\/local.brightwhiz\/tag\/mariadb\">MariaDB<\/a> administration application. You can download and install on your server running PHP and a server like <a href=\"http:\/\/local.brightwhiz\/tag\/apache\">Apache<\/a>, <a href=\"http:\/\/local.brightwhiz\/tag\/nginx\">Nginx<\/a>, or <a href=\"http:\/\/local.brightwhiz\/tag\/iis\">IIS<\/a> among others.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Prerequisites<\/h2>\n\n\n\n<p>We are assuming you already have installed the MySQL server on your <a href=\"http:\/\/local.brightwhiz\/tag\/ubuntu\">Ubuntu<\/a> system. In this case, we will be using Ubuntu 20.04. We will also assume you have Apache, <a href=\"http:\/\/local.brightwhiz\/tag\/php\">PHP<\/a>, and a non-root user with <em>sudo<\/em> privileges, as well as a firewall configured with <em>ufw<\/em>. <a href=\"http:\/\/local.brightwhiz\/install-apache-mysql-php-ubuntu-20-04-lts\/\">This tutorial about the LAMP stack<\/a> will help you install the necessary prerequisites.<\/p>\n\n\n\n<p>We will also recommend you have an existing domain configured with an SSL\/TLS certificate. This is because phpMyAdmin communicates directly with your MySQL installation, uses MySQL credentials to authenticate as well as create users, databases, and their objects, as well as executes and returns results for SQL queries.<\/p>\n\n\n\n<p>If you have the above in place you are ready to proceed.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Default Step (Optional) \u2014 Installing phpMyAdmin<\/h2>\n\n\n\n<p>PhpMyAdmin can be installed from the default Ubuntu repositories. This will not install the latest available phpMyAdmin version. The steps to install the latest phpMyAdmin will be highlighted later in this tutorial.<\/p>\n\n\n\n<p>The process involves updating your server&#8217;s package index and then using apt install them on your Ubuntu system. Use the following commands:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">$ sudo apt update\n$ sudo apt install phpmyadmin php-mbstring php-gettext<\/code><\/pre>\n\n\n\n<p><em>php-mbstring<\/em> and <em>php-gettext<\/em> extensions will only be installed if they are not already installed.<\/p>\n\n\n\n<p>Follow the prompts in order to configure your installation correctly with the following hints:<\/p>\n\n\n\n<ul><li>For the server selection, choose apache2<\/li><li>Select Yes when asked whether to use <em>dbconfig-common<\/em> to set up the database<\/li><li>Choose and confirm a MySQL application password for phpMyAdmin.<\/li><\/ul>\n\n\n\n<p>The phpMyAdmin Apache configuration file will be added to the <em>\/etc\/apache2\/conf-enabled\/<\/em> directory.<\/p>\n\n\n\n<p>You may need to explicitly enable the <strong>mbstring<\/strong> PHP extension if it has not been previously enabled. This can be done by running the following command:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">$ sudo phpenmod mbstring<\/code><\/pre>\n\n\n\n<p>Restart Apache for your changes to be saved:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">$ sudo systemctl restart apache2<\/code><\/pre>\n\n\n\n<p>phpMyAdmin is now installed and configured. Be sure to make sure MySQL users have the privileges required.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Step 1: Install the Latest phpMyAdmin on Ubuntu 20.04<\/h2>\n\n\n\n<p>let&#8217;s take a diversion to install the latest phpMyAdmin on your Ubuntu system seeing the above procedure does not give us the latest version.<\/p>\n\n\n\n<p>Download the latest <a href=\"http:\/\/local.brightwhiz\/tag\/phpmyadmin\">phpMyAdmin<\/a> archive from the official download page <a aria-label=\"undefined (opens in a new tab)\" href=\"https:\/\/www.phpmyadmin.net\/downloads\/\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a>. Also, visit the page to determine the latest version which is currently phpMyAdmin 5.0.2 at the initial publishing of this tutorial.<\/p>\n\n\n\n<p>Use the following commands to download phpMyAdmin 5.0.2 onto your system.<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">$ wget https:\/\/files.phpmyadmin.net\/phpMyAdmin\/5.0.2\/phpMyAdmin-5.0.2-all-languages.zip\n$ unzip phpMyAdmin-5.0.2-all-languages.zip\n$ mv phpMyAdmin-5.0.2-all-languages \/usr\/share\/phpmyadmin<\/code><\/pre>\n\n\n\n<p>If <strong>wget<\/strong> or <strong>unzip<\/strong> are missing you can install them using the <em>apt<\/em> install command.<\/p>\n\n\n\n<p>Next, create a tmp directory and set the proper permissions.<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">$ mkdir \/usr\/share\/phpmyadmin\/tmp\n$ chown -R www-data:www-data \/usr\/share\/phpmyadmin\n$ chmod 777 \/usr\/share\/phpmyadmin\/tmp<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Step 2: Configure phpMyAdmin<\/h2>\n\n\n\n<p>Next, you need to configure webserver to serve phpMyAdmin over the network by creating an Apache configuration file for phpMyAdmin:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">$ sudo nano \/etc\/apache\/conf-available\/phpmyadmin.conf<\/code><\/pre>\n\n\n\n<p>Add the content below to the configuration file you have just created.<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-apacheconf\">Alias \/phpmyadmin \/usr\/share\/phpmyadmin\nAlias \/phpMyAdmin \/usr\/share\/phpmyadmin\n \n&lt;Directory \/usr\/share\/phpmyadmin\/&gt;\n   AddDefaultCharset UTF-8\n   &lt;IfModule mod_authz_core.c&gt;\n      &lt;RequireAny&gt;\n      Require all granted\n     &lt;\/RequireAny&gt;\n   &lt;\/IfModule&gt;\n&lt;\/Directory&gt;\n \n&lt;Directory \/usr\/share\/phpmyadmin\/setup\/&gt;\n   &lt;IfModule mod_authz_core.c&gt;\n     &lt;RequireAny&gt;\n       Require all granted\n     &lt;\/RequireAny&gt;\n   &lt;\/IfModule&gt;\n&lt;\/Directory&gt;<\/code><\/pre>\n\n\n\n<p>Save and close the file, enable the configuration, and restart apache to pick up the new changes using the following commands:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">$ sudo a2enconf PHPMyAdmin\n$ sudo systemctl restart apache2<\/code><\/pre>\n\n\n\n<p>You now have the latest phpMyAdmin on your Ubuntu system which can be accessed through the server IP address or domain name.<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-\">http:\/\/example.com\/phpmyadmin<\/code><\/pre>\n\n\n\n<p>From this point onwards, whether you used the default Ubuntu 20.04 phpMyAdmin or you opted to go for the latest version, everything is pretty much the same from here on.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"403\" height=\"437\" src=\"https:\/\/i2.wp.com\/brightwhiz.com\/wp-content\/uploads\/2020\/07\/phpMyAdmin-login.jpg?fit=373%2C405&amp;ssl=1\" alt=\"\" class=\"wp-image-8750\" srcset=\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2020\/07\/phpMyAdmin-login.jpg 403w, http:\/\/local.brightwhiz\/wp-content\/uploads\/2020\/07\/phpMyAdmin-login-251x272.jpg 251w, http:\/\/local.brightwhiz\/wp-content\/uploads\/2020\/07\/phpMyAdmin-login-352x382.jpg 352w, http:\/\/local.brightwhiz\/wp-content\/uploads\/2020\/07\/phpMyAdmin-login-157x170.jpg 157w\" sizes=\"(max-width: 403px) 100vw, 403px\" \/><\/figure><\/div>\n\n\n\n<p>Sign in with the username and password that you used to access MySQL on the command line. If the user has no privileges then they may have to be set from the MySQL privileged admin user you have. It is important to disable the root user from non-local sources for security reasons seeing phpMyAdmin is generally available off the Internet.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"760\" height=\"410\" src=\"https:\/\/i1.wp.com\/brightwhiz.com\/wp-content\/uploads\/2020\/07\/phpmyadmin-dashboard.jpg?fit=751%2C405&amp;ssl=1\" alt=\"\" class=\"wp-image-8751\" srcset=\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2020\/07\/phpmyadmin-dashboard.jpg 760w, http:\/\/local.brightwhiz\/wp-content\/uploads\/2020\/07\/phpmyadmin-dashboard-504x272.jpg 504w, http:\/\/local.brightwhiz\/wp-content\/uploads\/2020\/07\/phpmyadmin-dashboard-708x382.jpg 708w, http:\/\/local.brightwhiz\/wp-content\/uploads\/2020\/07\/phpmyadmin-dashboard-315x170.jpg 315w\" sizes=\"(max-width: 760px) 100vw, 760px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Step 3: Secure Your phpMyAdmin Instance<\/h2>\n\n\n\n<p>PhpMyAdmin is a popular target for attackers, and you should take extra care to prevent unauthorized access. We are going to do this by adding a gateway in front of the entire application by using Apache\u2019s built-in .htaccess authentication and authorization functionalities.<\/p>\n\n\n\n<p>Enable the use of <em>.htaccess<\/em> file overrides by editing your Apache configuration file with this command.<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">$ sudo nano \/etc\/apache2\/conf-available\/phpmyadmin.conf<\/code><\/pre>\n\n\n\n<p>Add an <em>AllowOverride All<\/em> directive within the Directory <em>\/usr\/share\/phpmyadmin<\/em> section of the configuration file, like this:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-\">&lt;Directory \/usr\/share\/phpmyadmin&gt;\n    Options FollowSymLinks\n    DirectoryIndex index.php\n    AllowOverride All\n    . . .\n&lt;\/Directory&gt;<\/code><\/pre>\n\n\n\n<p>Save and close the file.<\/p>\n\n\n\n<p>Restart Apache to implement the changes.<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">$ sudo systemctl restart apache2<\/code><\/pre>\n\n\n\n<p>Create a password file outside of the directories that are being served directory using the <strong>htpasswd<\/strong> utility:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">$ sudo htpasswd -c \/etc\/phpmyadmin\/.htpasswd username<\/code><\/pre>\n\n\n\n<p>You will be prompted to select and confirm a password for the user you are creating.<\/p>\n\n\n\n<p>You can create additional users using the command below. Notice that the <em>-c<\/em> flag is not used when adding users.<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">$ sudo htpasswd \/etc\/phpmyadmin\/.htpasswd anotheruser<\/code><\/pre>\n\n\n\n<p>Now let&#8217;s create the <em>.htaccess<\/em> file in your phpMyAdmin root folder<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-bash\">$ sudo nano \/usr\/share\/phpmyadmin\/.htaccess<\/code><\/pre>\n\n\n\n<p>Type in the following rules into the file:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-apacheconf\">AuthType Basic\nAuthName &quot;Restricted area&quot;\nAuthUserFile \/etc\/phpmyadmin\/.htpasswd\nRequire valid-user<\/code><\/pre>\n\n\n\n<p>Save and close the file.<\/p>\n\n\n\n<p>These are the options you have for securing the folder:<\/p>\n\n\n\n<ul><li><strong>AuthType Basic:<\/strong> This line specifies the authentication type that you are implementing. This type will implement password authentication using a password file.<\/li><li><strong>AuthName:<\/strong> This is the message for the authentication dialog box. You should keep this generic so that unauthorized users don&#8217;t gain any information about what is being protected.<\/li><li><strong>AuthUserFile:<\/strong> This sets the location of the password file that will be used for authentication. This should be outside of the directories that are being served.<\/li><li><strong>Require valid-user:<\/strong> This specifies that only authenticated users should be given access to this resource.<\/li><\/ul>\n\n\n\n<p>This setup adds an additional layer of security with a popup dialog that requires a username and password to access files within the folder.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p>You now have downloaded, install the latest phpMyAdmin, and configured it on your Ubuntu 20.04 server. You can create databases, users, tables, and other database objects as well as perform the usual operations like selecting, deleting, and modifying structures and data.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This tutorial will guide you in your quest to install the latest phpMyAdmin on your Ubuntu system. phpMyadmin is probably the best freely available web-based MySQL and MariaDB administration application&#8230;.<\/p>\n","protected":false},"author":1,"featured_media":8746,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23,9,28,16,18,20],"tags":[58,164,180,308,313,320,354,365,393,400,424,433,449,452,454,526,531,543,591,598,635],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Install the Latest phpMyAdmin Version on Ubuntu 20.04<\/title>\n<meta name=\"description\" content=\"In this tutorial, we will be showing you how to install the latest phpMyAdmin on your Ubuntu 20.04 system as well as configure and secure it.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/local.brightwhiz\/install-latest-phpmyadmin-ubuntu-20-04\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Install the Latest phpMyAdmin Version on Ubuntu 20.04\" \/>\n<meta property=\"og:description\" content=\"In this tutorial, we will be showing you how to install the latest phpMyAdmin on your Ubuntu 20.04 system as well as configure and secure it.\" \/>\n<meta property=\"og:url\" content=\"http:\/\/local.brightwhiz\/install-latest-phpmyadmin-ubuntu-20-04\/\" \/>\n<meta property=\"og:site_name\" content=\"Brightwhiz.com\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/brightwhiz\/\" \/>\n<meta property=\"article:published_time\" content=\"2020-07-01T11:47:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-04T08:25:03+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2020\/07\/install-latest-phpmyadmin.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Michael Bright\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@brightwhizmag\" \/>\n<meta name=\"twitter:site\" content=\"@brightwhizmag\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Michael Bright\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\/\/local.brightwhiz\/install-latest-phpmyadmin-ubuntu-20-04\/#article\",\"isPartOf\":{\"@id\":\"http:\/\/local.brightwhiz\/install-latest-phpmyadmin-ubuntu-20-04\/\"},\"author\":{\"name\":\"Michael Bright\",\"@id\":\"http:\/\/local.brightwhiz\/#\/schema\/person\/81f0f3126f13834ae2e7f381b3028e32\"},\"headline\":\"How to Install the Latest phpMyAdmin on Ubuntu 20.04\",\"datePublished\":\"2020-07-01T11:47:44+00:00\",\"dateModified\":\"2021-12-04T08:25:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\/\/local.brightwhiz\/install-latest-phpmyadmin-ubuntu-20-04\/\"},\"wordCount\":962,\"publisher\":{\"@id\":\"http:\/\/local.brightwhiz\/#organization\"},\"image\":{\"@id\":\"http:\/\/local.brightwhiz\/install-latest-phpmyadmin-ubuntu-20-04\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2020\/07\/install-latest-phpmyadmin.jpg\",\"keywords\":[\"Apache\",\"Cross Platform\",\"Database\",\"IIS\",\"InfoSec\",\"Internet\",\"Linux\",\"MariaDB\",\"MySQL\",\"Nginx\",\"Open Source\",\"Optimization\",\"Performance\",\"PHP\",\"phpMyAdmin\",\"Security\",\"Server\",\"Software Design\",\"Tools\",\"Ubuntu\",\"Web\"],\"articleSection\":[\"Guides\",\"How To\",\"Software\",\"Technology\",\"Tools\",\"Tutorials\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/local.brightwhiz\/install-latest-phpmyadmin-ubuntu-20-04\/\",\"url\":\"http:\/\/local.brightwhiz\/install-latest-phpmyadmin-ubuntu-20-04\/\",\"name\":\"How to Install the Latest phpMyAdmin Version on Ubuntu 20.04\",\"isPartOf\":{\"@id\":\"http:\/\/local.brightwhiz\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\/\/local.brightwhiz\/install-latest-phpmyadmin-ubuntu-20-04\/#primaryimage\"},\"image\":{\"@id\":\"http:\/\/local.brightwhiz\/install-latest-phpmyadmin-ubuntu-20-04\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2020\/07\/install-latest-phpmyadmin.jpg\",\"datePublished\":\"2020-07-01T11:47:44+00:00\",\"dateModified\":\"2021-12-04T08:25:03+00:00\",\"description\":\"In this tutorial, we will be showing you how to install the latest phpMyAdmin on your Ubuntu 20.04 system as well as configure and secure it.\",\"breadcrumb\":{\"@id\":\"http:\/\/local.brightwhiz\/install-latest-phpmyadmin-ubuntu-20-04\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/local.brightwhiz\/install-latest-phpmyadmin-ubuntu-20-04\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/local.brightwhiz\/install-latest-phpmyadmin-ubuntu-20-04\/#primaryimage\",\"url\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2020\/07\/install-latest-phpmyadmin.jpg\",\"contentUrl\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2020\/07\/install-latest-phpmyadmin.jpg\",\"width\":1200,\"height\":630,\"caption\":\"Install the Latest phpMyAdmin\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/local.brightwhiz\/install-latest-phpmyadmin-ubuntu-20-04\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\/\/local.brightwhiz\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Install the Latest phpMyAdmin on Ubuntu 20.04\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/local.brightwhiz\/#website\",\"url\":\"http:\/\/local.brightwhiz\/\",\"name\":\"Brightwhiz.com\",\"description\":\"Best Tech guides, Tutorials, and News\",\"publisher\":{\"@id\":\"http:\/\/local.brightwhiz\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/local.brightwhiz\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"http:\/\/local.brightwhiz\/#organization\",\"name\":\"Brightwhiz\",\"url\":\"http:\/\/local.brightwhiz\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/local.brightwhiz\/#\/schema\/logo\/image\/\",\"url\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2021\/11\/brightwhiz-com-logo-orange.png\",\"contentUrl\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2021\/11\/brightwhiz-com-logo-orange.png\",\"width\":706,\"height\":135,\"caption\":\"Brightwhiz\"},\"image\":{\"@id\":\"http:\/\/local.brightwhiz\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/brightwhiz\/\",\"https:\/\/twitter.com\/brightwhizmag\",\"https:\/\/instagram.com\/bright_whiz\/\",\"https:\/\/www.pinterest.com\/sobbayi\/\",\"https:\/\/www.youtube.com\/channel\/UC6sCdP_d_RiTIM7ErFT-PSQ\"]},{\"@type\":\"Person\",\"@id\":\"http:\/\/local.brightwhiz\/#\/schema\/person\/81f0f3126f13834ae2e7f381b3028e32\",\"name\":\"Michael Bright\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/local.brightwhiz\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/1.gravatar.com\/avatar\/da90485875ff0aafa38fdd494abe87d1?s=96&d=mm&r=g\",\"contentUrl\":\"http:\/\/1.gravatar.com\/avatar\/da90485875ff0aafa38fdd494abe87d1?s=96&d=mm&r=g\",\"caption\":\"Michael Bright\"},\"sameAs\":[\"https:\/\/sobbayi.com\"],\"url\":\"http:\/\/local.brightwhiz\/author\/sobbayiadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Install the Latest phpMyAdmin Version on Ubuntu 20.04","description":"In this tutorial, we will be showing you how to install the latest phpMyAdmin on your Ubuntu 20.04 system as well as configure and secure it.","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":"http:\/\/local.brightwhiz\/install-latest-phpmyadmin-ubuntu-20-04\/","og_locale":"en_US","og_type":"article","og_title":"How to Install the Latest phpMyAdmin Version on Ubuntu 20.04","og_description":"In this tutorial, we will be showing you how to install the latest phpMyAdmin on your Ubuntu 20.04 system as well as configure and secure it.","og_url":"http:\/\/local.brightwhiz\/install-latest-phpmyadmin-ubuntu-20-04\/","og_site_name":"Brightwhiz.com","article_publisher":"https:\/\/www.facebook.com\/brightwhiz\/","article_published_time":"2020-07-01T11:47:44+00:00","article_modified_time":"2021-12-04T08:25:03+00:00","og_image":[{"width":1200,"height":630,"url":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2020\/07\/install-latest-phpmyadmin.jpg","type":"image\/jpeg"}],"author":"Michael Bright","twitter_card":"summary_large_image","twitter_creator":"@brightwhizmag","twitter_site":"@brightwhizmag","twitter_misc":{"Written by":"Michael Bright","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/local.brightwhiz\/install-latest-phpmyadmin-ubuntu-20-04\/#article","isPartOf":{"@id":"http:\/\/local.brightwhiz\/install-latest-phpmyadmin-ubuntu-20-04\/"},"author":{"name":"Michael Bright","@id":"http:\/\/local.brightwhiz\/#\/schema\/person\/81f0f3126f13834ae2e7f381b3028e32"},"headline":"How to Install the Latest phpMyAdmin on Ubuntu 20.04","datePublished":"2020-07-01T11:47:44+00:00","dateModified":"2021-12-04T08:25:03+00:00","mainEntityOfPage":{"@id":"http:\/\/local.brightwhiz\/install-latest-phpmyadmin-ubuntu-20-04\/"},"wordCount":962,"publisher":{"@id":"http:\/\/local.brightwhiz\/#organization"},"image":{"@id":"http:\/\/local.brightwhiz\/install-latest-phpmyadmin-ubuntu-20-04\/#primaryimage"},"thumbnailUrl":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2020\/07\/install-latest-phpmyadmin.jpg","keywords":["Apache","Cross Platform","Database","IIS","InfoSec","Internet","Linux","MariaDB","MySQL","Nginx","Open Source","Optimization","Performance","PHP","phpMyAdmin","Security","Server","Software Design","Tools","Ubuntu","Web"],"articleSection":["Guides","How To","Software","Technology","Tools","Tutorials"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"http:\/\/local.brightwhiz\/install-latest-phpmyadmin-ubuntu-20-04\/","url":"http:\/\/local.brightwhiz\/install-latest-phpmyadmin-ubuntu-20-04\/","name":"How to Install the Latest phpMyAdmin Version on Ubuntu 20.04","isPartOf":{"@id":"http:\/\/local.brightwhiz\/#website"},"primaryImageOfPage":{"@id":"http:\/\/local.brightwhiz\/install-latest-phpmyadmin-ubuntu-20-04\/#primaryimage"},"image":{"@id":"http:\/\/local.brightwhiz\/install-latest-phpmyadmin-ubuntu-20-04\/#primaryimage"},"thumbnailUrl":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2020\/07\/install-latest-phpmyadmin.jpg","datePublished":"2020-07-01T11:47:44+00:00","dateModified":"2021-12-04T08:25:03+00:00","description":"In this tutorial, we will be showing you how to install the latest phpMyAdmin on your Ubuntu 20.04 system as well as configure and secure it.","breadcrumb":{"@id":"http:\/\/local.brightwhiz\/install-latest-phpmyadmin-ubuntu-20-04\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/local.brightwhiz\/install-latest-phpmyadmin-ubuntu-20-04\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/local.brightwhiz\/install-latest-phpmyadmin-ubuntu-20-04\/#primaryimage","url":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2020\/07\/install-latest-phpmyadmin.jpg","contentUrl":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2020\/07\/install-latest-phpmyadmin.jpg","width":1200,"height":630,"caption":"Install the Latest phpMyAdmin"},{"@type":"BreadcrumbList","@id":"http:\/\/local.brightwhiz\/install-latest-phpmyadmin-ubuntu-20-04\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/local.brightwhiz\/"},{"@type":"ListItem","position":2,"name":"How to Install the Latest phpMyAdmin on Ubuntu 20.04"}]},{"@type":"WebSite","@id":"http:\/\/local.brightwhiz\/#website","url":"http:\/\/local.brightwhiz\/","name":"Brightwhiz.com","description":"Best Tech guides, Tutorials, and News","publisher":{"@id":"http:\/\/local.brightwhiz\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/local.brightwhiz\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"http:\/\/local.brightwhiz\/#organization","name":"Brightwhiz","url":"http:\/\/local.brightwhiz\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/local.brightwhiz\/#\/schema\/logo\/image\/","url":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2021\/11\/brightwhiz-com-logo-orange.png","contentUrl":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2021\/11\/brightwhiz-com-logo-orange.png","width":706,"height":135,"caption":"Brightwhiz"},"image":{"@id":"http:\/\/local.brightwhiz\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/brightwhiz\/","https:\/\/twitter.com\/brightwhizmag","https:\/\/instagram.com\/bright_whiz\/","https:\/\/www.pinterest.com\/sobbayi\/","https:\/\/www.youtube.com\/channel\/UC6sCdP_d_RiTIM7ErFT-PSQ"]},{"@type":"Person","@id":"http:\/\/local.brightwhiz\/#\/schema\/person\/81f0f3126f13834ae2e7f381b3028e32","name":"Michael Bright","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/local.brightwhiz\/#\/schema\/person\/image\/","url":"http:\/\/1.gravatar.com\/avatar\/da90485875ff0aafa38fdd494abe87d1?s=96&d=mm&r=g","contentUrl":"http:\/\/1.gravatar.com\/avatar\/da90485875ff0aafa38fdd494abe87d1?s=96&d=mm&r=g","caption":"Michael Bright"},"sameAs":["https:\/\/sobbayi.com"],"url":"http:\/\/local.brightwhiz\/author\/sobbayiadmin\/"}]}},"_links":{"self":[{"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/posts\/8745"}],"collection":[{"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/comments?post=8745"}],"version-history":[{"count":0,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/posts\/8745\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/media\/8746"}],"wp:attachment":[{"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/media?parent=8745"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/categories?post=8745"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/tags?post=8745"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}