phpmyadmin – ServerOK

cd /usr/local/src
wget https://files.phpmyadmin.net/phpMyAdmin/4.8.2/phpMyAdmin-4.8.2-all-languages.zip
unzip phpMyAdmin-4.8.2-all-languages.zip
mkdir /usr/serverok
rm -rf /usr/serverok/phpmyadmin
mv phpMyAdmin-4.8.2-all-languages /usr/serverok/phpmyadmin
mkdir /usr/serverok/phpmyadmin/tmp/
chmod 777 /usr/serverok/phpmyadmin/tmp/
cp /usr/serverok/phpmyadmin/config.sample.inc.php /usr/serverok/phpmyadmin/config.inc.php

cd /usr/local/src

wget https://files.phpmyadmin.net/phpMyAdmin/4.8.2/phpMyAdmin-4.8.2-all-languages.zip

unzip phpMyAdmin-4.8.2-all-languages.zip

mkdir /usr/serverok

rm -rf /usr/serverok/phpmyadmin

mv phpMyAdmin-4.8.2-all-languages /usr/serverok/phpmyadmin

mkdir /usr/serverok/phpmyadmin/tmp/

chmod 777 /usr/serverok/phpmyadmin/tmp/

cp /usr/serverok/phpmyadmin/config.sample.inc.php /usr/serverok/phpmyadmin/config.inc.php

Edit

vi /usr/serverok/phpmyadmin/config.inc.php

1	vi /usr/serverok/phpmyadmin/config.inc.php

Generate 32 chars length random key and add

pwgen 32

pwgen 32

sed -i  's/$cfg\[.blowfish_secret.\] = .*$/$cfg\["blowfish_secret"\] = "ohhae8Fa6oJohrohng0ieV0to3aiThae";/g' /usr/serverok/phpmyadmin/config.inc.php

1	sed -i 's/$cfg\[.blowfish_secret.\] = .*$/$cfg\["blowfish_secret"\] = "ohhae8Fa6oJohrohng0ieV0to3aiThae";/g' /usr/serverok/phpmyadmin/config.inc.php

Configure Apache

On Ubuntu, create file

vi /etc/apache2/conf-enabled/phpmyadmin.conf

1	vi /etc/apache2/conf-enabled/phpmyadmin.conf

On CentOS

vi /etc/httpd/conf.d/phpmyadmin.conf

1	vi /etc/httpd/conf.d/phpmyadmin.conf

Add following content

Alias /phpmyadmin "/usr/serverok/phpmyadmin"
  
<Directory "/usr/serverok/phpmyadmin">
    AllowOverride All
    Options FollowSymlinks
    Order allow,deny
    Allow from all
   <IfModule mod_authz_core.c>
     <RequireAny>
       Require all granted
     </RequireAny>
   </IfModule>
</Directory>

Alias /phpmyadmin "/usr/serverok/phpmyadmin"

AllowOverride All

Options FollowSymlinks

Order allow,deny

Allow from all

Require all granted

</RequireAny>

</IfModule>

</Directory>

MySQL root can’t login to phpMyAdmin

Password Protect phpMyAdmin in CentOS Server

Add following config to /etc/httpd/conf.d/phpmyadmin.conf

alias /phpmyadmin "/usr/serverok/phpmyadmin"

<Directory "/usr/serverok/phpmyadmin">
    AllowOverride All
    Options FollowSymlinks
    AuthType Basic
    AuthName "Restricted Content"
    AuthUserFile /usr/serverok/htpasswd/phpmyadmin
    Require valid-user
</Directory>

alias /phpmyadmin "/usr/serverok/phpmyadmin"

AllowOverride All

Options FollowSymlinks

AuthType Basic

AuthName "Restricted Content"

AuthUserFile /usr/serverok/htpasswd/phpmyadmin

Require valid-user

</Directory>

Create password file

mkdir /usr/serverok/htpasswd
htpasswd -c /usr/serverok/htpasswd/phpmyadmin admin

1 2	mkdir /usr/serverok/htpasswd htpasswd -c /usr/serverok/htpasswd/phpmyadmin admin

This will create user “admin” with password you specified.

Restart apache

service httpd restart

1	service httpd restart

Nginx

Add following inside any server entry

location /phpmyadmin {
    root /usr/serverok/;
    index index.php;
    location ~ ^/phpmyadmin/(.*\.php)$ {
            include snippets/fastcgi-php.conf;
            proxy_read_timeout 180;
            fastcgi_intercept_errors on;
            fastcgi_buffers 16 16k;
            fastcgi_buffer_size 32k;
            fastcgi_pass unix:/run/php/php7.2-fpm.sock;
    }
}

location /phpmyadmin {

root /usr/serverok/;

index index.php;

location ~ ^/phpmyadmin/(.*\.php)$ {

include snippets/fastcgi-php.conf;

proxy_read_timeout 180;

fastcgi_intercept_errors on;

fastcgi_buffers 16 16k;

fastcgi_buffer_size 32k;

fastcgi_pass unix:/run/php/php7.2-fpm.sock;

}

https://www.adminer.org
phpMyAdmin allow connecting to multiple servers
Allow phpMyAdmin remote access on xampp
MySQL root can’t login to phpMyAdmin
Nginx Configuration for phpMyAdmin

Leave a Reply Cancel reply