Step 1 – Download phpMyAdmin Archive
Download latest phpMyAdmin source code and extract on your system using. Click here to download latest or any older release of phpMyAdmin. Also extract the downloaded archive. This version of phpMyAdmin is compatible with PHP >= 5.5 and MySQL >= 5.5.
cd /usr/share wget https://files.phpmyadmin.net/phpMyAdmin/4.8.5/phpMyAdmin-4.8.5-all-languages.zip unzip phpMyAdmin-4.8.5-all-languages.zip mv phpMyAdmin-4.8.5-all-languages phpmyadmin
Now set the proper permissions on files to be used with the web server. Generally, Apache web server runs under user and group named www-data on Debian based systems and apache on Redhat based systems.
### Debian based system chown -R www-data:www-data /usr/share/phpmyadmin chmod -R 755 /usr/share/phpmyadmin ### Redhat based system chown -R apache:apache /usr/share/phpmyadmin chmod -R 755 /usr/share/phpmyadmin
Step 2 – Setup Apache for phpMyAdmin
Create a new Apache configuration file for phpMyAdmin /etc/httpd/conf.d/phpmyadmin.conf for RedHat based system and /etc/apache2/conf-available/phpmyadmin.conf for Debian based systems and add following settings there.
<Directory "/usr/share/phpmyadmin"> Order Deny,Allow Deny from all Allow from localhost Allow from 127.0.0.1 Allow from 192.168.1.0/24 </Directory> Alias /phpmyadmin /usr/share/phpmyadmin Alias /phpMyAdmin /usr/share/phpmyadmin
Change 192.168.1.0/24 with your LAN subnet IP addresses.
Step 3 – Restart Apache Service
After creating a configuration file we need to restart or reload Apache service. I prefer to just reload on production servers.
sudo service httpd reload## RedHat based systems sudo service apache2 reload## Debian based systems
Step 4 – Access phpMyAdmin
Now you can access phpMyAdmin in a browser using the following URL. Change
URL: http://
Login Details: Use MySQL username and password.
My Experiments – Now Got Success
Installing phpMyAdmin 5.0
———————————–
Download phpMyAdmin Archive
Download latest phpMyAdmin source code and extract on your system using. (https://www.phpmyadmin.net/downloads/)
wget https://files.phpmyadmin.net/phpMyAdmin/5.0.0/phpMyAdmin-5.0.0-all-languages.zip
unzip phpMyAdmin-5.0.0-all-languages.zip
mv phpMyAdmin-5.0.0-all-languages phpmyadmin
Now set the proper permissions on files to be used with the web server. Generally, Apache web server runs under user and group named www-data on Debian based systems and apache on Redhat based systems.
### Debian based system
chown -R www-data:www-data /var/www/html/phpmyadmin
chmod -R 755 /var/www/html/phpmyadmin
### Redhat based system
chown -R apache:apache /var/www/html/phpmyadmin
chmod -R 755 /var/www/html/phpmyadmin
Setup Apache for phpMyAdmin
—————————-
Create a new Apache configuration file for phpMyAdmin /etc/httpd/conf.d/phpmyadmin.conf for RedHat based system and /etc/apache2/conf-available/phpmyadmin.conf for Debian based systems and add following settings there.
AddDefaultCharset UTF-8
# Apache 2.4
#Require ip 127.0.0.1
#Require ip ::1
Require all granted
# Apache 2.2
Order Deny,Allow
Deny from All
Allow from 127.0.0.1
Allow from ::1
Alias /phpmyadmin /var/www/html/phpmyadmin
Alias /phpMyAdmin /var/www/html/phpmyadmin
Restart Apache Service
————————
After creating a configuration file we need to restart or reload Apache service.
systemctl restart httpd.service
Setup phpMyAdmin
—————–
MySQL root user password update
mysql -u root -h localhost -p
mysql> ALTER USER ‘root’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘Sjcet123#’;
Warnings (Fix)
>> TempDir : This value should be double checked to ensure that this directory is neither world accessible nor readable or writable by other users on your
Solution was to create a folder called tmp like this: /var/www/html/phpmyadmin/tmp.
mkdir /var/www/html/phpmyadmin/tmp
>> ZIP : Zip decompression requires function (zip_open) which are unavailable on this system.
yum –enablerepo=remi-php73 install php-pecl-zip
Blowfish Password
——————
$cfg[‘blowfish_secret’] = ‘u=s|qeyn-?Pn]3erdN97{waRyq7[pkvY’;
Access phpMyAdmin
——————
Now you can access phpMyAdmin in a browser using the following URL.
URL: http://localhost/phpMyAdmin/
Login Details: Use MySQL username and password.
I am using Oracle Linux 7 (el)
Installed LAMP as per your tutorial – working fine.
Now, I followed How to Install PhpMyAdmin 4.8 on CentOS/RHEL 7/6 (https://tecadmin.net/install-phpmyadmin-on-centos/)
Downloaded latest version of phpMyAdmin (5.0)
After the complete steps.. while accessing http://localhost/phpmyadmin
showing this error…. Kindly help if possible… by email to me : [email protected]
———————————————–
Forbidden
You don’t have permission to access /phpmyadmin on this server.
————————————————-