{"id":3710,"date":"2019-07-20T10:20:22","date_gmt":"2019-07-20T07:20:22","guid":{"rendered":"https:\/\/kifarunix.com\/?p=3710"},"modified":"2019-07-20T10:20:23","modified_gmt":"2019-07-20T07:20:23","slug":"install-phpmyadmin-with-nginx-on-debian-10-buster","status":"publish","type":"post","link":"https:\/\/kifarunix.com\/install-phpmyadmin-with-nginx-on-debian-10-buster\/","title":{"rendered":"Install phpMyAdmin with Nginx on Debian 10 Buster"},"content":{"rendered":"\n

Let us learn how to install phpMyAdmin with Nginx on Debian 10 Buster. phpMyAdmin<\/a>\u00a0is used to administer MySQL and MariaDB over the web.<\/p>\n\n\n\n

Install phpMyAdmin with Nginx on Debian 10 Buster<\/h2>\n\n\n\n

Prerequisites<\/h3>\n\n\n\n

Install LEMP Stack on Debian 10 Buster<\/h4>\n\n\n\n

As a prerequisite of running phpMyAdmin with Nginx, you need to have installed and setup LEMP Stack on Debian 10 Buster. If you have not, you can follow the link below to setup LEMP stack on Debian 10.<\/p>\n\n\n\n

Install LEMP Stack on Debian 10 Buster<\/a><\/p>\n\n\n\n

Installing PHP Extensions<\/h4>\n\n\n\n

Run the command below to install the additional PHP extensions<\/p>\n\n\n\n

apt install php-{mbstring,zip,gd,xml,pear,gettext,cgi}<\/code><\/pre>\n\n\n\n
Download phpMyAdmin Archive<\/h4>\n\n\n\n
To install the latest and stable release version of phpMyAdmin, navigate to the phpMyAdmin downloads page<\/a> and download it. As of this writing, the latest stable phpMyAdmin release is phpMyAdmin 4.9.0.1<\/strong>. You can simply use the\u00a0wget<\/strong>\u00a0command to download it<\/p>\n\n\n\n
wget https:\/\/files.phpmyadmin.net\/phpMyAdmin\/4.9.0.1\/phpMyAdmin-4.9.0.1-english.tar.gz<\/code><\/pre>\n\n\n\n
Verifying phpMyAdmin Archive<\/h4>\n\n\n\n
Once you have downloaded phpMyAdmin archive, you should\u00a0verify that the signature<\/a> matches the archive you have downloaded as shown below;<\/p>\n\n\n\n
Import the PGP key<\/p>\n\n\n\n
apt install gpg\ngpg --keyserver hkp:\/\/pgp.mit.edu --recv-keys 3D06A59ECE730EB71B511C17CE752F178259BD92<\/code><\/pre>\n\n\n\n
Download the phpMyAdmin archive PGP signature.<\/p>\n\n\n\n
wget https:\/\/files.phpmyadmin.net\/phpMyAdmin\/4.9.0.1\/phpMyAdmin-4.9.0.1-english.tar.gz.asc<\/code><\/pre>\n\n\n\n
Verify the signature:<\/p>\n\n\n\n
gpg --verify phpMyAdmin-4.9.0.1-english.tar.gz.asc<\/code><\/pre>\n\n\n\n
gpg: assuming signed data in 'phpMyAdmin-4.9.0.1-english.tar.gz'\ngpg: Signature made Tue 04 Jun 2019 12:08:42 PM EDT\ngpg:                using RSA key 3D06A59ECE730EB71B511C17CE752F178259BD92\ngpg: Good signature from \"Isaac Bennetch <bennetch@gmail.com>\" [unknown]\ngpg:                 aka \"Isaac Bennetch <isaac@bennetch.org>\" [unknown]\ngpg: WARNING: This key is not certified with a trusted signature!\ngpg:          There is no indication that the signature belongs to the owner.\nPrimary key fingerprint: 3D06 A59E CE73 0EB7 1B51  1C17 CE75 2F17 8259 BD92<\/code><\/pre>\n\n\n\n
You can verify the checksums too to confirm the integrity of the downloaded archive. The SHA256 has for the\u00a0phpMyAdmin-4.9.0.1-english.tar.gz<\/code>\u00a0is\u00a06494e2172354a6621d0accf3445dcc3db3d17c4274fb5a94c9159590f6978bad<\/strong>. To check the SHA256 for the downloaded file, run the command below;<\/p>\n\n\n\n
sha256sum phpMyAdmin-4.9.0.1-english.tar.gz<\/code><\/pre>\n\n\n\n
6494e2172354a6621d0accf3445dcc3db3d17c4274fb5a94c9159590f6978bad  phpMyAdmin-4.9.0.1-english.tar.gz<\/code><\/pre>\n\n\n\n
Integrity is confirmed to be intact.<\/p>\n\n\n\n
Next, extract phpMyAdmin archive to your web server root directory,\u00a0\/var\/www\/html<\/strong>.<\/p>\n\n\n\n
mkdir \/var\/www\/html\/phpmyadmin<\/code><\/pre>\n\n\n\n
tar xzf phpMyAdmin-4.9.0.1-english.tar.gz --strip-components=1 -C \/var\/www\/html\/phpmyadmin<\/code><\/pre>\n\n\n\n
Configure phpMyAdmin<\/h3>\n\n\n\n
Copy the sample phpMyAdmin configuration file and rename it as follows;<\/p>\n\n\n\n
cp \/var\/www\/html\/phpmyadmin\/config{.sample,}.inc.php<\/code><\/pre>\n\n\n\n
You should now have the phpMyAdmin configuration file.<\/p>\n\n\n\n
\/var\/www\/html\/phpmyadmin\/config.inc.php<\/code><\/pre>\n\n\n\n
Next, open the configuration file and create a blowfish secret required for cookie based authentication to encrypt password in cookie. You can generate the secret from Blowfish hash password generator<\/a> and paste as follows.<\/p>\n\n\n\n
vim \/var\/www\/html\/phpmyadmin\/config.inc.php<\/code><\/pre>\n\n\n\n
...\n\/**\n * This is needed for cookie based authentication to encrypt password in\n * cookie. Needs to be 32 chars long.\n *\/\n$cfg['blowfish_secret'] = '$2a$07$EJooQ7FWQIpYWJAMqd0mq.eRnrTTAkqpIwEv1InrJ8q0KMfAK0WLi'; \/* YOU MUST FILL IN THIS FOR COOKIE AUTH! *\/\n\n\/**\n...<\/code><\/pre>\n\n\n\n
These are just the basic configurations required to get us started.<\/p>\n\n\n\n
Set the permissions of the phpMyAdmin configuration file to\u00a0660<\/strong>.<\/p>\n\n\n\n
chmod 660 \/var\/www\/html\/phpmyadmin\/config.inc.php<\/code><\/pre>\n\n\n\n
Set the user and group ownership of the phpMyAdmin files to the web server user,\u00a0www-data<\/strong>. If you however have a dedicated user for running phpMyAdmin, then set the user ownership to that user and group ownership to the web server user.<\/p>\n\n\n\n
chown -R www-data:www-data \/var\/www\/html\/phpmyadmin<\/code><\/pre>\n\n\n\n
Restart Nginx<\/h3>\n\n\n\n
systemctl restart nginx<\/code><\/pre>\n\n\n\n
Accessing phpMyAdmin<\/h3>\n\n\n\n
Navigate to your browser and enter the IP address of your phpMyAdmin server,\u00a0http:\/\/<server-IP>\/phpmyadmin.<\/strong><\/p>\n\n\n\n
\"Install<\/a><\/figure>\n\n\n\n
When you logged in, you will land on the phpMyAdmin dashboard.<\/p>\n\n\n\n
\"Install<\/a><\/figure>\n\n\n\n
That is it on how to install phpMyAdmin with Nginx on Debian 10 Buster. You can now go ahead and manage your MariaDB\/MySQL databases.<\/p>\n\n\n\n
Other phpMyAdmin Installations;<\/p>\n\n\n\n
Install phpMyAdmin with Apache on Debian 10 Buster<\/a><\/p>\n\n\n\n
Install phpMyAdmin with Nginx on Fedora 30<\/a><\/p>\n\n\n\n
Install phpMyAdmin with Apache on Fedora 30<\/a><\/p>\n\n\n\n
Install phpMyAdmin with Nginx on FreeBSD 12<\/a><\/p>\n\n\n\n
How to Install phpMyAdmin on FreeBSD 12<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Let us learn how to install phpMyAdmin with Nginx on Debian 10 Buster. phpMyAdmin\u00a0is used to administer MySQL and MariaDB over the web. Install phpMyAdmin<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_lock_modified_date":false,"footnotes":""},"categories":[299,928,929,938],"tags":[1000,1039,136,135,229,281],"class_list":["post-3710","post","type-post","status-publish","format-standard","hentry","category-database","category-mariadb","category-mysql","category-phpmyadmin","tag-database","tag-debian-10-buster","tag-mariadb","tag-mysql","tag-nginx","tag-phpmyadmin","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-50"],"_links":{"self":[{"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/posts\/3710"}],"collection":[{"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/comments?post=3710"}],"version-history":[{"count":2,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/posts\/3710\/revisions"}],"predecessor-version":[{"id":3716,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/posts\/3710\/revisions\/3716"}],"wp:attachment":[{"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/media?parent=3710"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/categories?post=3710"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/tags?post=3710"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}