MySQL Workbench is a integrated tool for MySQL.
The MySQL workbench gives a graphical interface to user through which user can easily manage many MySQL Administration task.The tool can be install in Windows,MacOSX and Linux. As well as its source code is also available.
The MySQL Workbench is easy to install in Windows,MacOSX and Linux operating system.
Here we will install the MySQL WorkBench in Ubuntu
Use the below given command to install MySQL workbench
sudo apt-get update sudo apt-get install mysql-workbench
It will install its dependency itself.
Below is the reference of my system
root@tuxworld:/etc/mail# apt-get install mysql-workbench Reading package lists... Done Building dependency tree Reading state information... Done The following packages were automatically installed and are no longer required: sendmail-base sendmail-cf sensible-mda Use 'apt-get autoremove' to remove them. The following extra packages will be installed: libctemplate2 mysql-utilities mysql-workbench-data python-mysql.connector python-pysqlite2 ttf-bitstream-vera Suggested packages: python-pysqlite2-doc python-pysqlite2-dbg The following NEW packages will be installed: libctemplate2 mysql-utilities mysql-workbench mysql-workbench-data python-mysql.connector python-pysqlite2 ttf-bitstream-vera 0 upgraded, 7 newly installed, 0 to remove and 483 not upgraded. Need to get 19.6 MB of archives. After this operation, 55.1 MB of additional disk space will be used. Do you want to continue [Y/n]? y Get:1 http://in.archive.ubuntu.com/ubuntu/ quantal/universe libctemplate2 i386 2.2-3 [255 kB] Get:2 http://in.archive.ubuntu.com/ubuntu/ quantal/universe python-mysql.connector all 0.3.2-1 [36.6 kB] Get:3 http://in.archive.ubuntu.com/ubuntu/ quantal/universe mysql-utilities all 1.0.5-1 [234 kB] Get:4 http://in.archive.ubuntu.com/ubuntu/ quantal/universe mysql-workbench-data all 5.2.40+dfsg-1 [7,152 kB] Get:5 http://in.archive.ubuntu.com/ubuntu/ quantal/universe python-pysqlite2 i386 2.6.3-3 [35.3 kB] Get:6 http://in.archive.ubuntu.com/ubuntu/ quantal/universe mysql-workbench i386 5.2.40+dfsg-1 [11.6 MB] Get:7 http://in.archive.ubuntu.com/ubuntu/ quantal/universe ttf-bitstream-vera all 1.10-8 [352 kB] Fetched 19.6 MB in 2min 11s (149 kB/s) Selecting previously unselected package libctemplate2. (Reading database ... 574834 files and directories currently installed.) Unpacking libctemplate2 (from .../libctemplate2_2.2-3_i386.deb) ... Selecting previously unselected package python-mysql.connector. Unpacking python-mysql.connector (from .../python-mysql.connector_0.3.2-1_all.deb) ... Selecting previously unselected package mysql-utilities. Unpacking mysql-utilities (from .../mysql-utilities_1.0.5-1_all.deb) ... Selecting previously unselected package mysql-workbench-data. Unpacking mysql-workbench-data (from .../mysql-workbench-data_5.2.40+dfsg-1_all.deb) ... Selecting previously unselected package python-pysqlite2. Unpacking python-pysqlite2 (from .../python-pysqlite2_2.6.3-3_i386.deb) ... Selecting previously unselected package mysql-workbench. Unpacking mysql-workbench (from .../mysql-workbench_5.2.40+dfsg-1_i386.deb) ... Selecting previously unselected package ttf-bitstream-vera. Unpacking ttf-bitstream-vera (from .../ttf-bitstream-vera_1.10-8_all.deb) ... Processing triggers for man-db ... Processing triggers for menu ... Processing triggers for shared-mime-info ... Unknown media type in type 'all/all' Unknown media type in type 'all/allfiles' Unknown media type in type 'uri/mms' Unknown media type in type 'uri/mmst' Unknown media type in type 'uri/mmsu' Unknown media type in type 'uri/pnm' Unknown media type in type 'uri/rtspt' Unknown media type in type 'uri/rtspu' Processing triggers for desktop-file-utils ... Processing triggers for gnome-menus ... Processing triggers for bamfdaemon ... Rebuilding /usr/share/applications/bamf.index... Processing triggers for mime-support ... Processing triggers for fontconfig ... Setting up libctemplate2 (2.2-3) ... Setting up python-mysql.connector (0.3.2-1) ... Setting up mysql-utilities (1.0.5-1) ... Setting up mysql-workbench-data (5.2.40+dfsg-1) ... Setting up python-pysqlite2 (2.6.3-3) ... Setting up mysql-workbench (5.2.40+dfsg-1) ... Setting up ttf-bitstream-vera (1.10-8) ... Processing triggers for libc-bin ... ldconfig deferred processing now taking place Processing triggers for python-support ... Processing triggers for menu ... root@tuxworld:/etc/mail#
After installation you can see,it is available in Dash home
Click on the MySQL WorkBench icon and you will get its dashboard.
Just explore the MySQL workbench, now you can easily manage multiple MySQL database server from single point in graphical mode.