phpMyAdmin is a popular web-based tool that makes it easy to manage MySQL databases. Once you have installed Apache, PHP, and MySQL on your AlmaLinux 9 server, you can add phpMyAdmin for database management.
Download phpMyAdmin from the official website 📥
Step 1: Navigate to the directory where you will download phpMyAdmin. Typically, web files are stored in /var/www/html/.
cd /var/www/html
Step 2: Download the latest version of phpMyAdmin from the official website using wget:
wget https://www.phpmyadmin.net/downloads/phpMyAdmin-latest-all-languages.tar.gz
Step 3: Unzip the downloaded file:
tar -xvzf phpMyAdmin-latest-all-languages.tar.gz
Step 4: Rename the folder to make it easier to access:
mv phpMyAdmin-*-all-languages phpmyadmin
Step 5: Delete the downloaded archive to save storage space:
rm -rf phpMyAdmin-latest-all-languages.tar.gz
Configure phpMyAdmin 🔧
Step 1: Create a configuration file:
cp -rf /var/www/html/phpmyadmin/config.sample.inc.php /var/www/html/phpmyadmin/config.inc.php
Step 2: Edit the configuration file to set a passphrase (blowfish secret):
nano /var/www/html/phpmyadmin/config.inc.php
Find the line:
$cfg['blowfish_secret'] = '';
Add a secure phrase (minimum 32 characters):
$cfg['blowfish_secret'] = 'your_secure_passphrase';
Save and close the file.
Access phpMyAdmin in Browser 🌐
Open your browser and go to:
http://your-ip-address/phpmyadmin
Enter your MySQL username and password to access the phpMyAdmin interface.
Now you have phpMyAdmin manually installed and working on your VPS with AlmaLinux 9! 🎉 This tool will make database management much easier.
💡 Questions or suggestions? Write to us in the comments! 😊
