{"id":9730,"date":"2022-10-29T13:03:58","date_gmt":"2022-10-29T07:33:58","guid":{"rendered":"https:\/\/www.skynats.com\/?p=9730"},"modified":"2023-06-15T17:02:36","modified_gmt":"2023-06-15T11:32:36","slug":"install-and-secure-phpmyadmin-on-ubuntu","status":"publish","type":"post","link":"https:\/\/www.skynats.com\/blog\/install-and-secure-phpmyadmin-on-ubuntu\/","title":{"rendered":"Install and Secure phpMyAdmin on Ubuntu 18.04"},"content":{"rendered":"\n<p>Why do users favor Installing PHPMyAdmin on Ubuntu?<\/p>\n\n\n\n<p>Because PHPMyAdmin enables users to interact with MySQL via a web interface<\/p>\n\n\n\n<p>As part of our <a href=\"https:\/\/www.skynats.com\/blog\/\" target=\"_blank\" rel=\"noreferrer noopener\">Server Management services<\/a>, we frequently receive requests from clients to install PHPMyAdmin.<\/p>\n\n\n\n<p>We&#8217;ll look at installing PHPMyAdmin on Ubuntu.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-the-importance-of-phpmyadmin\">The Importance of PHPMyAdmin<\/h2>\n\n\n\n<p>Frequently, server administration entails Database management. Users might not find comfort interacting with the system exclusively from the MySQL prompt, though. Herein lies the value of phpMyAdmin, which was developed to enable user interaction with MySQL via a web interface.<\/p>\n\n\n\n<p>The user interface is used to carry out common operations like managing databases, tables, indexes, permissions, and so forth.<\/p>\n\n\n\n<p>The following are some of the features:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>MySQL database management.<\/li><li>Web interface.<\/li><li>Run customized SQL queries<\/li><li>Multiple-server administration<\/li><li>Able to import and export data in a variety of formats, such as SQL, XML, and CSV<\/li><li>The ability to manually backup MySQL databases<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-phpmyadmin-installation-on-ubuntu\">PHPMyAdmin Installation on Ubuntu<\/h3>\n\n\n\n<p>Let&#8217;s look at how phpMyAdmin is installed and secured by our tech support team in this article so that users can use it to manage databases on an Ubuntu 18.04 system securely.<\/p>\n\n\n\n<p>It is essential to have the server&#8217;s root access and the ufw firewall configured as prerequisites. LAMP needs to be set up on Ubuntu 18.04 server.<\/p>\n\n\n\n<p>Importantly, phpMyAdmin can be installed from the default Ubuntu repository.<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>We first update the package index on the server.<\/li><\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>apt update &amp;&amp; upgrade<\/code><\/pre>\n\n\n\n<ol class=\"wp-block-list\" start=\"2\"><li>Following the installation of PHP extensions and PhpMyAdmin for managing non-ASCII strings and other required tools, run the following command:<\/li><\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>apt install phpmyadmin php-mbstring php-gettext<\/code><\/pre>\n\n\n\n<ol class=\"wp-block-list\" start=\"3\"><li>When prompted to choose a web server during command execution, we select Apache2 and ENTER.<\/li><\/ol>\n\n\n\n<ol class=\"wp-block-list\" start=\"4\"><li>Additionally, we have the choice of either automatic setup or manual database creation in the following step. Pressing ENTER for yes makes the automatic installation our choice.<\/li><\/ol>\n\n\n\n<ol class=\"wp-block-list\" start=\"5\"><li>The next step is to configure the PhpMyAdmin password.<\/li><\/ol>\n\n\n\n<ol class=\"wp-block-list\" start=\"6\"><li>Again, the PHP extension is enabled.<\/li><\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>phpenmod mbstring<\/code><\/pre>\n\n\n\n<ol class=\"wp-block-list\" start=\"7\"><li>After that, Apache must be restarted for the changes to take effect:<\/li><\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>systemctl restart apache2<\/code><\/pre>\n\n\n\n<p>By visiting http:\/\/ip\/phpmyadmin, we confirm the installation of PhpMyAdmin.<\/p>\n\n\n\n<p><strong>Conclusion<\/strong><\/p>\n\n\n\n<p>PHPMyAdmin enables users&#8217; interaction with MySQL via a web interface and simplifies MySQL database administration. Today, we discovered how our technical support team installed PhpMyAdmin on Ubuntu.<\/p>\n\n\n\n<p>Are you looking for an answer to another query?\u00a0<a href=\"https:\/\/www.skynats.com\/contact-us\/\" target=\"_blank\" rel=\"noreferrer noopener\">Contact<\/a>\u00a0our technical support team.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Why do users favor Installing PHPMyAdmin on Ubuntu? Because PHPMyAdmin enables users to interact with MySQL via a web interface As part of our Server Management services, we frequently receive requests from clients to install PHPMyAdmin. We&#8217;ll look at installing PHPMyAdmin on Ubuntu. The Importance of PHPMyAdmin Frequently, server administration entails Database management. Users might [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[658,226],"class_list":["post-9730","post","type-post","status-publish","format-standard","hentry","category-blog","tag-phpmyadmin","tag-ubuntu-18-04"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.9 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Install and Secure phpMyAdmin on Ubuntu 18.04 | Skynats<\/title>\n<meta name=\"description\" content=\"Why do users favor Installing PHPMyAdmin on Ubuntu? PHPMyAdmin enables users to interact with MySQL via a web interface.\" \/>\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.skynats.com\/blog\/install-and-secure-phpmyadmin-on-ubuntu\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Install and Secure phpMyAdmin on Ubuntu 18.04\" \/>\n<meta property=\"og:description\" content=\"Why do users favor Installing PHPMyAdmin on Ubuntu? PHPMyAdmin enables users to interact with MySQL via a web interface.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.skynats.com\/blog\/install-and-secure-phpmyadmin-on-ubuntu\/\" \/>\n<meta property=\"og:site_name\" content=\"Server Management Services | Cloud Management | Skynats\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/skynats\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-29T07:33:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-15T11:32:36+00:00\" \/>\n<meta name=\"author\" content=\"Kevin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@skynatstech\" \/>\n<meta name=\"twitter:site\" content=\"@skynatstech\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kevin\" \/>\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.skynats.com\\\/blog\\\/install-and-secure-phpmyadmin-on-ubuntu\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/install-and-secure-phpmyadmin-on-ubuntu\\\/\"},\"author\":{\"name\":\"Kevin\",\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#\\\/schema\\\/person\\\/749ae0470320eb759ff1e07b8ea7fbe3\"},\"headline\":\"Install and Secure phpMyAdmin on Ubuntu 18.04\",\"datePublished\":\"2022-10-29T07:33:58+00:00\",\"dateModified\":\"2023-06-15T11:32:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/install-and-secure-phpmyadmin-on-ubuntu\\\/\"},\"wordCount\":378,\"publisher\":{\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#organization\"},\"keywords\":[\"phpmyadmin\",\"Ubuntu 18.04\"],\"articleSection\":[\"Blog\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/install-and-secure-phpmyadmin-on-ubuntu\\\/\",\"url\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/install-and-secure-phpmyadmin-on-ubuntu\\\/\",\"name\":\"Install and Secure phpMyAdmin on Ubuntu 18.04 | Skynats\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#website\"},\"datePublished\":\"2022-10-29T07:33:58+00:00\",\"dateModified\":\"2023-06-15T11:32:36+00:00\",\"description\":\"Why do users favor Installing PHPMyAdmin on Ubuntu? PHPMyAdmin enables users to interact with MySQL via a web interface.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/install-and-secure-phpmyadmin-on-ubuntu\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.skynats.com\\\/blog\\\/install-and-secure-phpmyadmin-on-ubuntu\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/install-and-secure-phpmyadmin-on-ubuntu\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Install and Secure phpMyAdmin on Ubuntu 18.04\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/\",\"name\":\"Server Management Services | Cloud Management | Skynats\",\"description\":\"Server Management and Cloud Management\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#organization\",\"name\":\"Skynats Technologies\",\"url\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/Sknats-Logo-New-whole.png\",\"contentUrl\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/Sknats-Logo-New-whole.png\",\"width\":989,\"height\":367,\"caption\":\"Skynats Technologies\"},\"image\":{\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/skynats\",\"https:\\\/\\\/x.com\\\/skynatstech\",\"https:\\\/\\\/www.instagram.com\\\/skynatstech\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/skynats-technologies\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCvTAjrFJ4_E2MJKwlDHomlg\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#\\\/schema\\\/person\\\/749ae0470320eb759ff1e07b8ea7fbe3\",\"name\":\"Kevin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/37a006382b218eff478403065cc9d903f85dd0085cb2af7fee95b4537b581c13?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/37a006382b218eff478403065cc9d903f85dd0085cb2af7fee95b4537b581c13?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/37a006382b218eff478403065cc9d903f85dd0085cb2af7fee95b4537b581c13?s=96&d=mm&r=g\",\"caption\":\"Kevin\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Install and Secure phpMyAdmin on Ubuntu 18.04 | Skynats","description":"Why do users favor Installing PHPMyAdmin on Ubuntu? PHPMyAdmin enables users to interact with MySQL via a web interface.","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.skynats.com\/blog\/install-and-secure-phpmyadmin-on-ubuntu\/","og_locale":"en_US","og_type":"article","og_title":"Install and Secure phpMyAdmin on Ubuntu 18.04","og_description":"Why do users favor Installing PHPMyAdmin on Ubuntu? PHPMyAdmin enables users to interact with MySQL via a web interface.","og_url":"https:\/\/www.skynats.com\/blog\/install-and-secure-phpmyadmin-on-ubuntu\/","og_site_name":"Server Management Services | Cloud Management | Skynats","article_publisher":"https:\/\/www.facebook.com\/skynats","article_published_time":"2022-10-29T07:33:58+00:00","article_modified_time":"2023-06-15T11:32:36+00:00","author":"Kevin","twitter_card":"summary_large_image","twitter_creator":"@skynatstech","twitter_site":"@skynatstech","twitter_misc":{"Written by":"Kevin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.skynats.com\/blog\/install-and-secure-phpmyadmin-on-ubuntu\/#article","isPartOf":{"@id":"https:\/\/www.skynats.com\/blog\/install-and-secure-phpmyadmin-on-ubuntu\/"},"author":{"name":"Kevin","@id":"https:\/\/www.skynats.com\/blog\/#\/schema\/person\/749ae0470320eb759ff1e07b8ea7fbe3"},"headline":"Install and Secure phpMyAdmin on Ubuntu 18.04","datePublished":"2022-10-29T07:33:58+00:00","dateModified":"2023-06-15T11:32:36+00:00","mainEntityOfPage":{"@id":"https:\/\/www.skynats.com\/blog\/install-and-secure-phpmyadmin-on-ubuntu\/"},"wordCount":378,"publisher":{"@id":"https:\/\/www.skynats.com\/blog\/#organization"},"keywords":["phpmyadmin","Ubuntu 18.04"],"articleSection":["Blog"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.skynats.com\/blog\/install-and-secure-phpmyadmin-on-ubuntu\/","url":"https:\/\/www.skynats.com\/blog\/install-and-secure-phpmyadmin-on-ubuntu\/","name":"Install and Secure phpMyAdmin on Ubuntu 18.04 | Skynats","isPartOf":{"@id":"https:\/\/www.skynats.com\/blog\/#website"},"datePublished":"2022-10-29T07:33:58+00:00","dateModified":"2023-06-15T11:32:36+00:00","description":"Why do users favor Installing PHPMyAdmin on Ubuntu? PHPMyAdmin enables users to interact with MySQL via a web interface.","breadcrumb":{"@id":"https:\/\/www.skynats.com\/blog\/install-and-secure-phpmyadmin-on-ubuntu\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.skynats.com\/blog\/install-and-secure-phpmyadmin-on-ubuntu\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.skynats.com\/blog\/install-and-secure-phpmyadmin-on-ubuntu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.skynats.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Install and Secure phpMyAdmin on Ubuntu 18.04"}]},{"@type":"WebSite","@id":"https:\/\/www.skynats.com\/blog\/#website","url":"https:\/\/www.skynats.com\/blog\/","name":"Server Management Services | Cloud Management | Skynats","description":"Server Management and Cloud Management","publisher":{"@id":"https:\/\/www.skynats.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.skynats.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.skynats.com\/blog\/#organization","name":"Skynats Technologies","url":"https:\/\/www.skynats.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.skynats.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.skynats.com\/blog\/wp-content\/uploads\/2021\/08\/Sknats-Logo-New-whole.png","contentUrl":"https:\/\/www.skynats.com\/blog\/wp-content\/uploads\/2021\/08\/Sknats-Logo-New-whole.png","width":989,"height":367,"caption":"Skynats Technologies"},"image":{"@id":"https:\/\/www.skynats.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/skynats","https:\/\/x.com\/skynatstech","https:\/\/www.instagram.com\/skynatstech\/","https:\/\/www.linkedin.com\/company\/skynats-technologies","https:\/\/www.youtube.com\/channel\/UCvTAjrFJ4_E2MJKwlDHomlg"]},{"@type":"Person","@id":"https:\/\/www.skynats.com\/blog\/#\/schema\/person\/749ae0470320eb759ff1e07b8ea7fbe3","name":"Kevin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/37a006382b218eff478403065cc9d903f85dd0085cb2af7fee95b4537b581c13?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/37a006382b218eff478403065cc9d903f85dd0085cb2af7fee95b4537b581c13?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/37a006382b218eff478403065cc9d903f85dd0085cb2af7fee95b4537b581c13?s=96&d=mm&r=g","caption":"Kevin"}}]}},"_links":{"self":[{"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/posts\/9730","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/comments?post=9730"}],"version-history":[{"count":0,"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/posts\/9730\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/media?parent=9730"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/categories?post=9730"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/tags?post=9730"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}