Today who does not interact with databases and if you're a programmer then the database management is your daily task. For database management, there is a very popular tool called, MySQL Workbench. It's a tool that ships with tonnes of functionalities. But not all of us as beginner programmers use all Workbench features. So here we also have a very lightweight database manager in Linux, Emma.
Emma is a Lightweight Database management tool
Emma is a very basic GUI database manager with all the CRUD(Create, Read, Update, Delete) functionality. One will find it useful for doing simple tasks, such as managing database for learning purposes, performing day to day tasks using a very lightweight GUI and also performing CRUD actions using MySQL queries from the command field.
How to install Emma in Linux?
Installing Emma is very easy. It's already available in most major Linux distributions. So just your distro package manager to install this database manager.
sudo apt-get install emma
For Fedora based distros -
dnf install emma
Emma Main Features
* Dialogs to create/modify MySQL databases, tables and associated indexes
* Result sets grouped in tabs
* SQL editor:
+ Built-in syntax highlighting
+ Table and field name tab-completion
+ Automatic SQL statement formatting
* Export to CSV files
* Multiple simultaneously opened MySQL connections
How to connect to database using Emma?
It is very easy to connect to the databases using Emma. I have also attached screenshots along with the steps, so be sure to check for better understanding.
First of all open the app from the applications menu. The following simple window will appear.
First of all, you'll need to connect Emma with your host. For this tutorial, I am going to connect Emma with my 'localhost'. Make sure you've already setup MySQL server in your system in order to connect it with localhost.
Now to make a connection with localhost, right click anywhere in the left sidebar. Click 'new connection'. The following connection window will popup -
Fill in your host info. Leave the last field 'database', if you want all the databases available in the app. After filling in your host info, click 'test'. It will give you error if the credentials are wrong otherwise will say connection is successful. Now click 'Apply'. You're all done.
Now you can manage all the databases using Emma. The database manager allows you to do simple important tasks, CRUD using GUI or use command field to pass in MySQL queries. You can right-click any database to edit or add tables to the database.
It is very simple Database management tool
Emma is extremely simple database management tool without lots of bells and whistles. At the same time, it's lightweight and extremely easy to use. If you're a beginner or learning PHP then you'll find it awesome for your practice. It just works out of the box. No lots of configurations. Once you connect it with your database it'll allow you to edit/add tables inside.
If this article helped you, please share it with others on social media. Also, leave us your views in the comment section below and tell us your favourite Database management tool in Linux.
More From LinuxAndUbuntu