Home >Database >Mysql Tutorial >How to use MySQL Workbench?

How to use MySQL Workbench?

黄舟
黄舟Original
2017-08-11 14:34:144821browse

In today's society, the IT industry is becoming more and more popular. It is well known that both software and websites need to use databases to store data. The most commonly used database software in our daily life is MySQL Workbench. So how to use this software, let us explore and learn together.

How to use MySQL Workbench?

1. Double-click or right-click to open MySQL Workbench and enter the software main interface.

How to use MySQL Workbench?


##2. Click new connection, there will be A pop-up box asks us to fill in user (username) and password (password).

How to use MySQL Workbench?


##3. Fill in the username and password, Click OK and the database workspace we created will appear, for example: local instance MySQL56.

How to use MySQL Workbench?


##4. Double-click local instance MySQL56 to enter Database workspace.

How to use MySQL Workbench?


##5. Find a cylinder on the upper left Click the icon with a plus sign to display the database name for us to fill in. For example: baidu.

How to use MySQL Workbench?

How to use MySQL Workbench?


#6. After creating the database, we find the baidu database in the left menu bar, double-click the database, and you can see that there are tables below, Right-click the table and select create table to create the table.

How to use MySQL Workbench?

How to use MySQL Workbench? #

The above is the detailed content of How to use MySQL Workbench?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn