NB: This is an outdated post. New Ubuntu versions use Apache 2.4 instead of Apache 2.2. You can find updated instructions that apply to Ubuntu 14.04 in a new post!
It is not a secret that do a lot of Symfony programming at LeaseWeb. Most of the projects are PHP based and use MySQL as a database. This posts describes a gem that many experienced PHP programmers have not yet heard of.
During software development you often need a tool to quickly search the database, add a column or change a value. Most PHP developers know that phpMyAdmin is a good tool that can provide you with easy access, but only a few know that there is really good alternative for this tool called “Adminer“.
In my opinion Adminer has the advantage that it has a better user experience, but this is not the only advantage it has (or may have). According to the Adminer website there is a long list of reasons why Adminer is better than phpMyAdmin.
If you are really fond of Adminer, you might want to install it in the same way phpMyAdmin is installed. Since it is not yet part of the standard Ubuntu repositories you might want to install it manually. Here are the commands you need for installation (on a Debian based system):
$ sudo su # mkdir /usr/share/adminer # cd /usr/share/adminer # wget "http://www.adminer.org/latest.php" # ln -s latest.php adminer.php # echo "Alias /adminer.php /usr/share/adminer/adminer.php" > /etc/apache2/conf.d/adminer.conf # service apache2 restart # exit $
Once it is installed and you want to update it (it wil indicate when a new version is available):
$ sudo su # cd /usr/share/adminer # wget "http://www.adminer.org/latest.php" # exit $
To uninstall it:
$ sudo su # rm -R /usr/share/adminer # rm /etc/apache2/conf.d/adminer.conf # service apache2 restart # exit $
Try it out and let me know whether you like it or not.
thank you sir , it’s very helpful
You can check free tool Valentina Studio http://www.valentina-db.com/en/valentina-studio-overview which I think is far superior to other GUI tools.
@Tom: Thank you for that suggestion. I see there is a free version and that it is available for both Linux and OSX, which is great!
Another great alternative to phpmyadmin is dbForge Studio for MySQL http://www.devart.com/dbforge/mysql/studio/
This MySQL Manager have all the necessary functional and is very comfortable and easy in use!
@Robert: Thank you for your comment. It seems to be a commercial product that “requires .NET Framework 3.5 SP1, or 4.0 installed”, so I doubt it will run on Linux. Note that there are many good free and open-source alternatives on: http://alternativeto.net/software/dbforge-studio/
I installed Adminer too and found it much faster than phpmyadmin. However, after migrating to UTF-8, I’ve been having some issues. Is this familiar to you at all: http://stackoverflow.com/questions/21439798/utf-8-input-problems-with-adminer-and-phpmyadmin
I run Kloxo MR on my server (I installed it following the guide at https://www.rosehosting.com/blog/install-kloxo-mr-on-linux-vps/) and I can use both Adminer and phpMyAdmin. I agree that Adminer is a very good alternative to phpMyAdmin and it provides pretty much the same functions. It is more configurable I think. Thanks.
@Ian: I see your problem is fixed. Not an Adminer problem 🙂
@Peter: Thank you for providing feedback. I’m glad it works out for you!
Thank you. I also recommend MYSQL WORKBENCH. You can build very powerful architecture of databases by relating tables and fields.