setup adminer (phpMyAdmin alternative)

phpMyAdmin has grown into such a powerful tool with so many features that it is often a complete overkill. Adminer on the ohter hand is focused on being sleek and simple, with less features but quick to get up and running. it usally does the basic stuff that most people use phpMyAdmin for.

here are the few steps needed to set it up.

first, you need a working php setup on your web server

download the latest version of adminer to your document root

wget http://www.adminer.org/latest.php -O adminer.php

create a mysql admin user

mysql 
CREATE USER 'admin'@'localhost' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;

finally open your adminer.php in a browser and login with your admin user, it's as simple as that :)