In this article, we will have explained the necessary steps to install and configure phpMyAdmin on CentOS 8. Before continuing with this tutorial, make sure you are logged in as a user with sudo privileges. All the commands in this tutorial should be run as a non-root user.
phpMyAdmin is an open source, web based administration tool for managing the MySQL or 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.
Install phpMyAdmin on CentOS
Step 1. The first command will update the package lists to ensure you get the latest version and dependencies.
1 | sudodnfupdate |
Step 2. Install LAMP stack on Ubuntu.
It is assumed that you have already installed LAMP stack on CentOS system. If not, please check out the following tutorial.
Step 3. Install phpMyAdmin.
First, we are going to install phpMyAdmin by downloading the source tarball from phpMyAdmin downloads page:
1 2 | wgethttps://files.phpmyadmin.net/phpMyAdmin/4.9.2/phpMyAdmin-4.9.2-all-languages.tar.gz tar-zxvfphpMyAdmin-4.9.2-all-languages.tar.gz |
Move the phpMyAdmin set up to your desired location:
1 | mvphpMyAdmin-4.9.2-all-languages/usr/share/phpMyAdmin |
Step 4. Configure phpMyAdmin.
Now, we copy the sample configuration file:
1 | cp-pr/usr/share/phpMyAdmin/config.sample.inc.php/usr/share/phpMyAdmin/config.inc.php |
Then, edit the configuration file and add a blowfish secret:
1 | sudonano/usr/share/phpMyAdmin/config.inc.php |
1 | $cfg['blowfish_secret']='bo95yavJMYDECEMBERWmG98-6';/* YOU MUST FILL IN THIS FOR COOKIE AUTH! */ |
Next, import the create_tables.sql to create new tables for phpMyAdmin:
1 | mysql</usr/share/phpMyAdmin/sql/create_tables.sql-uroot-p |
Step 5. Configure Apache web Server.
Now, we create an alias in the Apache web server so that phpMyAdmin can be accessed with http://your-ip-add-dress/phpmyadmin:
1 | sudonano/etc/httpd/conf.d/phpMyAdmin.conf |
Add the below content to the above file:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 | Alias/phpMyAdmin/usr/share/phpMyAdmin Alias/phpmyadmin/usr/share/phpMyAdmin <Directory/usr/share/phpMyAdmin/> AddDefaultCharsetUTF-8 <IfModulemod_authz_core.c> # Apache 2.4 <RequireAny> Requireallgranted </RequireAny> </IfModule> <IfModule!mod_authz_core.c> # Apache 2.2 OrderDeny,Allow DenyfromAll Allowfrom127.0.0.1 Allowfrom::1 </IfModule> </Directory> <Directory/usr/share/phpMyAdmin/setup/> <IfModulemod_authz_core.c> # Apache 2.4 <RequireAny> Requireallgranted </RequireAny> </IfModule> <IfModule!mod_authz_core.c> # Apache 2.2 OrderDeny,Allow DenyfromAll Allowfrom127.0.0.1 Allowfrom::1 </IfModule> </Directory> |
Create a tmp directory for phpMyAdmin and change the permission:
1 2 | mkdir/usr/share/phpMyAdmin/tmp chmod777/usr/share/phpMyAdmin/tmp |
Also, set the ownership of phpMyAdmin:
1 | chown-Rapache:apache/usr/share/phpMyAdmin |
Then, restart Apache service:
1 | sudosystemctlrestarthttpd |
Step 6. Configure SELinux and Firewall.
Create SELinux policies for phpMyAdmin:
1 2 3 4 | yuminstall-ypolicycoreutils-python-utils semanagefcontext-a-thttpd_sys_rw_content_t'/usr/share/phpMyAdmin/' semanagefcontext-a-thttpd_sys_rw_content_t"/usr/share/phpMyAdmin/tmp(/.*)?" restorecon-Rv'/usr/share/phpMyAdmin/' |
Next, create a firewall rule to allow HTTP requests:
1 2 | firewall-cmd--permanent--add-service=http firewall-cmd--reload |
Step 7. Accessing phpMyAdmin.
You can now access your phpMyAdmin from the browser by navigating to browser and using the the address, http://your-ip-add-dress/phpmyadmin:
That’s all you need to do to install phpMyAdmin on CentOS 8. I hope you find this quick tip helpful. If you have questions or suggestions, feel free to leave a comment below.
