I have been using Ubuntu Linux from past 4 years and since then there came numerous updates to Ubuntu and its packages. Working with Ubuntu is really a fun and challenge for me, since the time I am using it. There are many more things to learn in Ubuntu, you have to give time to learn all about it.

Today, I am going to tell something about MySQL database management in Ubuntu Linux. Creating Databases, Creating Tables, managing them, inserting records, executing queries is just as drinking water with the new package calledMySQL WorkBench.

P.S: Since version 12.04 Ubuntu has droppedMysql Administrator andQuery Browser from their package repositories, now its using theMySQL Workbench.

MySQL Workbench

Installing MySQL Workbench:

The installation process for SQL-WB is very easy, you can either install it from the package manager or from the terminal window by typing:

$ sudo ap-get install mysql-workbench

After the installation process completes, open the package and you will see a very sophisticated screen, don’t panic, its very easy to manage and truly speaking, this package has many more features as compared to the older versions.

The Initial Screen:

MySQL Workbench – Home

When you open the package, you will see home screen as shown above.

Major Features of Workbench Include:

1. Creating new connection.
2. Editing table data.
3. Edit SQL script.
4. Managing connections.
5. Create new ERR model.
6. Creating ERR model from existing database.
7. Creating ERR model from SQL script.
8. New server instance.
9. Import and Export of data.
10. Security implementations.
11. Managing server instances.

Along with the above features you can easily connect to the following services from the home screen itself:

1. MySQL DOC Library.
2. MYSQL Bug Reporter.
3. WorkBench Blogs.
4. Planet MySQL.
5. WorkBench Forums.
6. Scripting Shell.
7. Utilities and more.

All or some of the above features which I had told was not possible with the previous versions of MySQL Administrator and Query Browser. Moreover, this package has an inbuilt Query Browser and manager which is very easy to process.