Navigate / search

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.

GUI-based adminstration

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

Web-based administration

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

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.

Comments

Maxo
Reply

I have used OpenOffice Base for MySQL management, but it chokes on larger databases.
I have also been developing a tool tentatively called MySQL Explorer. I have it in Launchpad at https://code.launchpad.net/~maxolasersquad/+junk/MySQL_Explorer I also have it running live at http://maxolasersquad.com/MySQLExplorer/signin.php All one need do is put in their login credentials and the address of their MySQL database. Right now it only supports viewing tables and the UI is not so hot, but I’ve been working on it.

Leave a comment

name*

email* (not published)

website