Many database administrators are comfortable working inside the control line. To them, information technology's equally efficient as a work surroundings can be. To others, however, the command line is besides cumbersome to be efficient. Fortunately, for those users, at that place are plenty of GUIs available to make the chore easier. One such GUI is MySQL Workbench. This particular tool is one of the finest locally installed MySQL client tools yous'll find. Information technology's cross-platform, open source, and incredibly easy to utilize.

I'm going to testify you only how piece of cake information technology is to make use of MySQL Workbench. To practice so, I'll walk you through the process of creating a database, calculation a table to that database, and then adding data to the table.

Meet: Server deployment/migration checklist (Tech Pro Inquiry)

What you need

I'll employ MySQL Working half dozen.3, which has drastically evolved from older versions of the tool. My instance of MySQL Workbench volition connect to a MySQL database, housed on Ubuntu Server 18.04. Yous need to make sure you have MySQL ready for remote connections (See: How to set up MySQL for remote access on Ubuntu Server sixteen.04 (This too works for Ubuntu 18.04).

I volition assume you already have MySQL Workbench installed.

Creating a database

The first thing to do is create a database (aka Schema). Open MySQL Workbench and connect to your database server. From the database home screen (Effigy A), right-click a blank spot under the SCHEMAS pane and select Create Schema.

Effigy A

In the resulting window (Effigy B), give the schema (database) a name and (if necessary) select a Default Collation.

Effigy B

Once y'all proper noun your schema, click the Apply push button and, when prompted, review the SQL Script and click Apply once again. Once the schema is created, shut the SQL Script window. You lot're ready to create a table.

Creating a table

I've created a database called SERVERS, that volition exist listed in the SCHEMAS pane. Expand that listing, correct-click the Tables entry, and select Create Table. In the new window (Figure C), name the table.

Figure C

Double-click under Column Name, and you should be able to type the name of the starting time cavalcade. Once you lot exercise that, you lot can and so select the Datatype for the column (Effigy D).

Figure D

Keep adding columns until your table is consummate. Click Apply to execute the SQL Script. Your table is now ready for data.

Calculation information to a table

Information technology's now time to populate that tabular array with some information. This is where it gets tricky. In previous incarnations of MySQL Workbench, a button could be establish on the home screen that took you directly to the tabular array data entry department. That is no more. In order to offset adding data to a table, right-click the table (in the SCHEMAS pane) to exist modified and click Select Rows. You will then find yourself in a window that allows yous to enter information (Figure East).

Figure East

In this window, you can either use the result grid or open the grade editor. For the fastest route to success, use the outcome filigree (which is the default). Double-click the offset entry in one of your columns and type the data to exist added. After entering the necessary information, hit Enter on your keyboard. Double-click under that newly created row and create another. Once you add all of your data, click Employ to execute the SQL Script.

The form editor is just as piece of cake to use; y'all only need to remember to click the Next Entry button (single right-pointing arrow) to movement to the side by side data row (Effigy F), earlier entering new data.

Figure F

Your database is fix

Congratulations, you successfully created a database, added a table, and entered data into the table. Your database is prepare to use.