Adminer is a lightweight, PHP-based MySQL administration tool that is a great alternative to PHPMyAdmin. It comes as a single file and can easily be installed globally on your Ubuntu Linux box, including a Vagrant box.
The prerequisites for installing and using Adminer are PHP, MySQL, and Apache, the so-called LAMP stack. To install them on Ubuntu, in the terminal, run:
sudo apt-get install php5 php5-cli php 5-mysql mysql-server apache2
You’ll be prompted for configuration information during the installation.
Once the LAMP stack is installed, install Adminer by running these commands in the terminal:
sudo mkdir /usr/share/adminer sudo wget -O /usr/share/adminer/latest.php "http://www.adminer.org/latest.php" sudo ln -s /usr/share/adminer/latest.php /usr/share/adminer/adminer.php echo "Alias /adminer.php /usr/share/adminer/adminer.php" | sudo tee /etc/apache2/conf.d/adminer.conf sudo service apache2 restart
After installing Adminer, open a web browser and navigate to
http://localhost/adminer.php. The Adminer login screen should be displayed. You can now log in to any of the MySQL databases configured.
If you want to upgrade to a new version of Adminer later, since you created a symlink to the
latest.php, you can simply run this command in the terminal:
sudo wget -O /usr/share/adminer/latest.php "http://www.adminer.org/latest.php"