{"id":9077,"date":"2020-06-30T09:26:11","date_gmt":"2020-06-30T06:26:11","guid":{"rendered":"https:\/\/unihost.com\/help\/?p=9077"},"modified":"2023-01-19T13:59:59","modified_gmt":"2023-01-19T10:59:59","slug":"how-to-install-phpmyadmin","status":"publish","type":"post","link":"https:\/\/unihost.com\/help\/how-to-install-phpmyadmin\/","title":{"rendered":"How to install phpMyAdmin"},"content":{"rendered":"

In this guide, we will consider installing phpMyAdmin on a newly installed server or VPS running Ubuntu 18.04 or Centos 7.7.PhpMyAdmin is a very simple and convenient tool for managing MySQL databases.<\/span><\/p>\n

Installation on Ubuntu 18.04<\/span><\/h5>\n

First, install the LAMP software stack (Linux, Apache, MySQL, PHP):<\/span><\/p>\n

apt-get update\napt-get install tasksel\ntasksel install lamp-server<\/span><\/pre>\n
\"How<\/span><\/p>\n
Next, following the prompts, select a web server, agree to create a database for phpMyAdmin, and come up with a password for the phpmyadmin user.<\/span><\/p>\n
\"How \"How \"How<\/span><\/p>\n
The next step is to configure root access to phpMyAdmin. Enter the following command in the terminal and follow the prompts:<\/span><\/p>\n
mysql_secure_installation<\/span><\/pre>\n
\"How<\/span><\/p>\n
You may also need to switch the root user authentication method from auth_socket<\/span> to mysql_native_password<\/span>:<\/span><\/p>\n
mysql\nSELECT user,plugin,host FROM mysql.user WHERE user = 'root';<\/span><\/pre>\n
\"How<\/span><\/p>\n
Run the following query to change the value of the plugin to mysql_native_password<\/span>. By default, the password is required to be at least 8 characters long and contain uppercase and lowercase letters, numbers, and special characters.<\/span><\/p>\n
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'enter_password_here<\/span>';<\/span><\/pre>\n
Now you can open a browser and go to your server address:<\/span><\/p>\n
http:\/\/xxx.xxx.xxx.xxx\/phpmyadmin\/index.php<\/span><\/pre>\n
\"How \"How<\/span><\/p>\n
Installation on Centos 7.7<\/span><\/h5>\n
First, install the LAMP software stack (Linux, Apache, MySQL, PHP):<\/span><\/p>\n
<\/pre>\n
yum -y update && yum -y install nano httpd mariadb-server mariadb php php-mysql && systemctl enable httpd && systemctl enable mariadb && systemctl enable --now httpd && systemctl enable --now mariadb<\/span><\/pre>\n
After that, you can proceed to install phpMyAdmin:<\/span><\/p>\n
yum -y install epel-release && yum -y install phpmyadmin<\/span><\/pre>\n
Edit the phpMyAdmin.conf file:<\/span><\/p>\n
nano \/etc\/httpd\/conf.d\/phpMyAdmin.conf<\/span><\/pre>\n
\"How<\/span><\/p>\n
By default, access to the phpMyAdmin web interface is allowed only for the computer on which it is installed. To access the web interface, change the highlighted values to your external IP address or to allow access for everyone, bring the settings file to the form as shown in the screenshot below.<\/span><\/p>\n
\"How<\/span><\/p>\n
The next step is to configure root access to phpMyAdmin. Enter the following command in the terminal and follow the prompts:<\/span><\/p>\n
mysql_secure_installation<\/span><\/pre>\n
This completes the installation. Now you can open a browser and go to your server address:<\/span><\/p>\n
http:\/\/xxx.xxx.xxx.xxx\/phpmyadmin\/index.php<\/span><\/pre>\n","protected":false},"excerpt":{"rendered":"
In this guide, we will consider installing phpMyAdmin on a newly installed server or VPS running Ubuntu 18.04 or Centos 7.7.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[158],"tags":[634],"class_list":["post-9077","post","type-post","status-publish","format-standard","hentry","category-dedicated-servers","tag-phpmyadmin"],"yoast_head":"\nHow to install phpMyAdmin - Unihost.FAQ<\/title>\n<meta name=\"description\" content=\"In this guide, we will consider installing phpMyAdmin on a newly installed server or VPS running Ubuntu 18.04 or Centos 7.7.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/unihost.com\/help\/how-to-install-phpmyadmin\/\" \/>\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 - Unihost.FAQ\" \/>\n<meta property=\"og:description\" content=\"In this guide, we will consider installing phpMyAdmin on a newly installed server or VPS running Ubuntu 18.04 or Centos 7.7.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/unihost.com\/help\/how-to-install-phpmyadmin\/\" \/>\n<meta property=\"og:site_name\" content=\"Unihost.FAQ\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/unihost\/\" \/>\n<meta property=\"article:published_time\" content=\"2020-06-30T06:26:11+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-01-19T10:59:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/unihost.com\/help\/wp-content\/uploads\/1-13.png\" \/>\n<meta name=\"author\" content=\"Unihost Support\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@unihost\" \/>\n<meta name=\"twitter:site\" content=\"@unihost\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Unihost Support\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/unihost.com\/help\/how-to-install-phpmyadmin\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/unihost.com\/help\/how-to-install-phpmyadmin\/\"},\"author\":{\"name\":\"Unihost Support\",\"@id\":\"https:\/\/unihost.com\/help\/#\/schema\/person\/bb5ae95f38577c920e6a7507888b715a\"},\"headline\":\"How to install phpMyAdmin\",\"datePublished\":\"2020-06-30T06:26:11+00:00\",\"dateModified\":\"2023-01-19T10:59:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/unihost.com\/help\/how-to-install-phpmyadmin\/\"},\"wordCount\":276,\"publisher\":{\"@id\":\"https:\/\/unihost.com\/help\/#organization\"},\"image\":{\"@id\":\"https:\/\/unihost.com\/help\/how-to-install-phpmyadmin\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/unihost.com\/help\/wp-content\/uploads\/1-13.png\",\"keywords\":[\"phpmyadmin\"],\"articleSection\":[\"02. Dedicated servers\"],\"inLanguage\":\"en\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/unihost.com\/help\/how-to-install-phpmyadmin\/\",\"url\":\"https:\/\/unihost.com\/help\/how-to-install-phpmyadmin\/\",\"name\":\"How to install phpMyAdmin - Unihost.FAQ\",\"isPartOf\":{\"@id\":\"https:\/\/unihost.com\/help\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/unihost.com\/help\/how-to-install-phpmyadmin\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/unihost.com\/help\/how-to-install-phpmyadmin\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/unihost.com\/help\/wp-content\/uploads\/1-13.png\",\"datePublished\":\"2020-06-30T06:26:11+00:00\",\"dateModified\":\"2023-01-19T10:59:59+00:00\",\"description\":\"In this guide, we will consider installing phpMyAdmin on a newly installed server or VPS running Ubuntu 18.04 or Centos 7.7.\",\"breadcrumb\":{\"@id\":\"https:\/\/unihost.com\/help\/how-to-install-phpmyadmin\/#breadcrumb\"},\"inLanguage\":\"en\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/unihost.com\/help\/how-to-install-phpmyadmin\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\/\/unihost.com\/help\/how-to-install-phpmyadmin\/#primaryimage\",\"url\":\"https:\/\/unihost.com\/help\/wp-content\/uploads\/1-13.png\",\"contentUrl\":\"https:\/\/unihost.com\/help\/wp-content\/uploads\/1-13.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/unihost.com\/help\/how-to-install-phpmyadmin\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Unihost\",\"item\":\"https:\/\/unihost.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Help\",\"item\":\"https:\/\/unihost.com\/help\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How to install phpMyAdmin\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/unihost.com\/help\/#website\",\"url\":\"https:\/\/unihost.com\/help\/\",\"name\":\"Unihost.FAQ\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/unihost.com\/help\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/unihost.com\/help\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/unihost.com\/help\/#organization\",\"name\":\"Unihost\",\"alternateName\":\"Unihost\",\"url\":\"https:\/\/unihost.com\/help\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\/\/unihost.com\/help\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/unihost.com\/help\/minio.php?2026\/01\/minio.png\",\"contentUrl\":\"https:\/\/unihost.com\/help\/minio.php?2026\/01\/minio.png\",\"width\":300,\"height\":300,\"caption\":\"Unihost\"},\"image\":{\"@id\":\"https:\/\/unihost.com\/help\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/unihost\/\",\"https:\/\/x.com\/unihost\",\"https:\/\/www.instagram.com\/unihost\/?hl=en\",\"https:\/\/www.linkedin.com\/company\/unihost-com\",\"https:\/\/www.youtube.com\/channel\/UCITKsxMDnslQY8brN3advgw\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/unihost.com\/help\/#\/schema\/person\/bb5ae95f38577c920e6a7507888b715a\",\"name\":\"Unihost Support\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\/\/unihost.com\/help\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a0c9db17c2a0d93e8a0d5ac123f8c5db750ad4d3d5657369c0c4e480f5af77b8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a0c9db17c2a0d93e8a0d5ac123f8c5db750ad4d3d5657369c0c4e480f5af77b8?s=96&d=mm&r=g\",\"caption\":\"Unihost Support\"},\"sameAs\":[\"https:\/\/unihost.com\/\"],\"url\":\"https:\/\/unihost.com\/help\/author\/support\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to install phpMyAdmin - Unihost.FAQ","description":"In this guide, we will consider installing phpMyAdmin on a newly installed server or VPS running Ubuntu 18.04 or Centos 7.7.","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:\/\/unihost.com\/help\/how-to-install-phpmyadmin\/","og_locale":"en_US","og_type":"article","og_title":"How to install phpMyAdmin - Unihost.FAQ","og_description":"In this guide, we will consider installing phpMyAdmin on a newly installed server or VPS running Ubuntu 18.04 or Centos 7.7.","og_url":"https:\/\/unihost.com\/help\/how-to-install-phpmyadmin\/","og_site_name":"Unihost.FAQ","article_publisher":"https:\/\/www.facebook.com\/unihost\/","article_published_time":"2020-06-30T06:26:11+00:00","article_modified_time":"2023-01-19T10:59:59+00:00","og_image":[{"url":"https:\/\/unihost.com\/help\/wp-content\/uploads\/1-13.png","type":"","width":"","height":""}],"author":"Unihost Support","twitter_card":"summary_large_image","twitter_creator":"@unihost","twitter_site":"@unihost","twitter_misc":{"Written by":"Unihost Support","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/unihost.com\/help\/how-to-install-phpmyadmin\/#article","isPartOf":{"@id":"https:\/\/unihost.com\/help\/how-to-install-phpmyadmin\/"},"author":{"name":"Unihost Support","@id":"https:\/\/unihost.com\/help\/#\/schema\/person\/bb5ae95f38577c920e6a7507888b715a"},"headline":"How to install phpMyAdmin","datePublished":"2020-06-30T06:26:11+00:00","dateModified":"2023-01-19T10:59:59+00:00","mainEntityOfPage":{"@id":"https:\/\/unihost.com\/help\/how-to-install-phpmyadmin\/"},"wordCount":276,"publisher":{"@id":"https:\/\/unihost.com\/help\/#organization"},"image":{"@id":"https:\/\/unihost.com\/help\/how-to-install-phpmyadmin\/#primaryimage"},"thumbnailUrl":"https:\/\/unihost.com\/help\/wp-content\/uploads\/1-13.png","keywords":["phpmyadmin"],"articleSection":["02. Dedicated servers"],"inLanguage":"en"},{"@type":"WebPage","@id":"https:\/\/unihost.com\/help\/how-to-install-phpmyadmin\/","url":"https:\/\/unihost.com\/help\/how-to-install-phpmyadmin\/","name":"How to install phpMyAdmin - Unihost.FAQ","isPartOf":{"@id":"https:\/\/unihost.com\/help\/#website"},"primaryImageOfPage":{"@id":"https:\/\/unihost.com\/help\/how-to-install-phpmyadmin\/#primaryimage"},"image":{"@id":"https:\/\/unihost.com\/help\/how-to-install-phpmyadmin\/#primaryimage"},"thumbnailUrl":"https:\/\/unihost.com\/help\/wp-content\/uploads\/1-13.png","datePublished":"2020-06-30T06:26:11+00:00","dateModified":"2023-01-19T10:59:59+00:00","description":"In this guide, we will consider installing phpMyAdmin on a newly installed server or VPS running Ubuntu 18.04 or Centos 7.7.","breadcrumb":{"@id":"https:\/\/unihost.com\/help\/how-to-install-phpmyadmin\/#breadcrumb"},"inLanguage":"en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/unihost.com\/help\/how-to-install-phpmyadmin\/"]}]},{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/unihost.com\/help\/how-to-install-phpmyadmin\/#primaryimage","url":"https:\/\/unihost.com\/help\/wp-content\/uploads\/1-13.png","contentUrl":"https:\/\/unihost.com\/help\/wp-content\/uploads\/1-13.png"},{"@type":"BreadcrumbList","@id":"https:\/\/unihost.com\/help\/how-to-install-phpmyadmin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Unihost","item":"https:\/\/unihost.com\/"},{"@type":"ListItem","position":2,"name":"Help","item":"https:\/\/unihost.com\/help\/"},{"@type":"ListItem","position":3,"name":"How to install phpMyAdmin"}]},{"@type":"WebSite","@id":"https:\/\/unihost.com\/help\/#website","url":"https:\/\/unihost.com\/help\/","name":"Unihost.FAQ","description":"","publisher":{"@id":"https:\/\/unihost.com\/help\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/unihost.com\/help\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en"},{"@type":"Organization","@id":"https:\/\/unihost.com\/help\/#organization","name":"Unihost","alternateName":"Unihost","url":"https:\/\/unihost.com\/help\/","logo":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/unihost.com\/help\/#\/schema\/logo\/image\/","url":"https:\/\/unihost.com\/help\/minio.php?2026\/01\/minio.png","contentUrl":"https:\/\/unihost.com\/help\/minio.php?2026\/01\/minio.png","width":300,"height":300,"caption":"Unihost"},"image":{"@id":"https:\/\/unihost.com\/help\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/unihost\/","https:\/\/x.com\/unihost","https:\/\/www.instagram.com\/unihost\/?hl=en","https:\/\/www.linkedin.com\/company\/unihost-com","https:\/\/www.youtube.com\/channel\/UCITKsxMDnslQY8brN3advgw"]},{"@type":"Person","@id":"https:\/\/unihost.com\/help\/#\/schema\/person\/bb5ae95f38577c920e6a7507888b715a","name":"Unihost Support","image":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/unihost.com\/help\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a0c9db17c2a0d93e8a0d5ac123f8c5db750ad4d3d5657369c0c4e480f5af77b8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a0c9db17c2a0d93e8a0d5ac123f8c5db750ad4d3d5657369c0c4e480f5af77b8?s=96&d=mm&r=g","caption":"Unihost Support"},"sameAs":["https:\/\/unihost.com\/"],"url":"https:\/\/unihost.com\/help\/author\/support\/"}]}},"_links":{"self":[{"href":"https:\/\/unihost.com\/help\/wp-json\/wp\/v2\/posts\/9077","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unihost.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unihost.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unihost.com\/help\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/unihost.com\/help\/wp-json\/wp\/v2\/comments?post=9077"}],"version-history":[{"count":19,"href":"https:\/\/unihost.com\/help\/wp-json\/wp\/v2\/posts\/9077\/revisions"}],"predecessor-version":[{"id":9126,"href":"https:\/\/unihost.com\/help\/wp-json\/wp\/v2\/posts\/9077\/revisions\/9126"}],"wp:attachment":[{"href":"https:\/\/unihost.com\/help\/wp-json\/wp\/v2\/media?parent=9077"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unihost.com\/help\/wp-json\/wp\/v2\/categories?post=9077"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unihost.com\/help\/wp-json\/wp\/v2\/tags?post=9077"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}