{"id":258,"date":"2019-08-14T09:10:43","date_gmt":"2019-08-14T12:10:43","guid":{"rendered":"http:\/\/xaxowareti.com.br\/?p=258"},"modified":"2019-08-14T09:10:43","modified_gmt":"2019-08-14T12:10:43","slug":"how-to-install-phpmyadmin-with-apache-on-debian-10","status":"publish","type":"post","link":"https:\/\/xaxowareti.com.br\/?p=258","title":{"rendered":"How To Install phpMyAdmin With Apache on Debian 10"},"content":{"rendered":"\n

phpMyAdmin<\/a> is an open-source, web-based administration tool for managing the MySQL<\/a> and MariaDB<\/a> database. It is written in PHP and is one of the most popular database administration tools used by web hosting companies to enable novice system administrators to carry out database activities.<\/p>\n\n\n\n

phpMyAdmin helps in performing database<\/a> activities such as creating, deleting, querying, tables, columns, relations, indexes, users, permissions, etc. It is released under GNU GPL v2.<\/p>\n\n\n\n

In this post, we will see how to install phpMyAdmin<\/a> with Apache on Debian 10<\/a>.<\/p>\n\n\n\n

Prerequisites<\/h2>\n\n\n\n

Install MySQL \/ MariaDB Server<\/h3>\n\n\n\n

Before installing phpMyAdmin, install a database instance on your system to connect. You could install it as a standalone database or install as part of the LAMP stack<\/a>.<\/p>\n\n\n\n

Install the database and then required packages shown below.<\/p>\n\n\n\n

Standalone Database<\/h4>\n\n\n\n

READ:<\/strong> How To Install MariaDB on Debian 10<\/a><\/p>\n\n\n\n

sudo apt install -y apache2 apache2-utils php libapache2-mod-php php-pdo php-zip php-json php-common php-fpm php-mbstring php-cli php-mysql<\/pre>\n\n\n\n
LAMP Stack<\/h4>\n\n\n\n
READ:<\/strong> How To Install LAMP Stack on Debian 10<\/a><\/p>\n\n\n\n
sudo apt install -y php-json php-mbstring<\/pre>\n\n\n\n
Install phpMyAdmin<\/h2>\n\n\n\n
phpMyAdmin package is not yet available in Debian repository for Debian 10. So, we need to download the tar package from the official website<\/a>.<\/p>\n\n\n\n
wget https:\/\/files.phpmyadmin.net\/phpMyAdmin\/4.9.0.1\/phpMyAdmin-4.9.0.1-all-languages.tar.gz<\/pre>\n\n\n\n
Extract the phpMyAdmin tarball using the following command.<\/p>\n\n\n\n
tar -zxvf phpMyAdmin-4.9.0.1-all-languages.tar.gz<\/pre>\n\n\n\n
Move the phpMyAdmin set up to the desired location.<\/p>\n\n\n\n
sudo mv phpMyAdmin-4.9.0.1-all-languages \/usr\/share\/phpMyAdmin<\/pre>\n\n\n\n
Configure phpMyAdmin<\/h2>\n\n\n\n
Copy the sample configuration file.<\/p>\n\n\n\n
sudo cp -pr \/usr\/share\/phpMyAdmin\/config.sample.inc.php \/usr\/share\/phpMyAdmin\/config.inc.php<\/pre>\n\n\n\n
Edit the configuration file and add a blowfish secret.<\/p>\n\n\n\n
sudo nano \/usr\/share\/phpMyAdmin\/config.inc.php<\/pre>\n\n\n\n
Generate blowfish secret<\/a> and then place it into the below line.<\/p>\n\n\n\n
$cfg['blowfish_secret'] = '2O:.uw6-8;Oi9R=3W{tO;\/QtZ]4OG:T:<\/strong>'; \/* YOU MUST FILL IN THIS FOR COOKIE AUTH! *\/<\/pre>\n\n\n\n
Also, uncomment the phpMyAdmin storage settings shown like below.<\/p>\n\n\n\n
\/**\n * phpMyAdmin configuration storage settings.\n *\/\n\n\/* User used to manipulate with storage *\/\n$cfg['Servers'][$i]['controlhost'] = 'localhost';\n\/\/ $cfg['Servers'][$i]['controlport'] = '';\n$cfg['Servers'][$i]['controluser'] = 'pma';\n$cfg['Servers'][$i]['controlpass'] = 'pmapass';\n\n\/* Storage database and tables *\/\n$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';\n$cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';\n$cfg['Servers'][$i]['relation'] = 'pma__relation';\n$cfg['Servers'][$i]['table_info'] = 'pma__table_info';\n$cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';\n$cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';\n$cfg['Servers'][$i]['column_info'] = 'pma__column_info';\n$cfg['Servers'][$i]['history'] = 'pma__history';\n$cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';\n$cfg['Servers'][$i]['tracking'] = 'pma__tracking';\n$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';\n$cfg['Servers'][$i]['recent'] = 'pma__recent';\n$cfg['Servers'][$i]['favorite'] = 'pma__favorite';\n$cfg['Servers'][$i]['users'] = 'pma__users';\n$cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';\n$cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';\n$cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';\n$cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';\n$cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings';\n$cfg['Servers'][$i]['export_templates'] = 'pma__export_templates';\n<\/pre>\n\n\n\n
Credit:<\/strong> TECHIES WORLD<\/a><\/p>\n\n\n\n
Import the create_tables.sql to create tables for phpMyAdmin.<\/p>\n\n\n\n
sudo mysql < \/usr\/share\/phpMyAdmin\/sql\/create_tables.sql -u root -p<\/pre>\n\n\n\n
Login to MariaDB.<\/p>\n\n\n\n
sudo mysql -u root -p<\/pre>\n\n\n\n
Add the user and grant permission to phpMyAdmin\u2019s database.<\/p>\n\n\n\n
GRANT ALL PRIVILEGES ON phpmyadmin.* TO 'pma'@'localhost' IDENTIFIED BY 'pmapass';\n\nFLUSH PRIVILEGES;<\/pre>\n\n\n\n
Create an alias in Apache web server to access phpMyAdmin with http:\/\/your-ip-add-dress\/phpmyadmin.<\/p>\n\n\n\n
sudo nano \/etc\/apache2\/sites-available\/phpmyadmin.conf<\/pre>\n\n\n\n
Copy and paste the below content into the above file.<\/p>\n\n\n\n
Alias \/phpMyAdmin \/usr\/share\/phpMyAdmin\nAlias \/phpmyadmin \/usr\/share\/phpMyAdmin\n\n<Directory \/usr\/share\/phpMyAdmin\/>\n   AddDefaultCharset UTF-8\n\n   <IfModule mod_authz_core.c>\n     # Apache 2.4\n     <RequireAny> \n      Require all granted\n     <\/RequireAny>\n   <\/IfModule>\n   <IfModule !mod_authz_core.c>\n     # Apache 2.2\n     Order Deny,Allow\n     Deny from All\n     Allow from 127.0.0.1\n     Allow from ::1\n   <\/IfModule>\n<\/Directory>\n\n<Directory \/usr\/share\/phpMyAdmin\/setup\/>\n   <IfModule mod_authz_core.c>\n     # Apache 2.4\n     <RequireAny>\n       Require all granted\n     <\/RequireAny>\n   <\/IfModule>\n   <IfModule !mod_authz_core.c>\n     # Apache 2.2\n     Order Deny,Allow\n     Deny from All\n     Allow from 127.0.0.1\n     Allow from ::1\n   <\/IfModule>\n<\/Directory><\/pre>\n\n\n\n
Enable the virtual host with the below command.<\/p>\n\n\n\n
sudo a2ensite phpmyadmin<\/pre>\n\n\n\n
Create the tmp directory for phpMyAdmin and change the permission.<\/p>\n\n\n\n
sudo mkdir \/usr\/share\/phpMyAdmin\/tmp\n\nsudo chmod 777 \/usr\/share\/phpMyAdmin\/tmp<\/pre>\n\n\n\n
Set the ownership of phpMyAdmin directory.<\/p>\n\n\n\n
sudo chown -R www-data:www-data \/usr\/share\/phpMyAdmin<\/pre>\n\n\n\n
Restart the Apache web service.<\/p>\n\n\n\n
sudo systemctl restart apache2<\/pre>\n\n\n\n
Create DB & User<\/h2>\n\n\n\n
By default, MariaDB root user is allowed to log in locally via Unix socket. So, we will now create a database user and login to phpMyAdmin with that user.<\/p>\n\n\n\n
CREATE DATABASE app_db;\n\nGRANT ALL PRIVILEGES ON app_db.* TO 'app_user'@'localhost' IDENTIFIED BY 'password';\n\nFLUSH PRIVILEGES;\n\nEXIT;\n<\/pre>\n\n\n\n
If required, you can disable Unix socket authentication and enable native password login<\/a>.<\/p>\n\n\n\n
Access phpMyAdmin<\/h2>\n\n\n\n
Now, access the phpMyAdmin interface using the browser. The URL will be:http:\/\/localhost\/phpMyAdmin<\/p>\n\n\n\n
OR<\/strong>http:\/\/your-ip-addr-ess\/phpMyAdmin<\/p>\n\n\n\n
Log in with the database user we created in the previous step.<\/strong><\/p>\n\n\n\n
\"Install<\/a>
Install phpMyAdmin on Debian 10 \u2013 phpMyAdmin Login Page<\/figcaption><\/figure>\n\n\n\n
You will get the below page where you can perform all database activities.<\/p>\n\n\n","protected":false},"excerpt":{"rendered":"
phpMyAdmin is an open-source, web-based administration tool for managing the MySQL and MariaDB database. It is written in PHP and is one of the most popular database administration tools used by web hosting companies to enable novice system administrators to carry out database activities. phpMyAdmin helps in performing database activities such as creating, deleting, querying, tables, columns, relations, indexes, users, permissions, etc. […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-258","post","type-post","status-publish","format-standard","hentry","category-sem-categoria"],"_links":{"self":[{"href":"https:\/\/xaxowareti.com.br\/index.php?rest_route=\/wp\/v2\/posts\/258","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xaxowareti.com.br\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xaxowareti.com.br\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xaxowareti.com.br\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xaxowareti.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=258"}],"version-history":[{"count":1,"href":"https:\/\/xaxowareti.com.br\/index.php?rest_route=\/wp\/v2\/posts\/258\/revisions"}],"predecessor-version":[{"id":261,"href":"https:\/\/xaxowareti.com.br\/index.php?rest_route=\/wp\/v2\/posts\/258\/revisions\/261"}],"wp:attachment":[{"href":"https:\/\/xaxowareti.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=258"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xaxowareti.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=258"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xaxowareti.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=258"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}