Adminer

Adminer is a web-based database management tool written in PHP. It is possible to manage MySQL, PostgreSQL, Sqlite3, MS SQL, Oracle database and Elasticsearch.

It is a simpler alternative to PhpMyAdmin. You can find more pieces of information about this project at the official page or at Wikipedia.

Installation

Install the adminerAUR package or download Adminer and place it manually in the document-root instead.

When using the adminerAUR package, Adminer will be installed as /usr/share/webapps/adminer/index.php.

Ensure the correct extensions in /etc/php/php.ini are uncommented, e.g. extension=pdo_mysql should provide MySQL database management.

Configuration

Apache
Note: Ensure that the PHP extension for Apache is properly configured

Add the following line to /etc/httpd/conf/httpd.conf:

Include conf/extra/httpd-adminer.conf

Then restart your Apache HTTP Server daemon.

Adminer can now be accessed by browsing to http://localhost/adminer.

Nginx
Note: Ensure that the PHP FastCGI interface has been configured correctly.

Create a server entry using /usr/share/webapps/adminer as root:

Symlink to and restart nginx.

Hiawatha

Ensure that the PHP FastCGI interface is configured correctly.

Then add the following block to your .

Then restart the hiawatha.service.

gollark: Looks pretty nice, though.
gollark: 6" seems annoyingly large.
gollark: I honestly mostly just use the browser.
gollark: The slideout ones look quite cool.
gollark: I do like the look of the BlackBerry Keyone etc. keyboards, which are just small keyboards below the screen, but obviously I've never actually tried one...

See also
This article is issued from Archlinux. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.