08 Nov MySQL Workbench Tutorial

Learn MySQL Workbench and its concepts. Workbench is a UI i.e. a graphical tool for working with MySQL Servers and Databases. MySQL is an open-source relational database management system. It is one of the most popular RDBMS, wherein records are stored in tables. We have covered the following lessons with live running examples. Let’s start with the first lesson.

MySQL Workbench – Video Tutorial

MySQL – Video Tutorial

MySQL Workbench Tutorial – Index

MySQL – Introduction and Installation

• Introduction to MySQL Workbench
• How to install MySQL Workbench on Windows 10/ 11

MySQL – New database and table

• How to create a new Database and Table in MySQL Workbench
• How to create a new schema in MySQL Workbench
• How to Drop a Schema in MySQL Workbench

MySQL – Export/ Import

• How to Export the Data in MySQL Workbench
• How to Import the Data in MySQL Workbench
• Export the Result to a CSV file

MySQL – Script

• Save the script to a file from the SQL Editor
• Open a script file in the SQL Editor

MySQL – Settings

• Limit the number of rows in MySQL Workbench
• Change the font of the SQL Editor
• Adjust the Panels of the MySQL Workbench
• Search the Table Data in MySQL Workbench
• Clear the output window in MySQL Workbench

MySQL – Users & Privileges

• Create a new user in MySQL Workbench
• Set admin roles and account limits for users in MySQL Workbench
• Reset the root password in MySQL Workbench