CentOS Stream 10

How To Install phpMyAdmin With Apache on CentOS Stream 10

To install phpMyAdmin on CentOS Stream 10 with Apache, follow these simple steps.

Step 1 : Before installing anything, update your system packages to the latest versions:

sudo dnf update -y

Step 2 : Navigate to your home directory and download the latest phpMyAdmin package:

cd ~/
wget https://www.phpmyadmin.net/downloads/phpMyAdmin-latest-all-languages.zip

Step 3 : Unzip the downloaded package and move it to the web server directory:

unzip phpMyAdmin-latest-all-languages.zip
sudo mv phpMyAdmin-*-all-languages /usr/share/phpMyAdmin

Step 4 : Ensure proper ownership and permissions for the phpMyAdmin directory:

sudo chown -R apache:apache /usr/share/phpMyAdmin
sudo chmod -R 755 /usr/share/phpMyAdmin

Step 5 : If SELinux is enabled on your system, adjust its policies to allow phpMyAdmin to function properly

sudo semanage fcontext -a -t httpd_sys_rw_content_t "/usr/share/phpMyAdmin(/.*)?"
sudo restorecon -Rv /usr/share/phpMyAdmin

Step 6 : Create a configuration file for phpMyAdmin under Apache:

sudo nano /etc/httpd/conf.d/phpMyAdmin.conf

Add the following configuration:

Alias /phpMyAdmin /usr/share/phpMyAdmin
Alias /phpmyadmin /usr/share/phpMyAdmin


<Directory /usr/share/phpMyAdmin/>
   AddDefaultCharset UTF-8


   Require all granted
</Directory>


<Directory /usr/share/phpMyAdmin/setup/>
   Require local
</Directory>


<Directory /usr/share/phpMyAdmin/libraries/>
    Require all denied
</Directory>


<Directory /usr/share/phpMyAdmin/templates/>
    Require all denied
</Directory>


<Directory /usr/share/phpMyAdmin/setup/lib/>
    Require all denied
</Directory>


<Directory /usr/share/phpMyAdmin/setup/frames/>
    Require all denied
</Directory>

Save and close the file.

Step 7 : Apply the changes by restarting the Apache service:

sudo systemctl restart httpd

Step 8 : Open your web browser and navigate to:

http://<your_server_IP>/phpMyAdmin

You should see the phpMyAdmin login page. Enter your MySQL credentials to log in.

Congratulations! You have successfully installed and configured phpMyAdmin on CentOS Stream 10 with Apache.