Posts

Showing posts from March, 2018

How to install and configure MySQL WORKBENCH in Ubuntu.

Image
Installation of MySQL workbench - MySQL Workbench is a feature-rich graphical tool used to model data, build SQL queries, manage MySQL servers, and more. 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.

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.