Connecting to MySQL Workbench

Download

To download mysql workbench visit  https://dev.mysql.com/downloads/workbench/  and select the operating system and click on Download

Connecting to the DB

• Open mySql workbench and click on Database and then select the Connect to Database option which will open this window

• now enter the hostname, port, username and password. For the password click on store in keychain and enter the password and click on OK
• when all the details are filled click on OK and now you will be connected to the database.
• here under table you can see all the tables in the database

• You can hover over any of the tables and select the table icon to fetch the data of that table.

• You can write the database queries in the editor section and press Cntl + Enter to execute the query