Get Social

Installing and configuring the adminer on debian (phpmyadmin alternative)

On my current work, there was a task to install and adjust this tool.

What is it? According to Wikipedia: “Adminer (formerly known as phpMinAdmin) is a tool for managing content in MySQL databases (since version 2 also in PostgreSQL, MS SQL, SQLite and Oracle databases).

Next – go to his site and get acquainted closer … We see that there is simply an adminer, and there is – adminer-mysql. We need for mysql. Since the package for it is still in the sid branch, it will not turn out beautifully from the repository. We will not connect this branch so that the package manager does not become littered, especially since the entire utility is one file and we can have the latest version simply by downloading it from the site. On our Debian server, create a directory and download the latest version of adminer:

mkdir /var/www/adminer
cd /var/www/adminer
wget https://www.adminer.org/latest-mysql.php

Next, create a configuration file for Apache:

nano /etc/apache2/conf.d/adminer.conf

Add the following entry:

Alias /adminer /var/www/adminer

<Directory /var/www/adminer>
        Options FollowSymLinks
        DirectoryIndex latest-mysql.php

        <IfModule mod_php5.c>
                AddType application/x-httpd-php .php

                php_flag magic_quotes_gpc Off
                php_flag track_vars On
                php_flag register_globals Off
                php_value include_path .
        </IfModule>
</Directory>

Now, use it with url: http://yourserver/adminer

P.S. It is also possible to change the interface – you just need to download the file adminer.css to the adminer.php directory.