MySQL + SQL · Lesson 1

Mysql Workbench

What is MySQL Workbench?

MySQL Workbench is the official free visual tool to design, manage and query MySQL databases without typing every command. Great for beginners who prefer a GUI.

What You Can Do

Connect to a MySQL server with a few clicks.
Create databases and tables visually.
Write and run SQL in a query editor with syntax highlighting.
Design ER diagrams (visual database models).
Import/export data and backups.

Getting Started

Download MySQL Workbench from dev.mysql.com.
Open it and click the + to add a connection (host: localhost, user: root).
Enter your password and connect.
Use the query tab to run SQL:

SELECT * FROM students;

Workbench vs phpMyAdmin

Workbench is a desktop app with ER-diagram design tools; phpMyAdmin runs in the browser and ships with XAMPP. Both manage MySQL — pick whichever you find comfortable.

Summary

MySQL Workbench is the official visual GUI for MySQL.
Create tables, run queries and design ER diagrams without the command line.