{"id":29866,"date":"2019-03-15T13:41:42","date_gmt":"2019-03-15T18:41:42","guid":{"rendered":"https:\/\/www.rosehosting.com\/blog\/?p=29866"},"modified":"2022-12-12T08:19:36","modified_gmt":"2022-12-12T14:19:36","slug":"how-to-install-phpmyadmin-on-ubuntu-18-04","status":"publish","type":"post","link":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phpmyadmin-on-ubuntu-18-04\/","title":{"rendered":"How to Install phpMyAdmin on Ubuntu 18.04"},"content":{"rendered":"<div id=\"bsf_rt_marker\"><\/div><p><img decoding=\"async\" class=\"alignnone wp-image-29918 size-full\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/02\/install-phpmyadmin-ubuntu18.jpg\" alt=\"Install phpMyAdmin on Ubuntu\" width=\"742\" height=\"372\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/02\/install-phpmyadmin-ubuntu18.jpg 742w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/02\/install-phpmyadmin-ubuntu18-150x75.jpg 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/02\/install-phpmyadmin-ubuntu18-300x150.jpg 300w\" sizes=\"(max-width: 742px) 100vw, 742px\" \/><\/p>\n<p>phpMyAdmin is one of the most popular and widely-used web-based database management tools on the market. It is a free and open-source PHP application that allows users to manage single or multiple SQL database servers, both locally or on a remote server using a web browser with easy to use graphical user interface. It can be used to handle the administration of MySQL as well as MariaDB databases. You can create, modify, and delete databases or tables, execute SQL queries, manage your MySQL user accounts and privileges, and much more, all from your web browser. Today, we are going to show you how to install <a href=\"https:\/\/www.rosehosting.com\/phpmyadmin-hosting.html\" target=\"_blank\" rel=\"noopener noreferrer\">phpMyAdmin<\/a> on Ubuntu 18.04.<\/p>\n<p>We have an updated version of this tutorial &#8211; <a href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phpmyadmin-on-ubuntu-20-04\/\">How to Install phpMyAdmin on Ubuntu 20.04<\/a><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_65 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-662d4ef88a180\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"ez-toc-cssicon\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-662d4ef88a180\"  aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phpmyadmin-on-ubuntu-18-04\/#Requirements\" title=\"Requirements:\">Requirements:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phpmyadmin-on-ubuntu-18-04\/#Step-1-Connect-to-Your-Server\" title=\"Step 1: Connect to Your Server\">Step 1: Connect to Your Server<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phpmyadmin-on-ubuntu-18-04\/#Step-2-Install-phpMyAdmin\" title=\"Step 2: Install phpMyAdmin\">Step 2: Install phpMyAdmin<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phpmyadmin-on-ubuntu-18-04\/#Step-3-phpMyAdmin-Login\" title=\"Step 3: phpMyAdmin Login\">Step 3: phpMyAdmin Login<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phpmyadmin-on-ubuntu-18-04\/#Step-4-Conclusion\" title=\"Step 4: Conclusion\">Step 4: Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Requirements\"><\/span><!--more-->Requirements:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li>For the purposes of this tutorial, we will be using an <a href=\"https:\/\/www.rosehosting.com\/ubuntu-hosting.html\" target=\"_blank\" rel=\"noopener noreferrer\">Ubuntu 18.04 VPS<\/a>.<\/li>\n<li>You will also need a working LAMP or LEMP (Linux, Apache\/Nginx, MySQL, PHP) stack. Our Ubuntu 18.04 VPS already comes pre-installed with a fully-configured <a href=\"https:\/\/www.rosehosting.com\/lamp-hosting.html\" target=\"_blank\" rel=\"noopener noreferrer\">LAMP<\/a> stack.<\/li>\n<li>Full SSH root access or a user with sudo privileges is also required.<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Step-1-Connect-to-Your-Server\"><\/span>Step 1: Connect to Your Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Before we begin,\u00a0 you need to connect to your server via SSH as the root user or any other user with sudo privileges.<\/p>\n<p>To connect to your server as the root user, use the following command:<\/p>\n<pre>ssh root@<span style=\"color: #ff0000;\">IP_ADDRESS<\/span> -p <span style=\"color: #ff0000;\">PORT_NUMBER<\/span><\/pre>\n<p>Make sure to replace\u00a0<span style=\"color: #ff0000;\">IP_ADDRESS<\/span>\u00a0and\u00a0<span style=\"color: #ff0000;\">PORT_NUMBER<\/span>\u00a0with your actual server IP address and SSH port number.<\/p>\n<p>Once logged in, make sure that your server is up-to-date by running the following commands:<\/p>\n<pre>sudo apt update\r\nsudo apt upgrade<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"Step-2-Install-phpMyAdmin\"><\/span>Step 2: Install phpMyAdmin<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>phpMyAdmin is already available in the default Ubuntu package repositories.<\/p>\n<p>To install phpMyAdmin, along will all of the required dependencies, run the following command:<\/p>\n<pre>sudo apt install phpmyadmin<\/pre>\n<p>During the installation, you will be asked a couple of questions.<\/p>\n<p>Choose <code>apache2<\/code> as your web server:<\/p>\n<p><img decoding=\"async\" class=\"size-full wp-image-29883 aligncenter\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/02\/phpmyadmin_01.png\" alt=\"\" width=\"755\" height=\"220\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/02\/phpmyadmin_01.png 755w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/02\/phpmyadmin_01-150x44.png 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/02\/phpmyadmin_01-300x87.png 300w\" sizes=\"(max-width: 755px) 100vw, 755px\" \/><\/p>\n<p>Choose <code>&lt;Yes&gt;<\/code> to configure a database for phpMyAdmin with <code>dbconfig-common:<\/code><\/p>\n<p><img decoding=\"async\" class=\"size-full wp-image-29884 aligncenter\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/02\/phpmyadmin_02.png\" alt=\"\" width=\"1878\" height=\"250\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/02\/phpmyadmin_02.png 1878w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/02\/phpmyadmin_02-150x20.png 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/02\/phpmyadmin_02-300x40.png 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/02\/phpmyadmin_02-768x102.png 768w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/02\/phpmyadmin_02-1024x136.png 1024w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/02\/phpmyadmin_02-1080x144.png 1080w\" sizes=\"(max-width: 1878px) 100vw, 1878px\" \/><\/p>\n<p>Enter and confirm a MySQL application password for phpMyAdmin:<\/p>\n<p><img decoding=\"async\" class=\"size-full wp-image-29885 aligncenter\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/02\/phpmyadmin_03.png\" alt=\"\" width=\"626\" height=\"206\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/02\/phpmyadmin_03.png 626w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/02\/phpmyadmin_03-150x49.png 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/02\/phpmyadmin_03-300x99.png 300w\" sizes=\"(max-width: 626px) 100vw, 626px\" \/><\/p>\n<p>With this last step, the phpMyAdmin installation has been completed.<\/p>\n<p>To\u00a0access your phpMyAdmin, first restart your apache2 web server with:<\/p>\n<pre>systemctl\u00a0restart apache2<\/pre>\n<p>and type\u00a0<code><span style=\"color: #ff0000;\">http:\/\/yourIPaddress\/phpmyadmin<\/span><\/code> in your browser to access the login page:<\/p>\n<p><img decoding=\"async\" class=\"size-full wp-image-29886 aligncenter\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/02\/phpmyadmin_04.png\" alt=\"\" width=\"406\" height=\"516\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/02\/phpmyadmin_04.png 406w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/02\/phpmyadmin_04-118x150.png 118w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/02\/phpmyadmin_04-236x300.png 236w\" sizes=\"(max-width: 406px) 100vw, 406px\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Step-3-phpMyAdmin-Login\"><\/span>Step 3: phpMyAdmin Login<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To manage your databases using phpMyAdmin, you will need to either log in as the MySQL\u00a0root user\u00a0or as another MySQL user account with administrative privileges. We will show you how to log in using both of these methods.<\/p>\n<h3>Log in as root<\/h3>\n<p>By default, the root user is set to use\u00a0the\u00a0<strong>auth_socket<\/strong> plugin in order to authenticate to your MySQL database server. If you want to be able to authenticate as the root user in your phpMyAdmin, you will have to change the authentication method from\u00a0<strong>auth_socket\u00a0<\/strong>to\u00a0<strong>mysql_native_password.<\/strong><\/p>\n<p>To do this, connect to your server via SSH, and then log in to your MySQL database server by typing the following command:<\/p>\n<pre>sudo mysql<\/pre>\n<p>This will take you to the MySQL shell as the MySQL root user. To check the authentication method of all of your users, you can execute the following:<\/p>\n<pre class=\"command\">SELECT user,plugin FROM mysql.user;<\/pre>\n<p>You will get the following output on your screen:<\/p>\n<pre>+------------------+-----------------------+\r\n| user             | plugin                |\r\n+------------------+-----------------------+\r\n| root             | auth_socket           |\r\n| mysql.session    | mysql_native_password |\r\n| mysql.sys        | mysql_native_password |\r\n| debian-sys-maint | mysql_native_password |\r\n| phpmyadmin       | mysql_native_password |\r\n+------------------+-----------------------+<\/pre>\n<p>In order to change the authentication plugin from\u00a0<strong>auth_socket\u00a0<\/strong>to\u00a0<strong>mysql_native_password\u00a0<\/strong>for your root user, you will need to run the following:<\/p>\n<pre>ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '<span class=\"highlight\" style=\"color: #ff0000;\">STRONG_PASSWORD<\/span>';<\/pre>\n<p>Make sure that you replace the\u00a0<span class=\"highlight\" style=\"color: #ff0000;\">STRONG_PASSWORD\u00a0<\/span>part with an actual strong password that you would like to use for your MySQL root user.<\/p>\n<p>After this is done, you will need to flush all privileges in order for the changes to take effect:<\/p>\n<pre>FLUSH PRIVILEGES;<\/pre>\n<p>You can then run the same command again to check if the authentication method has been successfully updated:<\/p>\n<pre>SELECT user,plugin FROM mysql.user;<\/pre>\n<p>Output:<\/p>\n<pre>+------------------+-----------------------+\r\n| user             | plugin                |\r\n+------------------+-----------------------+\r\n| root             | mysql_native_password |\r\n| mysql.session    | mysql_native_password |\r\n| mysql.sys        | mysql_native_password |\r\n| debian-sys-maint | mysql_native_password |\r\n| phpmyadmin       | mysql_native_password |\r\n+------------------+-----------------------+<\/pre>\n<p>To disconnect from the MySQL database server, you can type:<\/p>\n<pre>exit;<\/pre>\n<p>You can now use your MySQL user to log in to your phpMyAdmin and manage your databases.<\/p>\n<h3>Create a new admin user<\/h3>\n<p>Another option is to create a new MySQL user with administrative privileges. We will show you how to create a new user called &#8220;admin&#8221; which you can use to log in to your phpMyAdmin.<\/p>\n<p>To create this new user, once again log in to your MySQL database server with:<\/p>\n<pre>sudo mysql<\/pre>\n<p>And run the following command:<\/p>\n<pre>CREATE USER 'admin'@'localhost' IDENTIFIED BY '<span class=\"highlight\" style=\"color: #ff0000;\">STRONG_PASSWORD<\/span>';<\/pre>\n<p>Again, make sure you set a strong password for your user. Next, set the appropriate privileges by running:<\/p>\n<pre>GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' WITH GRANT OPTION;<\/pre>\n<p>To exit the MySQL database server, type:<\/p>\n<pre>exit;<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"Step-4-Conclusion\"><\/span>Step 4: Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Congratulations! If you have made it to this step, you have successfully installed phpMyAdmin on your Ubuntu 18.04 VPS. You will be able to log in\u00a0at <code><span style=\"color: #ff0000;\">http:\/\/yourIPaddress\/phpmyadmin<\/span><\/code> as the root user or as another administration\u00a0user, depending on which of the two methods you decided to set up during the tutorial. Upon successful authentication, you will be taken to the main phpMyAdmin management page, as shown in the screenshot below, from which you can start working with your databases.<\/p>\n<p><img decoding=\"async\" class=\"size-full wp-image-29892 aligncenter\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/02\/phpmyadmin_05.png\" alt=\"\" width=\"1125\" height=\"704\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/02\/phpmyadmin_05.png 1125w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/02\/phpmyadmin_05-150x94.png 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/02\/phpmyadmin_05-300x188.png 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/02\/phpmyadmin_05-768x481.png 768w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/02\/phpmyadmin_05-1024x641.png 1024w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/02\/phpmyadmin_05-400x250.png 400w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/02\/phpmyadmin_05-1080x676.png 1080w\" sizes=\"(max-width: 1125px) 100vw, 1125px\" \/><\/p>\n<hr \/>\n<p>Of course, if you are one of our\u00a0<a href=\"https:\/\/www.rosehosting.com\/ubuntu-hosting.html\" target=\"_blank\" rel=\"noopener noreferrer\">Ubuntu Hosting<\/a> customers, you don\u2019t have to install phpMyAdmin on your Ubuntu 18.04 VPS \u2013 simply ask our admins, sit back, and relax. Our admins will install phpMyAdmin on Ubuntu 18.04 for you immediately. You can also check this guide: <a href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phpmyadmin-on-ubuntu-20-04\/\">How to Install phpMyAdmin on Ubuntu 20.04<\/a> for updates.<\/p>\n<p><span style=\"color: #ff0000;\"><strong>PS.<\/strong><\/span>\u00a0If you liked this post about\u00a0<strong>how to install phpMyAdmin on Ubuntu 18.04 VPS<\/strong>, please share it with your friends on the social networks using the buttons below, or simply leave a comment in the comments section. Thanks.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>phpMyAdmin is one of the most popular and widely-used web-based database management tools on the market. It is a free &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to Install phpMyAdmin on Ubuntu 18.04\" class=\"read-more button\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phpmyadmin-on-ubuntu-18-04\/#more-29866\" aria-label=\"Read more about How to Install phpMyAdmin on Ubuntu 18.04\">Read More<\/a><\/p>\n","protected":false},"author":4,"featured_media":29918,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1702,13,1698],"tags":[94,59,1779],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Install phpMyAdmin on Ubuntu 18.04 - RoseHosting<\/title>\n<meta name=\"description\" content=\"How to Install phpMyAdmin on Ubuntu 18.04 - RoseHosting\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phpmyadmin-on-ubuntu-18-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 phpMyAdmin on Ubuntu 18.04 - RoseHosting\" \/>\n<meta property=\"og:description\" content=\"How to Install phpMyAdmin on Ubuntu 18.04 - RoseHosting\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phpmyadmin-on-ubuntu-18-04\/\" \/>\n<meta property=\"og:site_name\" content=\"RoseHosting\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/RoseHosting\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/rosehosting.helpdesk\" \/>\n<meta property=\"article:published_time\" content=\"2019-03-15T18:41:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-12T14:19:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/02\/install-phpmyadmin-ubuntu18.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"742\" \/>\n\t<meta property=\"og:image:height\" content=\"372\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Jeff Wilson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@rosehosting\" \/>\n<meta name=\"twitter:site\" content=\"@rosehosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jeff Wilson\" \/>\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\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phpmyadmin-on-ubuntu-18-04\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phpmyadmin-on-ubuntu-18-04\/\"},\"author\":{\"name\":\"Jeff Wilson\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713\"},\"headline\":\"How to Install phpMyAdmin on Ubuntu 18.04\",\"datePublished\":\"2019-03-15T18:41:42+00:00\",\"dateModified\":\"2022-12-12T14:19:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phpmyadmin-on-ubuntu-18-04\/\"},\"wordCount\":878,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phpmyadmin-on-ubuntu-18-04\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/02\/install-phpmyadmin-ubuntu18.jpg\",\"keywords\":[\"phpmyadmin\",\"ubuntu\",\"Ubuntu 18.04\"],\"articleSection\":[\"Databases\",\"Tutorials\",\"Ubuntu\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phpmyadmin-on-ubuntu-18-04\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phpmyadmin-on-ubuntu-18-04\/\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phpmyadmin-on-ubuntu-18-04\/\",\"name\":\"How to Install phpMyAdmin on Ubuntu 18.04 - RoseHosting\",\"isPartOf\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phpmyadmin-on-ubuntu-18-04\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phpmyadmin-on-ubuntu-18-04\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/02\/install-phpmyadmin-ubuntu18.jpg\",\"datePublished\":\"2019-03-15T18:41:42+00:00\",\"dateModified\":\"2022-12-12T14:19:36+00:00\",\"description\":\"How to Install phpMyAdmin on Ubuntu 18.04 - RoseHosting\",\"breadcrumb\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phpmyadmin-on-ubuntu-18-04\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phpmyadmin-on-ubuntu-18-04\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phpmyadmin-on-ubuntu-18-04\/#primaryimage\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/02\/install-phpmyadmin-ubuntu18.jpg\",\"contentUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/02\/install-phpmyadmin-ubuntu18.jpg\",\"width\":742,\"height\":372,\"caption\":\"Install phpMyAdmin on Ubuntu 18.04\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phpmyadmin-on-ubuntu-18-04\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.rosehosting.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Install phpMyAdmin on Ubuntu 18.04\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#website\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/\",\"name\":\"RoseHosting\",\"description\":\"Premium Linux Tutorials Since 2001\",\"publisher\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.rosehosting.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#organization\",\"name\":\"RoseHosting\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png\",\"contentUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png\",\"width\":192,\"height\":192,\"caption\":\"RoseHosting\"},\"image\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/RoseHosting\",\"https:\/\/x.com\/rosehosting\",\"https:\/\/www.linkedin.com\/in\/rosehosting\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713\",\"name\":\"Jeff Wilson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/09271207587f897ab46faaed9b355252?s=96&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/09271207587f897ab46faaed9b355252?s=96&r=g\",\"caption\":\"Jeff Wilson\"},\"description\":\"An experienced Linux veteran with many years of experience. Helping other Linux admins with frequent Linux and business-related blog posts on the RoseHosting blog. Techie by choice. Loving nature and travel. Happily married and father of two lovely children.\",\"sameAs\":[\"https:\/\/www.rosehosting.com\",\"https:\/\/www.facebook.com\/rosehosting.helpdesk\"],\"url\":\"https:\/\/www.rosehosting.com\/blog\/author\/jwilson\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Install phpMyAdmin on Ubuntu 18.04 - RoseHosting","description":"How to Install phpMyAdmin on Ubuntu 18.04 - RoseHosting","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:\/\/www.rosehosting.com\/blog\/how-to-install-phpmyadmin-on-ubuntu-18-04\/","og_locale":"en_US","og_type":"article","og_title":"How to Install phpMyAdmin on Ubuntu 18.04 - RoseHosting","og_description":"How to Install phpMyAdmin on Ubuntu 18.04 - RoseHosting","og_url":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phpmyadmin-on-ubuntu-18-04\/","og_site_name":"RoseHosting","article_publisher":"https:\/\/www.facebook.com\/RoseHosting","article_author":"https:\/\/www.facebook.com\/rosehosting.helpdesk","article_published_time":"2019-03-15T18:41:42+00:00","article_modified_time":"2022-12-12T14:19:36+00:00","og_image":[{"width":742,"height":372,"url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/02\/install-phpmyadmin-ubuntu18.jpg","type":"image\/jpeg"}],"author":"Jeff Wilson","twitter_card":"summary_large_image","twitter_creator":"@rosehosting","twitter_site":"@rosehosting","twitter_misc":{"Written by":"Jeff Wilson","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phpmyadmin-on-ubuntu-18-04\/#article","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phpmyadmin-on-ubuntu-18-04\/"},"author":{"name":"Jeff Wilson","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713"},"headline":"How to Install phpMyAdmin on Ubuntu 18.04","datePublished":"2019-03-15T18:41:42+00:00","dateModified":"2022-12-12T14:19:36+00:00","mainEntityOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phpmyadmin-on-ubuntu-18-04\/"},"wordCount":878,"commentCount":0,"publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phpmyadmin-on-ubuntu-18-04\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/02\/install-phpmyadmin-ubuntu18.jpg","keywords":["phpmyadmin","ubuntu","Ubuntu 18.04"],"articleSection":["Databases","Tutorials","Ubuntu"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.rosehosting.com\/blog\/how-to-install-phpmyadmin-on-ubuntu-18-04\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phpmyadmin-on-ubuntu-18-04\/","url":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phpmyadmin-on-ubuntu-18-04\/","name":"How to Install phpMyAdmin on Ubuntu 18.04 - RoseHosting","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phpmyadmin-on-ubuntu-18-04\/#primaryimage"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phpmyadmin-on-ubuntu-18-04\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/02\/install-phpmyadmin-ubuntu18.jpg","datePublished":"2019-03-15T18:41:42+00:00","dateModified":"2022-12-12T14:19:36+00:00","description":"How to Install phpMyAdmin on Ubuntu 18.04 - RoseHosting","breadcrumb":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phpmyadmin-on-ubuntu-18-04\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.rosehosting.com\/blog\/how-to-install-phpmyadmin-on-ubuntu-18-04\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phpmyadmin-on-ubuntu-18-04\/#primaryimage","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/02\/install-phpmyadmin-ubuntu18.jpg","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/02\/install-phpmyadmin-ubuntu18.jpg","width":742,"height":372,"caption":"Install phpMyAdmin on Ubuntu 18.04"},{"@type":"BreadcrumbList","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phpmyadmin-on-ubuntu-18-04\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.rosehosting.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Install phpMyAdmin on Ubuntu 18.04"}]},{"@type":"WebSite","@id":"https:\/\/www.rosehosting.com\/blog\/#website","url":"https:\/\/www.rosehosting.com\/blog\/","name":"RoseHosting","description":"Premium Linux Tutorials Since 2001","publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.rosehosting.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.rosehosting.com\/blog\/#organization","name":"RoseHosting","url":"https:\/\/www.rosehosting.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png","width":192,"height":192,"caption":"RoseHosting"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/RoseHosting","https:\/\/x.com\/rosehosting","https:\/\/www.linkedin.com\/in\/rosehosting\/"]},{"@type":"Person","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713","name":"Jeff Wilson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/09271207587f897ab46faaed9b355252?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/09271207587f897ab46faaed9b355252?s=96&r=g","caption":"Jeff Wilson"},"description":"An experienced Linux veteran with many years of experience. Helping other Linux admins with frequent Linux and business-related blog posts on the RoseHosting blog. Techie by choice. Loving nature and travel. Happily married and father of two lovely children.","sameAs":["https:\/\/www.rosehosting.com","https:\/\/www.facebook.com\/rosehosting.helpdesk"],"url":"https:\/\/www.rosehosting.com\/blog\/author\/jwilson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/29866"}],"collection":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/comments?post=29866"}],"version-history":[{"count":4,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/29866\/revisions"}],"predecessor-version":[{"id":44158,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/29866\/revisions\/44158"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media\/29918"}],"wp:attachment":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media?parent=29866"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/categories?post=29866"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/tags?post=29866"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}