Adminer Installation

- Posted in Server Configuration by

  1. To install Adminer, execute the following command: sudo apt install adminer sudo a2enconf php*-fpm sudo a2enconf adminer sudo systemctl restart apache2 systemctl reload apache2 Now you can access Adminer at http:YourServerIPAddress/adminer:

  2. mkdir /var/www/ashburn/adminer wget "http://www.adminer.org/latest.php" -O /var/www/ashburn/adminer/adminer.php chown -R www-data:www-data /var/www/ashburn/adminer/adminer.php chmod 755 /var/www/ashburn/adminer/adminer.php cd /var/www/ashburn/adminer

    sudo apt install adminer exit sudo nano /etc/apache2/conf-available/adminer.conf add: Alias /adminer /usr/share/adminer/adminer/ sudo a2enconf adminer.conf sudo systemctl restart apache2

  3. sudo apt info adminer sudo apt install adminer sudo systemctl status apache2 if you want to secure, add more passwd; sudo htpasswd -B -c /etc/adminer/.htpasswd adminer sudo nano /etc/apache2/conf-available/adminer.conf Alias /adminer /etc/adminer Require all granted DirectoryIndex conf.php

    add below to secure; AuthType Basic AuthName "Restricted Resource" AuthBasicProvider file AuthUserFile /etc/adminer/.htpasswd Require valid-user

    sudo a2enconf adminer.conf sudo apachectl configtest sudo systemctl restart apache2

adminer user setup

sudo mysql -u root -p
CREATE USER 'adminer'@'localhost' IDENTIFIED BY 'andibutt1986';
GRANT ALL PRIVILEGES ON *.* TO 'adminer'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;
SELECT user,host FROM mysql.user;
EXIT
visit site /adminer