Before installing PHPMyAdmin, you need to have the following requisite packages installed.<\/p>\n
- \n
- PHP<\/li>\n
- Database Server(MySQL or MariaDB)<\/li>\n
- Apache Web server.<\/li>\n<\/ul>\n
Step 1: Install additional PHP modules<\/strong><\/h2>\n
The Current version of PhpMyAdmin is compatible with PHP 7.1 and later versions as well as MySQL\/MariaDB 5.5 and newer versions. You need to install PHP as well as the MySQL support package for PHP, and other necessary PHP packages for phpMyAdmin to function as expected on your CentOS \/ AlmaLinux system.<\/p>\n
Therefore, run the following command to install the necessary php packages required to utilize PHP with Apache and MySQL:<\/p>\n
$ sudo dnf -y install php php-fpm php-mysqlnd php-opcache php-gd php-xml php-mbstring php-zip<\/strong><\/pre>\n
Step 2: Install phpMyAdmin<\/strong><\/h2>\n
Once the dependencies have been installed, our system is now ready for the phpMyAdmin installation. phpMyAdmin is not available in the system\u2019s default repositories, and so you need to download the latest version of the phpMyAdmin archive from the official site. At the time of writing this guide, the current version of phpMyAdmin is 5.1.1<\/p>\n
Run the following wget command to download phpMyAdmin zip file:<\/p>\n
$ wget https:\/\/files.phpmyadmin.net\/phpMyAdmin\/5.1.1\/phpMyAdmin-5.1.1-all-languages.zip<\/strong><\/pre>\n
![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2021\/09\/word-image-400.png\")
<\/strong><\/p>\nAfter the download is complete, extract the packages as shown:<\/strong><\/p>\n
$ unzip phpMyAdmin-5.1.1-all-languages.zip<\/strong><\/pre>\n
Next, move phpMyAdmin to the usr\/share\/phpMyadmin<\/strong> directory.<\/p>\n
$ sudo mv phpMyAdmin-5.1.1-all-languages \/usr\/share\/phpMyAdmin<\/strong><\/pre>\n
Then, create a tmp<\/em> directory . Run:<\/p>\n
$ sudo mkdir -p \/usr\/share\/phpMyAdmin\/tmp<\/strong><\/pre>\n
Set the necessary permissions with the commands:<\/p>\n
$ sudo chown -R apache:apache \/usr\/share\/phpMyAdmin<\/strong><\/pre>\n
$ sudo chmod 777 \/usr\/share\/phpMyAdmin\/tmp<\/strong><\/pre>\n
![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2021\/09\/word-image-401.png\")
<\/strong><\/h2>\nStep 3: Configure Apache web server for phpMyAdmin<\/strong><\/h2>\n
In this step, we will configure the web server to serve phpMyAdmin on the network. First, let\u2019s create an Apache configuration file for phpMyAdmin.<\/p>\n
$ sudo vi \/etc\/httpd\/conf.d\/phpmyadmin.conf<\/strong><\/pre>\n
Paste the lines below to the apache configuration file. Here, we also create an alias that we will use to access phpMyAdmin.<\/p>\n
Alias \/phpmyadmin \/usr\/share\/phpMyAdmin<\/strong><\/pre>\n
<\/p>\n
<Directory \/usr\/share\/phpMyAdmin\/><\/strong>\r\n\r\n AddDefaultCharset UTF-8<\/strong>\r\n\r\n <IfModule mod_authz_core.c><\/strong>\r\n\r\n # Apache 2.4<\/strong>\r\n\r\n <RequireAny><\/strong>\r\n\r\n Require all granted<\/strong>\r\n\r\n <\/RequireAny><\/strong>\r\n\r\n <\/IfModule><\/strong>\r\n\r\n<\/Directory><\/strong>\r\n\r\n\r\n\r\n\r\n<Directory \/usr\/share\/phpMyAdmin\/setup\/><\/strong>\r\n\r\n <IfModule mod_authz_core.c><\/strong>\r\n\r\n# Apache 2.4<\/strong>\r\n\r\n <RequireAny><\/strong>\r\n\r\n Require all granted<\/strong>\r\n\r\n <\/RequireAny><\/strong>\r\n\r\n <\/IfModule><\/strong>\r\n\r\n<\/Directory><\/strong><\/pre>\n
Save and close the file.<\/p>\n
Step 4: Configure SELinux and Firewall<\/strong><\/h2>\n
For systems with SELinux enabled, run the following command to set correct permissions to allow SELinux policies.<\/p>\n
$ sudo chcon -Rv --type=httpd_sys_content_t \/usr\/share\/phpmyadmin\/*<\/strong><\/pre>\n
Finally, ensure to restart the Apache service for all the changes to take effect. Run:<\/p>\n
$ sudo systemctl restart httpd<\/strong><\/pre>\n
If you have enabled the firewall, you need to allow HTTP traffic. Run the following command to allow HTTP traffic:<\/p>\n
$ sudo firewall-cmd --permanent --add-service=http<\/strong><\/pre>\n
Next, reload the firewall after making these changes<\/p>\n
$ sudo firewall-cmd --reload<\/strong><\/pre>\n
Great! The only thing remaining is to access phpMyAdmin from a browser.<\/p>\n
Access phpMyAdmin<\/strong><\/pre>\n
Finally, let’s access the phpMyAdmin web portal. Open your web browser and access PHP my admin with the following address:<\/p>\n
$ <\/strong>http:\/\/your-server-ip\/phpMyAdmin<\/strong><\/a><\/pre>\n
The browser will now display the phpMyAdmin login page.<\/p>\n
Login with your MariaDB root credentials:<\/p>\n
![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2021\/09\/word-image-402.png\")
<\/p>\nsystemctl restart httpd.service<\/strong><\/pre>\n
You will be directed to the phpMyAdmin dashboard as provided.<\/p>\n
![](\"http:\/\/linuxways.net\/wp-content\/uploads\/2021\/09\/word-image-403.png\")
<\/strong><\/p>\nFrom here, you can create and manage all the databases conveniently without the need of running SQL queries.<\/p>\n
Conclusion<\/strong><\/h2>\n
You have successfully completed the installation and configuration of phpMyAdmin on CentOS 8\/AlmaLinux 8.<\/p>","protected":false},"excerpt":{"rendered":"
phpMyAdmin is an open-source, web-based administration tool written in PHP. It is a popular tool used for managing MySQL and MariaDB servers. It is used by system administrators…<\/p>","protected":false},"author":1,"featured_media":10325,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[444,93,257],"class_list":["post-10238","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-centos","tag-almalinux","tag-centos-8","tag-phpmyadmin"],"_links":{"self":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/posts\/10238","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/comments?post=10238"}],"version-history":[{"count":2,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/posts\/10238\/revisions"}],"predecessor-version":[{"id":10460,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/posts\/10238\/revisions\/10460"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/media\/10325"}],"wp:attachment":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/media?parent=10238"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/categories?post=10238"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/tags?post=10238"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}