Hello, friends. Fedora is popular among developers and computer students. So it’s good to learn how to install PHPMyAdmin on Fedora 34/33 for those who don’t know it.
PHPMyAdmin is an open-source application created in PHP that provides the administration of a MySQL or MariaDB database from a comfortable web interface. It is simply installed on the server, we make a few small configurations and that’s it. That’s it. Without consuming many resources you will have a quality application.
So, let’s get started.
Install PHPMyAdmin on Fedora 34/33
Fedora 33 is characterized by fairly comprehensive repositories. So we won’t have any problems installing it.
So, open a terminal and update Fedora 34/33.
sudo dnf update
After that, you can start the installation of PHPMyAdmin by running the following command
sudo dnf install phpMyAdmin
If you do not have a web server installed, the Apache web server will be installed during the process.
Therefore, we have to start and enable the Apache webserver to load along with the system.
sudo systemctl start httpd sudo systemctl enable httpd
After that, check the status of the service to see if everything is in order.
sudo systemctl status httpd
● httpd.service - The Apache HTTP Server
Loaded: loaded (/usr/lib/systemd/system/httpd.service; disabled; vendor preset: disabled)
Drop-In: /usr/lib/systemd/system/httpd.service.d
└─php-fpm.conf
Active: active (running) since Sat 2021-05-08 19:25:13 CEST; 5min ago
Docs: man:httpd.service(8)
Main PID: 2152 (httpd)
Status: "Total requests: 49; Idle/Busy workers 100/0;Requests/sec: 0.14; Bytes served/sec: 5.4KB/sec"
Tasks: 278 (limit: 2268)
Memory: 21.2M
CPU: 525ms
CGroup: /system.slice/httpd.service
├─2152 /usr/sbin/httpd -DFOREGROUND
├─2153 /usr/sbin/httpd -DFOREGROUND
├─2154 /usr/sbin/httpd -DFOREGROUND
├─2155 /usr/sbin/httpd -DFOREGROUND
├─2156 /usr/sbin/httpd -DFOREGROUND
└─2370 /usr/sbin/httpd -DFOREGROUND
May 08 19:25:13 osradar systemd[1]: Starting The Apache HTTP Server…
May 08 19:25:13 osradar httpd[2152]: AH00558: httpd: Could not reliably determine the server's fully qualified domain name, using ::1. Set the 'ServerName' directive gl>
May 08 19:25:13 osradar systemd[1]: Started The Apache HTTP Server.
May 08 19:25:13 osradar httpd[2152]: Server configured, listening on: port 80
So all is well. Also, remember that port 80 has to be open to accept connections even if it is from localhost and logically if PHPMyAdmin is installed on a server.
firewall-cmd --add-port=80/tcp --permanent Success firewall-cmd --add-port=443/tcp --permanent Success firewall-cmd --reload Success
Configuring PHPMyAdmin
If you have installed the application on your computer locally, you can open a web browser and access http://localhost/phpmyadmin to see the login screen.
But, if you have done this installation on a remote server, which can solve some problems, then you may want to make a prior adjustment to the Apache configuration file.
sudo nano /etc/httpd/conf.d/phpMyAdmin.conf
And change the <Directory /usr/share/phpMyAdmin> section to this one
<Directory /usr/share/phpMyAdmin>
AddDefaultCharset UTF-8
Require all granted
</Directory>
Save the changes and now you will be able to access from any computer via http://server/phpmyadmin
So, enjoy it.
Conclusion
PHPMyAdmin is a vital tool for many developers. It allows you to visualize MySQL or MariaDB data quickly through a well-designed graphical interface that does not consume many computer resources. Thanks to this post, you can enjoy the latest stable version of PHPMyAdmin on Fedora 34/ 33
