{"id":3666,"date":"2019-07-18T18:08:38","date_gmt":"2019-07-18T15:08:38","guid":{"rendered":"https:\/\/kifarunix.com\/?p=3666"},"modified":"2019-07-18T18:08:39","modified_gmt":"2019-07-18T15:08:39","slug":"install-phpmyadmin-on-debian-10-buster","status":"publish","type":"post","link":"https:\/\/kifarunix.com\/install-phpmyadmin-on-debian-10-buster\/","title":{"rendered":"Install phpMyAdmin on Debian 10 Buster"},"content":{"rendered":"\n

In this guide, we are going to learn how to install phpMyAdmin on Debian 10 Buster. phpMyAdmin<\/a> is an opensource tool written in PHP for administering MySQL and MariaDB over the web.<\/p>\n\n\n\n

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

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

phpMyAdmin requires a web server, PHP and a database in order to operate. To meet the requirements, this guide uses LAMP stack.<\/p>\n\n\n\n

To install LAMP stack on Debian 10 Buster, follow the link below;<\/p>\n\n\n\n

Install LAMP Stack with MariaDB 10 on Debian 10 Buster<\/a><\/p>\n\n\n\n

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

There are a number of PHP extensions that are required by phpMyAdmin. However, most of these extensions installs with PHP itself. To install the additional extensions, execute the command below;<\/p>\n\n\n\n

apt install php-{mbstring,zip,gd,xml,pear,gettext,cgi}<\/code><\/pre>\n\n\n\n
Download Latest phpMyAdmin<\/h3>\n\n\n\n
Next step is to install phpMyAdmin on Debian 10 Buster. Therefore, navigate to the downloads page<\/a> and grab phpMyAdmin archive. phpMyAdmin 4.9.0.1 is the latest stable release as of this writing. You can simply use the wget<\/strong> command.<\/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 releases<\/h4>\n\n\n\n
Once you have downloaded phpMyAdmin archive, you should verify that the signature<\/a> matches the archive you have downloaded as shown below;<\/p>\n\n\n\n
Import the key <\/p>\n\n\n\n
gpg --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. The SHA256 has for the phpMyAdmin-4.9.0.1-english.tar.gz<\/code> is 6494e2172354a6621d0accf3445dcc3db3d17c4274fb5a94c9159590f6978bad<\/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 \n6494e2172354a6621d0accf3445dcc3db3d17c4274fb5a94c9159590f6978bad  phpMyAdmin-4.9.0.1-english.tar.gz<\/code><\/pre>\n\n\n\n
Great, the hashes match and we are good to proceed.<\/p>\n\n\n\n
Extract phpMyAdmin archive to your web server root directory. Since we are using Apache, the web root directory is \/var\/www\/html<\/strong>.<\/p>\n\n\n\n
mkdir \/var\/www\/html\/phpmyadmin\ntar 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;<\/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$VroYYmqJ1bsNvMD1OpTpqOKtLy6dewrUuiwXQOfrjWuz.x4Ko676S'; \/* YOU MUST FILL IN THIS FOR COOKIE AUTH! *\/\n\n\/**\n...<\/code><\/pre>\n\n\n\n
Set the permissions of the phpMyAdmin configuration file to 660<\/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, www-data<\/strong> if running Apache. 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 Web Server Service<\/h3>\n\n\n\n
Next, restart the web server. Apache is used in this guide.<\/p>\n\n\n\n
systemctl restart apache2<\/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, http:\/\/<server-IP>\/phpmyadmin.<\/strong><\/p>\n\n\n\n
\"Install<\/a><\/figure>\n\n\n\n
\"phpMyAdmin<\/a><\/figure>\n\n\n\n
There you go. phpMyAdmin is installed on Debian 10 Buster. Enjoy.<\/p>\n\n\n\n
Related Tutorials:<\/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":"
In this guide, we are going to learn how to install phpMyAdmin on Debian 10 Buster. phpMyAdmin is an opensource tool written in PHP for<\/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,121,928,929],"tags":[1039,135,281],"class_list":["post-3666","post","type-post","status-publish","format-standard","hentry","category-database","category-howtos","category-mariadb","category-mysql","tag-debian-10-buster","tag-mysql","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\/3666"}],"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=3666"}],"version-history":[{"count":4,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/posts\/3666\/revisions"}],"predecessor-version":[{"id":3675,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/posts\/3666\/revisions\/3675"}],"wp:attachment":[{"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/media?parent=3666"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/categories?post=3666"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kifarunix.com\/wp-json\/wp\/v2\/tags?post=3666"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}