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:
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.