Adminer

From ArchWiki
Revision as of 10:46, 15 June 2015 by Beta990 (talk | contribs) (Configuration under Apache: Style fixes)
Jump to: navigation, search

Adminer is a simple tool for database management. It's possible to manage MySQL, PostgreSQL, Sqlite3, MS SQL and Oracle. It's a simpler alternative to PhpMyAdmin. You can find more pieces of information about this project at official page or Wikipedia.

Installation

Ensure you do not have an older copy of Adminer:

$ rm -r /srv/http/adminer

Install adminerAUR from the AUR and add the following line to /etc/httpd/conf/httpd.conf:

Configuration under Apache

Include conf/extra/httpd-adminer.conf

Then restart your apache daemon.

# systemctl restart httpd
Note: The Adminer can be accessed by your browser on http://localhost/adminer.

In case there is an (403) error, change the following lines inside the /etc/httpd/conf/extra/httpd-adminer.conf file:

Alias /adminer "/usr/share/webapps/adminer"
<Directory "/usr/share/webapps/adminer">
     AllowOverride All
     Require all granted
     #php_admin_value open_basedir "/srv/:/tmp/:/usr/share/webapps/:/etc/webapps:/usr/share/pear/"
</Directory>

Restart the restart apache daemon again.

# systemctl restart httpd

See also