Many database administrators feel comfortable working from the command line. For them, it’s as efficient as a work environment can be. For others, however, the command line is too complicated to be efficient. Fortunately, for these users, there are many GUIs available to make the task easier. One such GUI is MySQL Workbench. This particular tool is one of the best locally installed MySQL client tools you’ll find. It’s multiplatform, open source and incredibly easy to use.
I will show you how easy it is to use MySQL Workbench. To do this, I will walk you through the process of creating a database, adding a table to that database, and then adding data to the table.
What do you need
I will use MySQL Working 6.3, which has evolved dramatically from older versions of the tool. My instance of MySQL Workbench will connect to a MySQL database hosted on Ubuntu Server 18.04. You must have MySQL configured for remote connections.
You assumed you already have MySQL Workbench installed.
Creating a database
The first thing to do is create a database (also known as a schema). Open MySQL Workbench and connect to your database server. On the database home screen (Figure A), right-click a blank space in the SCHEMES panel and select Create Schema.