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

phpMyAdmin<\/a> is a free and open-source, web-based tool for managing the MySQL<\/a> and MariaDB<\/a> servers. It is widely used to manage the database by web hosting companies and administrators who are new to the database.<\/p>\n\n\n\n

phpMyAdmin helps the system administrator to perform databases activities such as creating, deleting, querying, database, tables, columns, etc.<\/p>\n\n\n\n

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

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

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

To install phpMyAdmin, your system must have a database instance running and Nginx web server<\/a>.<\/p>\n\n\n\n

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

Follow the below tutorials and prepare your system for setting up phpMyAdmin.<\/p>\n\n\n\n

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

Then,<\/p>\n\n\n\n

Step 2:<\/strong> How To Install LEMP Stack on Debian 10<\/a>You can skip the database part in Step 2 \u2013 LEMP stack tutorial if you have followed the Step 1 \u2013 MariaDB installation.<\/p>\n\n\n\n

Install PHP extensions for phpMyAdmin to connect with database.<\/p>\n\n\n\n

sudo apt install -y php-json php-mbstring<\/pre>\n\n\n\n
LEMP Stack<\/h4>\n\n\n\n
READ:<\/strong> How To Install LEMP Stack on Debian 10<\/a><\/p>\n\n\n\n
Install PHP extensions for phpMyAdmin to connect with database.<\/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
The phpMyAdmin is not available as Deb package in Debian OS repository for Debian 10. So, we will download the tarball 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 phpMyAdmin using the tar<\/code><\/a> 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 to your 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.<\/p>\n\n\n\n
sudo nano \/usr\/share\/phpMyAdmin\/config.inc.php<\/pre>\n\n\n\n
Generate a blowfish secret<\/a> and update the secret in the configuration file.<\/p>\n\n\n\n
$cfg['blowfish_secret'] = 'CfX1la\/aG83gx1{7rADus,iqz8RzeV8x<\/strong>'; \/* YOU MUST FILL IN THIS FOR COOKIE AUTH! *\/<\/pre>\n\n\n\n
Also, uncomment the phpMyAdmin storage settings.<\/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 a virtual host configuration file for phpMyAdmin (Ex. phpMyAdmin.conf) under the \/etc\/nginx\/conf.ddirectory.<\/p>\n\n\n\n
sudo nano \/etc\/nginx\/conf.d\/phpMyAdmin.conf<\/pre>\n\n\n\n
Use the following information to create a virtual host for phpMyAdmin. Change the domain name (server_name) as per your requirement.<\/p>\n\n\n\n
server {\n   listen 80;\n   server_name pma.itzgeek.local<\/strong>;\n   root \/usr\/share\/phpMyAdmin<\/strong>;\n\n   location \/ {\n      index index.php;\n   }\n\n## Images and static content is treated different\n   location ~* ^.+.(jpg|jpeg|gif|css|png|js|ico|xml)$ {\n      access_log off;\n      expires 30d;\n   }\n\n   location ~ \/\\.ht {\n      deny all;\n   }\n\n   location ~ \/(libraries|setup\/frames|setup\/libs) {\n      deny all;\n      return 404;\n   }\n\n   location ~ \\.php$ {\n      include \/etc\/nginx\/fastcgi_params;\n      fastcgi_pass 127.0.0.1:9000;\n      fastcgi_index index.php;\n      fastcgi_param SCRIPT_FILENAME \/usr\/share\/phpMyAdmin<\/strong>$fastcgi_script_name;\n   }\n}\n<\/pre>\n\n\n\n
Create a tmp directory for phpMyAdmin and then 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 services.<\/p>\n\n\n\n
sudo systemctl restart nginx \n\nsudo systemctl restart php7.3-fpm<\/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
Access the phpMyAdmin using the browser by going to the below URL.http:\/\/your-fully-qualified-domain-name<\/p>\n\n\n\n
Log in with database user we just created in the previous step.<\/p>\n\n\n\n
\"Install<\/a>
Install phpMyAdmin with Nginx on Debian 10 \u2013 Login to phpMyAdmin<\/figcaption><\/figure>\n\n\n\n
You will get the home page where you can manage databases.<\/p>\n\n\n\n
\"Install<\/a>
Install phpMyAdmin with Nginx on Debian 10 \u2013 phpMyAdmin<\/figcaption><\/figure>\n","protected":false},"excerpt":{"rendered":"
phpMyAdmin is a free and open-source, web-based tool for managing the MySQL and MariaDB servers. It is widely used to manage the database by web hosting companies and administrators who are new to the database. phpMyAdmin helps the system administrator to perform databases activities such as creating, deleting, querying, database, tables, columns, etc. In this post, we will see how […]<\/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-259","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\/259","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=259"}],"version-history":[{"count":1,"href":"https:\/\/xaxowareti.com.br\/index.php?rest_route=\/wp\/v2\/posts\/259\/revisions"}],"predecessor-version":[{"id":260,"href":"https:\/\/xaxowareti.com.br\/index.php?rest_route=\/wp\/v2\/posts\/259\/revisions\/260"}],"wp:attachment":[{"href":"https:\/\/xaxowareti.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=259"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xaxowareti.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=259"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xaxowareti.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=259"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}