MySQL Workbench is a marvelous visual tool launched for the developers of databases, creators and Database Administrators (DBA’s). This is available for operating systems like Linux, Mac Os and Windows. I have installed it on Ubuntu 14.04.
There are basically three most important part of MySql Workbench:
Sql Developer: With the use of this, you can create and manage the databases.
Data Modelling: It allows you to create ER-Diagrams to show the relationships between the database, in a table format.
Database Administration: This feature allows you to monitor the database, so that it would not be subjected to any issue
Steps to Install MySQL Workbench on Ubuntu
Step 1: Open the Terminal by pressing the “Ctrl + Alt + T” keys. Try installing it, by typing “sudo apt-get install mysql-workbench” and press enter.
Step 2: You will be asked to enter the sudo password, if you are not a root user. Provide the password and then press enter. Processing will get started by the shell, it may discern an additional memory required. To continue, just write “y” to agree.
Step 3: Search for “mysql” and you”ll will see “mysql workbench” icon, click on it to open. If you often use it, just drag and drop it to the “Launchpad” or you can say “Menu bar”.
Step 4: Once you open Mysql Workbench, various options at the top Menu are available. Suppose, you want to connect or manage the Database, and then click on Database.
Step 5: If you wish to create a new MySql Connection then click on “+” sign as shown in the image below.
Step 6: A dialog box will appear, here, you can set up a connection by giving a name, default schema, etc. The Default scheme automatically activates the database when you open up the session. It is usually done when you use the same Database.
Once you are done with the changes, click on “OK” or “Test Connection” to test it.
That’s it, guys.