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
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';