{"id":6464,"date":"2024-11-19T13:56:12","date_gmt":"2024-11-19T13:56:12","guid":{"rendered":"https:\/\/www.how2shout.com\/linux\/?p=6464"},"modified":"2024-11-19T16:25:17","modified_gmt":"2024-11-19T16:25:17","slug":"install-phpmyadmin-on-almalinux-8-with-apache","status":"publish","type":"post","link":"https:\/\/linux.how2shout.com\/install-phpmyadmin-on-almalinux-8-with-apache\/","title":{"rendered":"Install phpMyAdmin\u00a0on AlmaLinux 9 or 8 with Apache"},"content":{"rendered":"\n

Manage your local or remote MySQL & MariaDB database using the graphical user interface of PHPMyAdmin. Here, we let you know the steps and commands that we can use to install and step up PHPMyAdmin on AlamLinux 9 or 8<\/p>\n\n\n\n

 <\/p>\n\n\n\n

Steps to install phpMyAdmin on AlmaLinux 9 with Apache<\/h2>\n\n\n\n

Here, we install phpMyAdmin using the popular web server platform Apache, and of course, the PHP & MySQL database will also be there. This tutorial can also be used for Rocky Linux, CentOS, and RHEL 9 or 8 versions.<\/p>\n\n\n\n

1. Install Apache, PHP, and MySQL<\/h3>\n\n\n\n

PhpMyAdmin requires an Apache web server so that we can access it using a browser. As it is written using PHP, all the PHP, including the MySQL database, must be on the server.<\/p>\n\n\n\n

If you have these three things, then move forward. Otherwise, first, install them using our tutorial on installing the LAMP server on AlmaLinux<\/a>\u00a09<\/a>\u00a0or <\/span>Almalinux 8<\/span>.<\/a><\/p>\n\n\n\n

 <\/p>\n\n\n\n

2. Download phpMyAdmin files<\/h3>\n\n\n\n

The file we require to install and set up this GUI MySQL Database management is neither available in AlmaLinux’s base repo nor EPEL. Hence, we have to download it manually from its website. Visit the download page,<\/strong><\/a> right-click on the latest version,<\/span> and copy the link.<\/p>\n\n\n\n

Note<\/strong>: The latest version used for this tutorial was 5.2.1,<\/strong> which may differ in your case.<\/span><\/p>\n\n\n\n

\"Download<\/a><\/figure>\n\n\n\n

<\/p>\n\n\n\n

After that, type wget<\/strong>  in your command terminal of AlmaLinux and paste the link after it, as shown in the below example:<\/p>\n\n\n\n

wget<\/strong> https:\/\/files.phpmyadmin.net\/phpMyAdmin\/5.1.1\/phpMyAdmin-5.2.1-all-languages.zip<\/code><\/pre>\n\n\n\n
 <\/p>\n\n\n\n
3. Extract the zip and configure phpMyAdmin on AlmaLinux 9 or 8<\/h3>\n\n\n\n
Now that we have the zipped file of the phpMyAdmin, it’s time to extract and perform the necessary changes to make it work.<\/p>\n\n\n\n
1. Install unzip<\/h4>\n\n\n\n
sudo dnf install unzip<\/code><\/pre>\n\n\n\n
 <\/p>\n\n\n\n
2. Extract file<\/h4>\n\n\n\n
unzip phpMyAdmin-*-all-languages.zip<\/code><\/pre>\n\n\n\n
 <\/p>\n\n\n\n
3. Move the extracted files to \/usr\/share\/phpmyadmin<\/code><\/h4>\n\n\n\n
sudo mv phpMyAdmin-*-all-languages \/usr\/share\/phpmyadmin<\/code><\/pre>\n\n\n\n
 <\/p>\n\n\n\n
4. Create config.inc.php<\/h4>\n\n\n\n
The sample configuration file for phpMyAdmin is already there; we need to rename it:<\/p>\n\n\n\n
Please switch to the directory where we have moved the extracted  file in the previous step<\/em><\/p>\n\n\n\n
cd \/usr\/share\/phpmyadmin<\/code><\/pre>\n\n\n\n
Rename the sample configuration file:<\/em><\/p>\n\n\n\n
sudo mv config.sample.inc.php config.inc.php<\/code><\/pre>\n\n\n\n
 <\/p>\n\n\n\n
5. Generate a 32-bit Secret string<\/h4>\n\n\n\n
Enter the command below to get a long string of 32 numbers.<\/p>\n\n\n\n
openssl rand -base64 32<\/code><\/pre>\n\n\n\n
Copy the string and move to the next step.<\/p>\n\n\n\n
\"Command<\/a><\/figure>\n\n\n\n
 <\/p>\n\n\n\n
6. Edit Configuration file<\/h4>\n\n\n\n
Now edit the configuration file that you have renamed:<\/p>\n\n\n\n
sudo dnf install nano -y<\/code><\/pre>\n\n\n\n
sudo nano config.inc.php<\/code><\/pre>\n\n\n\n
 <\/p>\n\n\n\n
7. Set the blowfish_secret string and temp directory for phpMyAdmin<\/h4>\n\n\n\n
In the configuration, go to the following line:<\/p>\n\n\n\n
$cfg<\/span>['blowfish_secret<\/span>'] = '';<\/code><\/pre>\n\n\n\n
Now, add your copied string between the colons, as shown in the screenshot:<\/p>\n\n\n\n
$cfg<\/span>['blowfish_secret<\/span>'] = 'yourgeneratedstring<\/span>';<\/code><\/pre>\n\n\n\n
 <\/p>\n\n\n\n
\"Generate<\/a><\/figure>\n\n\n\n
<\/p>\n\n\n\n
Next, scroll down to the “* Directories for saving\/loading files from server<\/strong>” area in the same configuration file and add the following line:<\/p>\n\n\n\n
$cfg['TempDir'] = '\/tmp';<\/code><\/pre>\n\n\n\n
Save the file by pressing Ctrl+X<\/strong> and then typing- Y;<\/strong> after that, hit the Enter<\/strong> key.<\/span><\/p>\n\n\n\n
Note<\/strong>: if you do not declare the above temp directory in the file, you will have an error- The $cfg[‘TempDir’] (\/usr\/share\/phpmyadmin\/tmp\/) is not accessible<\/em><\/p>\n\n\n\n
\"temp<\/a><\/figure>\n\n\n\n
<\/p>\n\n\n\n
 <\/p>\n\n\n\n
8. Create a Temporary directory and assign its permission<\/h4>\n\n\n\n
This Temp folder, which we have created and also declared in the configuration file above, is used to store cache files, which helps PHPMyAdmin to perform better.<\/p>\n\n\n\n
sudo mkdir \/usr\/share\/phpmyadmin\/tmp\nsudo chown -R apache:apache \/usr\/share\/phpmyadmin\nsudo chmod 777 \/usr\/share\/phpmyadmin\/tmp<\/code><\/pre>\n\n\n\n
 <\/p>\n\n\n\n
4. Create an Apache configuration file for phpMyAdmin<\/h3>\n\n\n\n
We need to tell our Apache where the phpMyAdmin files are located and how to serve them over the browser when someone calls for it. For this purpose, we create a dedicated Apache configuration file.<\/p>\n\n\n\n
sudo nano \/etc\/httpd\/conf.d\/phpmyadmin.conf<\/code><\/pre>\n\n\n\n
Copy-paste the below-given code in it:<\/strong><\/p>\n\n\n\n
Save the file by pressing Ctrl+X.<\/strong> To confirm, press Y<\/strong> and hit the Enter<\/strong> key<\/span><\/p>\n\n\n\n
Alias \/phpmyadmin \/usr\/share\/phpmyadmin\n\n<Directory \/usr\/share\/phpmyadmin\/>\n   AddDefaultCharset UTF-8\n   <IfModule mod_authz_core.c>\n     <RequireAny>\n      Require all granted\n     <\/RequireAny>\n   <\/IfModule>\n<\/Directory>\n\n<Directory \/usr\/share\/phpmyadmin\/setup\/>\n   <IfModule mod_authz_core.c>\n     <RequireAny>\n       Require all granted\n     <\/RequireAny>\n   <\/IfModule>\n<\/Directory><\/code><\/pre>\n\n\n\n
 <\/p>\n\n\n\n
<\/p>\n\n\n\n
5. Set proper permission for SELinux policies (optional)<\/h3>\n\n\n\n
If your system has an enabled SELinux, run the command below to set the appropriate permission for SELinux policies so we can access this GUI app without limitation.<\/p>\n\n\n\n
sudo chcon -Rv --type=httpd_sys_content_t \/usr\/share\/phpmyadmin\/*<\/code><\/pre>\n\n\n\n
 <\/p>\n\n\n\n
6. Restart Apache on AlmaLinux 9 or 8<\/h3>\n\n\n\n
To let the Apache webserver recognize the changes made, restart its services once.<\/p>\n\n\n\n
sudo systemctl restart httpd.service<\/code><\/pre>\n\n\n\n
 <\/p>\n\n\n\n
7. Access phpMyAdmin Web interface<\/h3>\n\n\n\n
Now, open a system’s browser to access the Server IP address or domain where you have installed phpMyAdmin.<\/p>\n\n\n\n
And point it to :<\/strong><\/p>\n\n\n\n
http:\/\/your-server-ip-address\/phpmyadmin\nor\nhttp:\/\/your-domain.com\/phpmyadmin<\/pre>\n\n\n\n
Enter the username and password of your MySQL root user to access all the databases.<\/strong><\/p>\n\n\n\n
\"phpMyAdmin<\/a><\/figure>\n\n\n\n
\"Install<\/a><\/figure>\n\n\n\n
<\/p>\n\n\n\n
 <\/p>\n\n\n\n
8. Create phpMyAdmin default Storage database<\/h3>\n\n\n\n
If you have not manually created a dedicated database for PHPmyadmin, the software will ask you to create one when you log in.<\/p>\n\n\n\n
At the bottom, you will see a message stating, “ThephpPMyAdmin configuration storage is not completely configured; some extended features have been deactivated.<\/em>” Click on the “Find out why” link.<\/strong><\/span><\/p>\n\n\n\n
\"phpmyadmin<\/a><\/figure>\n\n\n\n
<\/p>\n\n\n\n
Another page will open. Click the “Create<\/strong>” link to generate a database name, ‘phpymyadmin,<\/strong><\/span>‘ to complete the configuration storage setup.<\/p>\n\n\n\n
\"Create<\/a><\/figure>\n\n\n\n
<\/p>\n\n\n\n
That’s it. You have successfully removed the warning and set up all the required things to manage your MySQL database graphically.<\/p>\n\n\n\n
\"DB<\/a><\/figure>\n\n\n\n
<\/p>\n\n\n\n
 <\/p>\n\n\n\n
Ending Notes:<\/strong><\/p>\n\n\n\n
This way, we can install phpMyAdmin on LAMP running AlmaLinux 9 or 8 Server to access the MYSQL or MariaDB database using a web-based graphical user interface.<\/p>\n\n\n\n
Learn more:<\/strong><\/p>\n\n\n\n