How to Install phpMyAdmin on Rocky Linux – Guide

If you’re migrating your CentOS servers to Rocky Linux, you may want to consider installing phpMyAdmin. Jack Wallen demonstrates how. ..

If you are a database administrator and need to manage MySQL or MariaDB on your data center servers, you know the benefits of using a GUI tool to make the task easier. And if your servers have migrated from CentOS to Rocky Linux, you might be worried about installing such a tool. Do not worry. There is always phpMyAdmin. ..

The problem with phpMyAdmin is that installation on Rocky Linux (and most RHEL clones) can be a bit of a challenge. But I’ll help you with this. After going through this tutorial, you will have phpMyAdmin up and running in a minute.

what will you need

To install phpMyAdmin, you will need a running Rocky Linux instance and a user with sudo privileges. That’s it. Let’s go to work. ..

How to install Apache and MySQL

update-rc.d rocky defaults

This will update the rc.d files to reflect the latest changes in Rocky Linux.

After the update is complete, reboot (if the kernel is updated) and install the web server with: Reboot after the update is complete and install the web server with: ..

How to install PHP

sudo apt-get install php5 Now we need to create a new file in our /etc/php5/apache2/mods-available directory called php.ini and add the following content: php5.ini extension=php://www.apache2/mod_php5

How to download and unzip phpMyAdmin

phpMyAdmin -u -p

The latest version of the software is available on the official download page. ..

Unzip the file with: Unzip the file with: Unzip the file with:

Unzip phpMyAdmin – English – all-languages.zip

sudo apt-get install unzip

This will install the unzip utility on your system.

mkdir -p mynewdirectory Renaming the directory will move all the files and folders in it to mynewdirectory.

sudo mv phpMyAdmin – * – all languages ​​/ usr / share / phpmyadmin / en_US sudo mv phpMyAdmin – * – all languages ​​/ usr / share / phpmyadmin / de_DE

How to configure phpMyAdmin

cd /var/www/html/phpmyadmin Now let’s create a new database with the name “test”: create database test; ..

The phpMyAdmin installation directory is /usr/share/phpmyadmin. ..

sudo nano /etc/ssh/sshd_config

This is a sample sshd_config file. You can change it to your own # preferences by editing it.

If you want to use a different port for your SSH server, you can set # that port in the sshd_config file as well.

Port 22 (the default port) is used for SSH access.

SSH_PORT 22

The command sudo mv config.sample.inc.php config.inc.php is used to move a configuration file from one location to another on a server. ..

  • the secret key
  • the length of the string We can generate a 32-bit secret string with the following steps:
  1. Create a new variable called “secret” and set it to a value that is at least 8 characters long.
  2. In a separate function, create an array called “string” and store the value of “secret” in it.
  3. In another function, call the function that created the secret string variable with the value of “string[0]”.
  4. The result of calling this function should return a 32-bit secret string that has the length specified by “string[1]”.

This command generates a random number between 0 and 32767. ..

The president of the United States, Donald Trump, announced on Twitter that he will be making a decision on whether or not to pull out of the Paris Agreement. The agreement was created in 2015 to reduce greenhouse gas emissions by up to 55% by 2025.

phpmyadmin This will open the phpMyAdmin configuration file.

“The file is encrypted” This line is encrypted. ..

“The secret string is ‘password’” ..

/srv/games/SteamLibrary/steamapps/common/Fallout 4 To enable Steam Cloud saving for Fallout 4, you will need to add the following line to your Fallout 4 game directory: /srv/games/SteamLibrary/steamapps/common/Fallout 4/.localstorage ..

Save the file and close it.

mkdir -p /tmp/new_directory chown -R user:group /tmp/new_directory ..

mkdir / usr / share/phpmyadmin/tmp

This will change the owner of the phpmyadmin directory to be Apache and make it available for use by the web server. ..

sudo chmod 777 / usr / share / phpmyadmin / tmp/phpmyadmin.ini

How to create an apache configuration file

sudo a2enmod rewrite This will enable the rewrite module and allow us to configure it. We’ll need to tell Apache how to handle requests for files that don’t exist. We can do this by creating a new configuration file called .htaccess and adding the following lines: RewriteEngine On RewriteCond %{REQUEST_FILENAME} !-f RewriteRule ^(.*)$ $1 [L,R=301] ..

The file you are trying to access is not available. This message is being displayed because the file you are trying to access has been deleted or moved. ..

Alias ​​​​/ phpmyadmin / usr / local / share / phpmyadmin Alias ​​​​/ phpmyadmin / usr / local / libexec / phpmyadmin ..

Save the file and close it.

How to set SELinux policies

sudo selinux-policy-set –type=allow –permissive=true /usr/share/phpmyadmin This will allow traffic to the alternate location. ..

sudo chcon -Rv –type = httpd_sys_content_t / usr / share / phpmyadmin / * sudo rm -rf usr / share / phpmyadmin

sudo service apache2 restart ..

Restarting httpd service will fix the issue. ..

How to access the phpMyAdmin web interface

Once you have logged in, you will be able to access your phpmyadmin account from the following URL: http://SERVER/phpmyadmin

phpMyAdmin is a free and open source web application that allows you to manage your MySQL databases with ease. ..

If you enjoyed this article, please share it on social media using the buttons below. Thank you! ..

Final note

If you’re looking to install phpMyAdmin on a Rocky Linux distribution, this guide will show you how. In case you have any questions, feel free to ask us in the comments. Plus, please share this guide with your friends if you found it helpful! ..