This guide introduces beginners to MySQL Workbench by walking through key steps such as setting up a connection, running queries, creating databases and tables, using the visual table designer, and managing data with built-in tools. 1. To set up a new connection, open MySQL Workbench, click the " " icon next to "MySQL Connections," fill in details like connection name, hostname, port, username, and enter the password when prompted. 2. To run your first query, type SELECT VERSION(); in the query editor and execute it using the lightning bolt icon or Ctrl Enter. 3. Create a test database and table using SQL commands like CREATE DATABASE and CREATE TABLE. 4. Use the visual table designer by right-clicking the database, selecting "Table Analyzer & Designer," clicking the "Create Table" button, adding columns, setting data types, and marking fields as PK, NN, or AI. 5. Manage data directly via built-in tools by right-clicking a table, choosing "Select Rows – Limit 1000," adding or editing rows in the grid, and saving changes with the disk icon.

If you're just getting started with MySQL and want to use MySQL Workbench, you’re in the right place. It’s a powerful visual tool that helps you manage databases, write queries, and design schemas without needing to rely solely on the command line. Whether you're a beginner or someone brushing up on SQL skills, this guide will walk you through the essentials using practical steps you’ll actually use.

Setting Up a New Connection

Before you can do anything useful in MySQL Workbench, you need to connect to a database instance. If you've installed MySQL locally, there's likely already a local instance running.

Here's how to set up a basic connection:

• Open MySQL Workbench.
• Click the " " icon next to "MySQL Connections."
• Fill in:
  • Connection Name: Something like "Local Instance"
  • Connection Method: Standard (TCP/IP) is fine for most setups
  • Hostname: 127.0.0.1 if it's local
  • Port: Usually 3306
  • Username: Often root, unless changed during install
• Enter your password when prompted (you may save it securely)

Once saved, double-click the connection to open a query tab. That’s all you need to start working — no more terminal commands required.

Running Your First Query

Now that you're connected, let’s try a simple query to make sure everything works. A good first step is checking the current version of MySQL you're using.

In the query editor window, type:

SELECT VERSION();

Click the lightning bolt icon (or press Ctrl Enter) to run it. You should see the MySQL version displayed in the result panel below.

From here, you can explore further. Try creating a test database and table:

CREATE DATABASE test_db;
USE test_db;

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(50),
    email VARCHAR(100)
);

After running these, look at the left sidebar under "SCHEMAS" — you should now see test_db listed with the users table inside.

Designing Tables Visually

One of the big benefits of MySQL Workbench is its visual table designer. Instead of writing every ALTER TABLE statement manually, you can drag and drop fields and define relationships graphically.

To create a table visually:

• Right-click your database (like test_db) and choose "Table Analyzer & Designer"
• Click the "Create Table" button (it looks like a small table icon)
• Add columns:
  • Set data types (e.g., VARCHAR(45), INT)
  • Check boxes for PK (primary key), NN (not null), AI (auto-increment)
• Once done, click "Apply" to generate and execute the SQL code

This method is especially helpful when designing complex tables or setting up foreign key constraints between tables. The visual interface makes it easier to understand how everything connects.

Managing Data with the Built-in Tools

You don’t always have to write INSERT, UPDATE, or DELETE statements manually. MySQL Workbench has built-in tools to edit table data directly.

To add data to your users table:

• Right-click the table and select "Select Rows – Limit 1000"
• At the bottom of the result grid, you’ll see an empty row — fill it in with a name and email
• Click the disk icon to save changes

You can also double-click any existing row to edit it directly. This feature is great for quick fixes or small data entries without writing full SQL scripts.

Just be careful not to modify large datasets this way — it's easy to accidentally change something important.

That’s the basic flow of working with MySQL Workbench. From connecting to your server, to building and editing tables both visually and with SQL, you’ve got a solid foundation to keep exploring. There’s more to learn — like reverse engineering databases or using the performance dashboard — but you don’t need all that right away.

The above is the detailed content of mysql tutorial using MySQL Workbench. For more information, please follow other related articles on the PHP Chinese website!