Arch-Linux

10 thoughts
last posted March 28, 2015, 11:49 a.m.

9 earlier thoughts

0

PHPMyAdmin Installation

Firstly, install phpmyadmin and php-mcrypt packages.

sudo pacman -S phpmyadmin php-mcrypt

Enable extensions in php.ini

sudo nano /etc/php/php.ini

Uncomment

extension=mysqli.so
extension=mcrypt.so

Add webapps to php.ini's open_basedir path

open_basedir = /srv/http/:/home/:/tmp/:/usr/share/pear/:/usr/share/webapps/:/etc/webapps/

Create new Apache configuration file in /etc/httpd/conf/extra

sudo nano /etc/httpd/conf/extra/phpmyadmin.conf

Add these lines to new file

Alias /phpmyadmin "/usr/share/webapps/phpMyAdmin"
<Directory "/usr/share/webapps/phpMyAdmin">
    DirectoryIndex index.php
    AllowOverride All
    Options FollowSymlinks
    Require all granted
</Directory>

Include new file in httpd.conf (bottom)

sudo nano /etc/httpd/conf/httpd.conf
Include conf/extra/phpmyadmin.conf

Test Installation

Auto Login (Optional)

Edit /etc/webapps/phpmyadmin/config.inc.php

$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'YOUR-MYSQL-PASSWORD';