{"id":2559,"date":"2016-08-24T14:48:03","date_gmt":"2016-08-24T18:48:03","guid":{"rendered":"https:\/\/www.globo.tech\/learning-center\/?p=2559"},"modified":"2016-10-05T23:27:00","modified_gmt":"2016-10-06T03:27:00","slug":"install-phpmyadmin-ubuntu-14","status":"publish","type":"post","link":"https:\/\/www.globo.tech\/learning-center\/install-phpmyadmin-ubuntu-14\/","title":{"rendered":"How to install PHPMyAdmin on Ubuntu 14"},"content":{"rendered":"

PHPMyAdmin is a browser-based server administration tool used to create and manage databases such as MySQL using a visual interface. Its name comes from the fact that it is written in PHP. It was created in 1998 and is still the most popular browser-based server management tool.<\/p>\n

PHPMyAdmin is free and open source under the GNU General Public License version 2.<\/p>\n

Getting started<\/h2>\n

You’ll need the following in place before getting started with this guide:
\n\u2022 1 Node (Cloud Server<\/a> or Dedicated Server<\/a>) running Ubuntu 14.
\n\u2022 Root access
\n\u2022 LAMP stack configured<\/p>\n

Tutorial<\/h2>\n

Before installing, you will need to make sure that your server is up to date.<\/p>\n

apt-get update<\/code><\/p>\n

Afterwards, proceed to install PHPMyAdmin from the repository.<\/p>\n

apt-get install phpmyadmin<\/code><\/p>\n

A windows will appear and ask you to choose between apache2 and lighttp. For the purposes of the guide, you can select apache2. You will also need to choose what your MySQL root password and the password you want to set for PHPMyAdmin will be.<\/p>\n

In order for PHPMyAdmin to work correctly, you next need to enable some PHP modules. After doing so, restart the apache daemon so it reflects the changes you made.<\/p>\n

php5enmod mcrypt
\nservice apache2 restart<\/code><\/p>\n

You should now have now access to your PHPMyAdmin. Follow this URL to log in to the interface:
\nhttp:\/\/your_main_IP\/phpmyadmin\/<\/code><\/p>\n

To prevent others from doing the same, it is necessary to secure the directory of your PHPMyAdmin with a .htaccess file.<\/p>\n

You need to open this file in a text editor:
\n\/etc\/apache2\/conf-available\/phpmyadmin.conf.<\/code><\/p>\n

Add the AllowOverride All directive.<\/p>\n

<Directory \/usr\/share\/phpmyadmin>
\nOptions FollowSymLinks
\nDirectoryIndex index.php
\nAllowOverride All <--------------- The line you need to add<\/code><\/p>\n

After making the change, save and exit. Once again, restart apache to update.<\/p>\n

service apache2 restart<\/code><\/p>\n

We will now create the .htaccess file in \/usr\/share\/phpmyadmin\/. Add the following block:<\/p>\n

nano \/usr\/share\/phpmyadmin\/.htaccess<\/code><\/p>\n

AuthType Basic
\nAuthName \"Restricted Files\"
\nAuthUserFile \/etc\/phpmyadmin\/.htpasswd
\nRequire valid-user<\/code><\/p>\n

When completed, save and close the file.<\/p>\n

To generate the password encryption, install this package onto your server:<\/p>\n

apt-get install apache2-utils<\/code><\/p>\n

We can now set the password for authentication. For the purposes of this guide, we’ll be using a user called admin.<\/p>\n

htpasswd -c \/etc\/phpmyadmin\/.htpasswd admin<\/code><\/p>\n

The “-c” flag in the above command is used for the first user created. If you find the need to add another user, merely use the same command without the “-c” flag.<\/p>\n

Your PHPMyAdmin installation should now be secured with a .htaccess file. Try it out by visiting the same URL as before:
\nhttp:\/\/your_main_ip\/phpmyadmin<\/code><\/p>\n

If set up correctly, you should see a small box asking for your admin login and password. Enter the ones we created previously, and you will be redirected to the login page of PHPMyAdmin to login with your MySQL root credentials.<\/p>\n

Conclusion<\/h2>\n

PHPMyAdmin is one of the most popular server management tools for a reason. You should find it a breeze to manage the databases on your server with its clear, intuitive interface.<\/p>\n","protected":false},"excerpt":{"rendered":"

PHPMyAdmin is a browser-based server administration tool used to create and manage databases such as MySQL using a visual interface. Its name comes from the fact that it is written in PHP. It was created in 1998 and is still the most popular browser-based server management tool. PHPMyAdmin is free and open source under the<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[61],"tags":[],"class_list":["post-2559","post","type-post","status-publish","format-standard","hentry","category-database"],"yoast_head":"\nHow to install PHPMyAdmin on Ubuntu 14 - Globo.Tech<\/title>\n<meta name=\"description\" content=\"This tutorial will show you how to install PHPMyAdmin on your Ubuntu 14 server. Read now & Try this browser-based server administration tool !\" \/>\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.globo.tech\/learning-center\/install-phpmyadmin-ubuntu-14\/\" \/>\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 14 - Globo.Tech\" \/>\n<meta property=\"og:description\" content=\"This tutorial will show you how to install PHPMyAdmin on your Ubuntu 14 server. Read now & Try this browser-based server administration tool !\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.globo.tech\/learning-center\/install-phpmyadmin-ubuntu-14\/\" \/>\n<meta property=\"og:site_name\" content=\"Globo.Tech\" \/>\n<meta property=\"article:published_time\" content=\"2016-08-24T18:48:03+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2016-10-06T03:27:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2016\/09\/GloboTech-Logo.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"963\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"GloboTech Communications\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"GloboTech Communications\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/install-phpmyadmin-ubuntu-14\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/install-phpmyadmin-ubuntu-14\\\/\"},\"author\":{\"name\":\"GloboTech Communications\",\"@id\":\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/#\\\/schema\\\/person\\\/e17784b37f4a4f49b7bc611847912e87\"},\"headline\":\"How to install PHPMyAdmin on Ubuntu 14\",\"datePublished\":\"2016-08-24T18:48:03+00:00\",\"dateModified\":\"2016-10-06T03:27:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/install-phpmyadmin-ubuntu-14\\\/\"},\"wordCount\":439,\"commentCount\":0,\"articleSection\":[\"Database\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/install-phpmyadmin-ubuntu-14\\\/\",\"url\":\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/install-phpmyadmin-ubuntu-14\\\/\",\"name\":\"How to install PHPMyAdmin on Ubuntu 14 - Globo.Tech\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/#website\"},\"datePublished\":\"2016-08-24T18:48:03+00:00\",\"dateModified\":\"2016-10-06T03:27:00+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/#\\\/schema\\\/person\\\/e17784b37f4a4f49b7bc611847912e87\"},\"description\":\"This tutorial will show you how to install PHPMyAdmin on your Ubuntu 14 server. Read now & Try this browser-based server administration tool !\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/install-phpmyadmin-ubuntu-14\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/install-phpmyadmin-ubuntu-14\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/install-phpmyadmin-ubuntu-14\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to install PHPMyAdmin on Ubuntu 14\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/#website\",\"url\":\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/\",\"name\":\"Globo.Tech\",\"description\":\"Welcome to the Official Globo.Tech Learning Center\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.globo.tech\\\/learning-center\\\/#\\\/schema\\\/person\\\/e17784b37f4a4f49b7bc611847912e87\",\"name\":\"GloboTech Communications\",\"sameAs\":[\"http:\\\/\\\/www.gtcomm.net\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to install PHPMyAdmin on Ubuntu 14 - Globo.Tech","description":"This tutorial will show you how to install PHPMyAdmin on your Ubuntu 14 server. Read now & Try this browser-based server administration tool !","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.globo.tech\/learning-center\/install-phpmyadmin-ubuntu-14\/","og_locale":"en_US","og_type":"article","og_title":"How to install PHPMyAdmin on Ubuntu 14 - Globo.Tech","og_description":"This tutorial will show you how to install PHPMyAdmin on your Ubuntu 14 server. Read now & Try this browser-based server administration tool !","og_url":"https:\/\/www.globo.tech\/learning-center\/install-phpmyadmin-ubuntu-14\/","og_site_name":"Globo.Tech","article_published_time":"2016-08-24T18:48:03+00:00","article_modified_time":"2016-10-06T03:27:00+00:00","og_image":[{"width":1920,"height":963,"url":"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2016\/09\/GloboTech-Logo.png","type":"image\/png"}],"author":"GloboTech Communications","twitter_misc":{"Written by":"GloboTech Communications","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.globo.tech\/learning-center\/install-phpmyadmin-ubuntu-14\/#article","isPartOf":{"@id":"https:\/\/www.globo.tech\/learning-center\/install-phpmyadmin-ubuntu-14\/"},"author":{"name":"GloboTech Communications","@id":"https:\/\/www.globo.tech\/learning-center\/#\/schema\/person\/e17784b37f4a4f49b7bc611847912e87"},"headline":"How to install PHPMyAdmin on Ubuntu 14","datePublished":"2016-08-24T18:48:03+00:00","dateModified":"2016-10-06T03:27:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.globo.tech\/learning-center\/install-phpmyadmin-ubuntu-14\/"},"wordCount":439,"commentCount":0,"articleSection":["Database"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.globo.tech\/learning-center\/install-phpmyadmin-ubuntu-14\/","url":"https:\/\/www.globo.tech\/learning-center\/install-phpmyadmin-ubuntu-14\/","name":"How to install PHPMyAdmin on Ubuntu 14 - Globo.Tech","isPartOf":{"@id":"https:\/\/www.globo.tech\/learning-center\/#website"},"datePublished":"2016-08-24T18:48:03+00:00","dateModified":"2016-10-06T03:27:00+00:00","author":{"@id":"https:\/\/www.globo.tech\/learning-center\/#\/schema\/person\/e17784b37f4a4f49b7bc611847912e87"},"description":"This tutorial will show you how to install PHPMyAdmin on your Ubuntu 14 server. Read now & Try this browser-based server administration tool !","breadcrumb":{"@id":"https:\/\/www.globo.tech\/learning-center\/install-phpmyadmin-ubuntu-14\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.globo.tech\/learning-center\/install-phpmyadmin-ubuntu-14\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.globo.tech\/learning-center\/install-phpmyadmin-ubuntu-14\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.globo.tech\/learning-center\/"},{"@type":"ListItem","position":2,"name":"How to install PHPMyAdmin on Ubuntu 14"}]},{"@type":"WebSite","@id":"https:\/\/www.globo.tech\/learning-center\/#website","url":"https:\/\/www.globo.tech\/learning-center\/","name":"Globo.Tech","description":"Welcome to the Official Globo.Tech Learning Center","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.globo.tech\/learning-center\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.globo.tech\/learning-center\/#\/schema\/person\/e17784b37f4a4f49b7bc611847912e87","name":"GloboTech Communications","sameAs":["http:\/\/www.gtcomm.net"]}]}},"_links":{"self":[{"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/posts\/2559","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/comments?post=2559"}],"version-history":[{"count":4,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/posts\/2559\/revisions"}],"predecessor-version":[{"id":3080,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/posts\/2559\/revisions\/3080"}],"wp:attachment":[{"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/media?parent=2559"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/categories?post=2559"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/tags?post=2559"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}