{"id":6440,"date":"2021-08-04T06:41:48","date_gmt":"2021-08-04T06:41:48","guid":{"rendered":"https:\/\/www.how2shout.com\/linux\/?p=6440"},"modified":"2021-08-04T07:02:13","modified_gmt":"2021-08-04T07:02:13","slug":"how-to-install-phpmyadmin-on-rocky-linux-8-with-apache","status":"publish","type":"post","link":"https:\/\/linux.how2shout.com\/how-to-install-phpmyadmin-on-rocky-linux-8-with-apache\/","title":{"rendered":"How to install phpMyAdmin\u00a0on Rocky Linux 8 with Apache"},"content":{"rendered":"

Managing MySQL or MariaDB using a web-based GUI application – PhpMyAdmin is a lot easier than using the command line. Hence, if you want to install PhpMyAdmin on Rocky Linux 8 then here is a tutorial to help you with that.<\/p>\n

phpMyAdmin is free to use PHP-based application distributed under open source licenses and one of the popular tools on various web hosting to manage MySQL databases. It allows the users to perform create, delete, export, import, creating PDF graphics of the database layout and more database-related tasks but with GUI and with a few clicks of the mouse.<\/p>\n

phpMyAdmin installation on Rocky Linux 8 with Apache<\/h2>\n

Here we install phpMyAdmin using the popular web server platform Apache and of course, PHP & MySQL database will be there as well. This tutorial can be used for AlamLinux, CentOS, and HEL 8 versions as well.<\/p>\n

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

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

If you have these three things then move forward otherwise see our tutorial- how to set up a LAMP server on Rocky Linux 8<\/a> and then come back here.<\/p>\n

 <\/p>\n

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

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

Note<\/strong>: The latest version while performing this tutorial was 5.1.1<\/strong> and may be different in your case.<\/p>\n

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

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

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