Three must have tools for managing mysql databases
If you have installed Apache, MySQL and PHP on your Ubuntu Linux (LAMP), the next thing you’d probably want to do is install these three MySQL database management tools install on your Ubuntu computer. The applications make it easier for anyone who needs to manage MySQL databases on an Ubuntu box. The tools compliment each other and makes life easier for a MySQL user.
Two applications that has also been created by the developers of MySQL are the MySQL Admin and the MySQL Query Browser tools. Each tool has a specific purpose. You can use the MySQL Admin tool to create, edit, delete, monitor, backup your MySQL databases. The MySQL Query Browser tool on the other hand is indispensible for searching and manipulating the contents of your database tables.
Both tools can be installed using apt-get or the Synaptic Package Manager. To install them using apt-get, just do the following on a terminal session:
$ sudo apt-get install mysql-admin
$ sudo apt-get install mysql-query-browser
Another must have tool for managing your MySQL databases is a program called phpmyadmin. It is a web-based script that allows you to do almost anything on your MySQL database and tables. It is specially useful if you want to access the MySQL server data on your computer remotely via a web browser. To install phpmyadmin using apt-get, simply run the following command on a terminal session:
$ sudo apt-get install phpmyadmin
I have found them very valuable in managing the databases install on my Ubuntu computer. Of course this is on top of the mysql command line tool that I use every now and then. 🙂
Gerry Ilagan is into mobile apps and WordPress development at @speeqs. He loves to write about electronics, the Internet of Things, mobile phones, and #crazyideas.