Comments on Install and Secure phpMyAdmin on CentOS 8

phpMyAdmin is a free and open-source tool to manage MySQL and MariaDB servers over a web-based interface. In this tutorial, we will show you how to install and secure phpMyAdmin on CentOS 8 server.

21 Comment(s)

Add comment

Please register in our forum first to comment.

Comments

By: Claudiu

Hi, 

 

i've done everything like you said and i get this:

This page isn’t working

192.168.10.251 is currently unable to handle this request.

 

HTTP ERROR 500

Any suggestion?

 

By: Ya mama

You installed php-json twice ;)

By: Intra Daniele

Hi i have done all you mentioned before but when i'm trying to reach the page i get this:

Forbidden

You don't have permission to access /phpmyadmin/ on this server.

Please, help me.

Thanks, best regards

By: harish

very very thanks for share your knowledge

By: Fabio

i did this and work for me

install this packges

yum install -y wget php php-pdo php-pecl-zip php-json php-common php-fpm php-mbstring php-cli php-mysqlnd

 

By: Thomas

Great article.  Followed it to the T.  Got everything working except 1 thing.  That is securing the directory.  I've done everything as you instructed to in the article, but I am never asked for a username and password.  Almost as if the username and password requirement is being bypassed.  Any ideas?  CentOS8 Apache 2.4.

By: Darrell

In the example above '/usr/share/phpmyadmin' still needs a '.htaccess' file.

I moved the following  lines from the '/etc/httpd/conf.d/phpmyadmin.conf' to '/usr/share/phpmyadmin/.htaccess'

'AuthType basic'

'AuthName "Authentication Required"'    

'AuthUserFile /etc/phpmyadmin/.htpasswd'    

'Require valid-user'

Restart httpd and that worked for me.

By: Riccardo

Thanks a lot, you saved my life bro!

By: TAREQ

Thanks a lot, you saved my life bro! 

By: Shorece

Work instruction! Do everything according to the steps of the author and you will get the expected result. I struggled for a few days and had a bad result, it helped me. I set Centos 8 phpMyAdmin 5.0.2. Thanks a lot!

By: Joey

Hello. Is your problem solved? CentOS 8 here also and that's the only thing not working for me. If so can you share the fix please?

By: carlos

Thank's

By: Henrique

I followed the step by step and in the end, it worked correctly.Congratulations ... The only one that worked !!

By: rjr

 Awesome article.  Thank you.

By: DarkPizz

Forbidden

You don't have permission to access /phpmyadmin/setup/ on this server.

 

Alias /phpmyadmin /usr/share/phpmyadmin

 

<Directory /usr/share/phpmyadmin/>

   AddDefaultCharset UTF-8

 

   <IfModule mod_authz_core.c>

     # Apache 2.4

     <RequireAny> 

      Require all granted

     </RequireAny>

   </IfModule>

   <IfModule !mod_authz_core.c>

     # Apache 2.2

     Order Deny,Allow

     Deny from All

     Allow from 127.0.0.1

     Allow from ::1

   </IfModule>

</Directory>

 

<Directory /usr/share/phpmyadmin/setup/>

   <IfModule mod_authz_core.c>

     # Apache 2.4

     <RequireAny>

       Require all granted

     </RequireAny>

   </IfModule>

   <IfModule !mod_authz_core.c>

     # Apache 2.2

     Order Deny,Allow

     Deny from All

     Allow from 127.0.0.1

     Allow from ::1

   </IfModule>

</Directory>

By: eyoung

Change permissions on your .htpasswd file might help but I could be wrong:

chmod 640 /etc/phpmyadmin/.htpasswd

chgrp apache /etc/phpmyadmin/.htpasswd

By: IvJo

You are a genius!

Everything went smoothly!

Thank you!

By: OrangeJuicePirate

Very good! Thank you!

By: Stefan

Perfect guide! Works great.

By: yulia

Great !

thank you guy, it help me a lot

By: Beau Sanders

I have used these excellent instructions to install phpMyAdmin on two CentOS 8 Stream servers and it has worked perfectly. Thank you for your hard work on this how-to tutorial.

I am not familiar with why Red Hat has not made phpMyAdmin available in CentOS Stream. I hope that it is added in the near future.