What is MySQL Workbench?

Pradnyankur Nikam
A free video tutorial from Pradnyankur Nikam
Freelance Web developer and Instructor, 8000+ Happy Students
4.4 instructor rating • 2 courses • 9,443 students

Lecture description

MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more.

Learn more from the full course

SQL Tutorial: Learn SQL with MySQL Database -Beginner2Expert

Learn SQL and Database Development to work effectively in DBMS like MySQL, SQL Server, Oracle, PostgreSQL, DB2 etc.

10:45:40 of on-demand video • Updated April 2018

  • Understand the Database terminology and Structured Query Language fundamentals.
  • At the end of this course, You will be able to use SQL statements in any database management system.
  • You will learn from SQL basics to advanced topics like JOINS, Database Relationships, Database Normalization.
  • You will learn each topic step by step with practical examples.
  • You will learn the skills useful for professional Database Development (Database Modeling) and Database Management.
  • You will also learn about MySQL Workbench, a unified visual tool for database architects, developers, and Database Administrators.
English In section two of this course, while installing MySQL we also installed MySQL workbench tool. In this lecture we will learn about MySQL workbench. MySQL Workbench is a unified visual tool for database architects, developers, and Database Administrators. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more. MySQL Workbench is available for all major operating systems like Windows, Linux and Mac OS X. Lets learn about MySQL workbench with some practical examples. From my Windows 7 operating system, I'll go to 'start menu' -> 'all programs' -> 'mysql' -> and MySQL Workbench This is the default screen for MySQL Workbench tool. Lets first connect to our MySQL database server using 'root' username and password. In the to top menu select 'Database' -> 'connect to database' option. In connect to database popup window, in 'parameters' tab, Enter, Hostname. In host name you can use 'localhost' or the local IP address that is '127.0.0.1' If you installed MySQL on different port, make sure to enter the exact port number here. The default port number is 3306 In username type the username you want to connect. Here we are going to connect to MySQL database server using 'root' username. So I'll enter "root" username. Press 'OK' button and on next popup window enter the root user password. If you want, you can save the password, by checking this option. Click OK. to login to MySQL database server. Now, we are logged in, in my MySQL database server, and MySQL workbench displays default screen option. In the center of the screen, we have 2 windows. In The left window, we can directly write, edit, save or execute SQL statements. The SQL statements can Data definition or data manipulation language SQL statements. The right window provides help for SQL statements. You can select this option to read more about the particular topics as well as you can see the SQL syntax for the statement. The lower window displays all the actions performed on database management system. In left column window under Navigator. There are management and instance section from where, we can manage server status, add users, back up or restore databases. And under 'schemas', it displays all the existing databases. and finally in bottom left 'information' window we get a brief information about each selected object. In next lecture, we will see how to create new user and connect to database using MySQL workbench.