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

  1. Download MySQL Workbench from dev.mysql.com.
  2. Open it and click the + to add a connection (host: localhost, user: root).
  3. Enter your password and connect.
  4. 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.
🔗

Share this topic with a friend

यह topic किसी दोस्त को भेजें

Found it useful? Send it to a classmate learning the same thing.

अच्छा लगा? जो दोस्त यही सीख रहा है, उसे भेज दीजिए।

\n

💻 Live Code Editor

Is page ki language (MYSQL) mein code likhein aur turant chalाएं — yahीं, bina kuch install kiye.
Powered by OneCompiler. Agar editor na khule to yahान naye tab mein kholein.

💻 Live Code Editor

Is page ke program yahan ready hain — chalाएं, badlें aur seekhें. Bina kuch install kiye.
Powered by OneCompiler. Editor mein code apne aap aa jata hai — Run dabaakर output dekhें. Agar load na ho to naye tab mein kholें.