How to install and configure MySQL WORKBENCH in Ubuntu.

Installation of MySQL workbench -


MySQL Workbench is a feature-rich graphical tool used to model data, build SQL queries, manage MySQL servers, and more.

Image result for mysql workbench logo

  • Update your system repositories
      $ sudo apt update && sudo apt upgrade

  • Install MySQL Workbench using the APT package

      $ sudo apt install mysql-workbench
  • Run MySQL Workbench from the terminal
      mysql-workbench
  • It's open MySQL Workbench home
  • Click on local instance 3306:
  • Enter the password which you are given at the time of MySQL server installation:
  • It's open MySQL workbench dashboard where you can create, delete, manipulate, update table.

Comments

Post a Comment

Popular posts from this blog

Installation of MySQL server in Linux/Ubuntu

Image
Installation of MySQL server in Linux/Ubuntu by using the terminal. Open Terminal on your computer or  press(ctrl+alt+t). sudo apt-get dist-upgrade sudo apt-get install mysql-server It will install MySQL server. In between installation, it asks for the password of MySQL, you have to chose the password of the MySQL (root) and press enter. after the installation completion type -> mysql and press enter, it will start the MySQL server. 
Read more