{"id":640,"date":"2023-07-03T18:43:04","date_gmt":"2023-07-03T18:43:04","guid":{"rendered":"https:\/\/www.devopsconsulting.in\/blog\/?p=640"},"modified":"2023-07-31T18:57:44","modified_gmt":"2023-07-31T18:57:44","slug":"install-phpmyadmin-in-ubuntu-server","status":"publish","type":"post","link":"https:\/\/www.devopsconsulting.in\/blog\/install-phpmyadmin-in-ubuntu-server\/","title":{"rendered":"Install Phpmyadmin in Ubuntu Server"},"content":{"rendered":"\n

I will give you an illustration of how to set up phpMyAdmin in Ubuntu. This guide will demonstrate how to install PHPMyAdmin with Ubuntu 20.04 and Apache2. This post will provide a straightforward example of installing phpMyAdmin on an Ubuntu server. I simply described how to install phpmyadmin on Ubuntu in step-by-step fashion. Let us take the 18.04 Ubuntu server installation of phpMyAdmin as an example.<\/p>\n\n\n\n

Here, I will outline the commands you need to use to install phpMyAdmin in Ubuntu 21.10, 21.04, 20.04, 18.04, and 16.04 step-by-step. So let us install phpMyAdmin by running the following command. <\/p>\n\n\n\n

Update Local Package:<\/strong><\/p>\n\n\n\n

sudo apt update<\/code><\/pre>\n\n\n\n
Install MySQL Server:<\/strong><\/p>\n\n\n\n
sudo apt install mysql-server<\/code><\/pre>\n\n\n\n
Install Phpmyadmin:<\/strong><\/p>\n\n\n\n
sudo apt install phpmyadmin php-mbstring php-zip php-gd php-json php-curl<\/code><\/pre>\n\n\n\n
Create User on MySQL:<\/strong><\/p>\n\n\n\n
you can create new user for mysql by using following query:<\/p>\n\n\n\n
mysql -u root -p\n  \nCREATE USER 'root_new'@'localhost' IDENTIFIED BY 'rootnewpassword';\n     \nGRANT ALL PRIVILEGES ON * . * TO 'root_new'@'localhost';\n  \nFLUSH PRIVILEGES;\n<\/code><\/pre>\n\n\n\n
Now you can go to your browser and open IP or localhost then you will found bellow layout:<\/p>\n\n\n\n
http://localhost\/localhost\/phpmyadmin\n\nhttp:\/\/your_domain_or_IP\/phpmyadmin<\/code><\/pre>\n\n\n\n
Output:<\/strong><\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n","protected":false},"excerpt":{"rendered":"
I will give you an illustration of how to set up phpMyAdmin in Ubuntu. This guide will demonstrate how to install PHPMyAdmin with Ubuntu 20.04 and Apache2…. <\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[98],"tags":[125],"class_list":["post-640","post","type-post","status-publish","format-standard","hentry","category-linux","tag-install-phpmyadmin-in-ubuntu-server"],"yoast_head":"\nInstall Phpmyadmin in Ubuntu Server - DevOps Consulting<\/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:\/\/www.devopsconsulting.in\/blog\/install-phpmyadmin-in-ubuntu-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Install Phpmyadmin in Ubuntu Server - DevOps Consulting\" \/>\n<meta property=\"og:description\" content=\"I will give you an illustration of how to set up phpMyAdmin in Ubuntu. This guide will demonstrate how to install PHPMyAdmin with Ubuntu 20.04 and Apache2....\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.devopsconsulting.in\/blog\/install-phpmyadmin-in-ubuntu-server\/\" \/>\n<meta property=\"og:site_name\" content=\"DevOps Consulting\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-03T18:43:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-07-31T18:57:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.devopsconsulting.in\/blog\/wp-content\/uploads\/2023\/07\/image-7.png\" \/>\n<meta name=\"author\" content=\"Abhishek Singh\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Abhishek Singh\" \/>\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:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/install-phpmyadmin-in-ubuntu-server\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/install-phpmyadmin-in-ubuntu-server\\\/\"},\"author\":{\"name\":\"Abhishek Singh\",\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/#\\\/schema\\\/person\\\/fc397ba8be42f9fdd53450edfc73006f\"},\"headline\":\"Install Phpmyadmin in Ubuntu Server\",\"datePublished\":\"2023-07-03T18:43:04+00:00\",\"dateModified\":\"2023-07-31T18:57:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/install-phpmyadmin-in-ubuntu-server\\\/\"},\"wordCount\":138,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/install-phpmyadmin-in-ubuntu-server\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/image-7.png\",\"keywords\":[\"Install Phpmyadmin in Ubuntu Server\"],\"articleSection\":[\"linux\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/install-phpmyadmin-in-ubuntu-server\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/install-phpmyadmin-in-ubuntu-server\\\/\",\"url\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/install-phpmyadmin-in-ubuntu-server\\\/\",\"name\":\"Install Phpmyadmin in Ubuntu Server - DevOps Consulting\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/install-phpmyadmin-in-ubuntu-server\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/install-phpmyadmin-in-ubuntu-server\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/image-7.png\",\"datePublished\":\"2023-07-03T18:43:04+00:00\",\"dateModified\":\"2023-07-31T18:57:44+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/#\\\/schema\\\/person\\\/fc397ba8be42f9fdd53450edfc73006f\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/install-phpmyadmin-in-ubuntu-server\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/install-phpmyadmin-in-ubuntu-server\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/image-7.png\",\"contentUrl\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/image-7.png\",\"width\":650,\"height\":511},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/\",\"name\":\"DevOps Consulting\",\"description\":\"DevOps Consulting | SRE Consulting | DevSecOps Consulting | MLOps Consulting\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/#\\\/schema\\\/person\\\/fc397ba8be42f9fdd53450edfc73006f\",\"name\":\"Abhishek Singh\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/790feefe779852cdf344ca7318bf6c13832223c9b3c6bf4d217658412041026d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/790feefe779852cdf344ca7318bf6c13832223c9b3c6bf4d217658412041026d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/790feefe779852cdf344ca7318bf6c13832223c9b3c6bf4d217658412041026d?s=96&d=mm&r=g\",\"caption\":\"Abhishek Singh\"},\"description\":\"I\u2019m Abhishek, a DevOps, SRE, DevSecOps, and Cloud expert with a passion for sharing knowledge and real-world experiences. I\u2019ve had the opportunity to work with Cotocus and continue to contribute to multiple platforms where I share insights across different domains: \u2022 DevOps School \u2013 Tech blogs and tutorials \u2022 Holiday Landmark \u2013 Travel stories and guides \u2022 Stocks Mantra \u2013 Stock market strategies and tips \u2022 My Medic Plus \u2013 Health and fitness guidance \u2022 TrueReviewNow \u2013 Honest product reviews \u2022 Wizbrand \u2013 SEO and digital tools for businesses I\u2019m also exploring the fascinating world of Quantum Computing.\",\"url\":\"https:\\\/\\\/www.devopsconsulting.in\\\/blog\\\/author\\\/abhishek\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Install Phpmyadmin in Ubuntu Server - DevOps Consulting","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.devopsconsulting.in\/blog\/install-phpmyadmin-in-ubuntu-server\/","og_locale":"en_US","og_type":"article","og_title":"Install Phpmyadmin in Ubuntu Server - DevOps Consulting","og_description":"I will give you an illustration of how to set up phpMyAdmin in Ubuntu. This guide will demonstrate how to install PHPMyAdmin with Ubuntu 20.04 and Apache2....","og_url":"https:\/\/www.devopsconsulting.in\/blog\/install-phpmyadmin-in-ubuntu-server\/","og_site_name":"DevOps Consulting","article_published_time":"2023-07-03T18:43:04+00:00","article_modified_time":"2023-07-31T18:57:44+00:00","og_image":[{"url":"https:\/\/www.devopsconsulting.in\/blog\/wp-content\/uploads\/2023\/07\/image-7.png","type":"","width":"","height":""}],"author":"Abhishek Singh","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Abhishek Singh","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.devopsconsulting.in\/blog\/install-phpmyadmin-in-ubuntu-server\/#article","isPartOf":{"@id":"https:\/\/www.devopsconsulting.in\/blog\/install-phpmyadmin-in-ubuntu-server\/"},"author":{"name":"Abhishek Singh","@id":"https:\/\/www.devopsconsulting.in\/blog\/#\/schema\/person\/fc397ba8be42f9fdd53450edfc73006f"},"headline":"Install Phpmyadmin in Ubuntu Server","datePublished":"2023-07-03T18:43:04+00:00","dateModified":"2023-07-31T18:57:44+00:00","mainEntityOfPage":{"@id":"https:\/\/www.devopsconsulting.in\/blog\/install-phpmyadmin-in-ubuntu-server\/"},"wordCount":138,"commentCount":0,"image":{"@id":"https:\/\/www.devopsconsulting.in\/blog\/install-phpmyadmin-in-ubuntu-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.devopsconsulting.in\/blog\/wp-content\/uploads\/2023\/07\/image-7.png","keywords":["Install Phpmyadmin in Ubuntu Server"],"articleSection":["linux"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.devopsconsulting.in\/blog\/install-phpmyadmin-in-ubuntu-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.devopsconsulting.in\/blog\/install-phpmyadmin-in-ubuntu-server\/","url":"https:\/\/www.devopsconsulting.in\/blog\/install-phpmyadmin-in-ubuntu-server\/","name":"Install Phpmyadmin in Ubuntu Server - DevOps Consulting","isPartOf":{"@id":"https:\/\/www.devopsconsulting.in\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.devopsconsulting.in\/blog\/install-phpmyadmin-in-ubuntu-server\/#primaryimage"},"image":{"@id":"https:\/\/www.devopsconsulting.in\/blog\/install-phpmyadmin-in-ubuntu-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.devopsconsulting.in\/blog\/wp-content\/uploads\/2023\/07\/image-7.png","datePublished":"2023-07-03T18:43:04+00:00","dateModified":"2023-07-31T18:57:44+00:00","author":{"@id":"https:\/\/www.devopsconsulting.in\/blog\/#\/schema\/person\/fc397ba8be42f9fdd53450edfc73006f"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.devopsconsulting.in\/blog\/install-phpmyadmin-in-ubuntu-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.devopsconsulting.in\/blog\/install-phpmyadmin-in-ubuntu-server\/#primaryimage","url":"https:\/\/www.devopsconsulting.in\/blog\/wp-content\/uploads\/2023\/07\/image-7.png","contentUrl":"https:\/\/www.devopsconsulting.in\/blog\/wp-content\/uploads\/2023\/07\/image-7.png","width":650,"height":511},{"@type":"WebSite","@id":"https:\/\/www.devopsconsulting.in\/blog\/#website","url":"https:\/\/www.devopsconsulting.in\/blog\/","name":"DevOps Consulting","description":"DevOps Consulting | SRE Consulting | DevSecOps Consulting | MLOps Consulting","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.devopsconsulting.in\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.devopsconsulting.in\/blog\/#\/schema\/person\/fc397ba8be42f9fdd53450edfc73006f","name":"Abhishek Singh","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/790feefe779852cdf344ca7318bf6c13832223c9b3c6bf4d217658412041026d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/790feefe779852cdf344ca7318bf6c13832223c9b3c6bf4d217658412041026d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/790feefe779852cdf344ca7318bf6c13832223c9b3c6bf4d217658412041026d?s=96&d=mm&r=g","caption":"Abhishek Singh"},"description":"I\u2019m Abhishek, a DevOps, SRE, DevSecOps, and Cloud expert with a passion for sharing knowledge and real-world experiences. I\u2019ve had the opportunity to work with Cotocus and continue to contribute to multiple platforms where I share insights across different domains: \u2022 DevOps School \u2013 Tech blogs and tutorials \u2022 Holiday Landmark \u2013 Travel stories and guides \u2022 Stocks Mantra \u2013 Stock market strategies and tips \u2022 My Medic Plus \u2013 Health and fitness guidance \u2022 TrueReviewNow \u2013 Honest product reviews \u2022 Wizbrand \u2013 SEO and digital tools for businesses I\u2019m also exploring the fascinating world of Quantum Computing.","url":"https:\/\/www.devopsconsulting.in\/blog\/author\/abhishek\/"}]}},"_links":{"self":[{"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/posts\/640","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/comments?post=640"}],"version-history":[{"count":1,"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/posts\/640\/revisions"}],"predecessor-version":[{"id":644,"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/posts\/640\/revisions\/644"}],"wp:attachment":[{"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/media?parent=640"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/categories?post=640"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsconsulting.in\/blog\/wp-json\/wp\/v2\/tags?post=640"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}