AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Mysql workbench linux3/19/2023 ![]() Also, you can add scripts under the SQL Scripts drop-down. You can use the schema privileges drop-down to add users and various user roles. Here you can see various buttons like Add Diagram, Add Table, Add View, Add Routine, and Add Groups. ![]() The data modeling window is something that looks like what is shown in the following screen shot. You can also add various fields to your database using its comprehensive table editor, which is very easy to use and offers tools to edit tables, columns, indexes, and various more. Data ModelingĪs the name suggests, it will help you create models of your database graphically and allow you to perform reverse and forward engineering between schema and live databases. You can see in the above screenshot that table named, LINUXHINT1, is created in the output pane. Don’t forget to select the default schema before executing any query. It means you can see the result immediately.įor example, let’s create a table named LINUXHINT1 and try to execute it. The output pane here gives you output to any query you run or execute. Here you can start creating and managing databases. The following window will appear with a tab named Query 1 on successful connection to the database. You can also check Save the password in keychain to remember it for future use. It will connect to the database named, localhost. Click on Databases and then Connect to Database, a new window will appear similar to the below screenshot, here you need to click Ok, and then, it will ask for a MySQL server password.Įnter your password and click Ok. This is the first module in MySQL workbench that enables database administrators to create and manage connections to database servers.įor example, let me show you how you can connect to localhost. For each of these, there is a separate tab present on the MySQL Workbench home screen. So, there are three modules in MySQL Workbench, SQL Development, Data Modeling, and Migration. Here you will be able to perform database admin tasks, right from creating a database to configuring and executing database servers. So, in this article, I am going to give a tour of MySQL Workbench and show you how to use it.Īfter installation, when you launch MySQL workbench for the first time, it somewhat looks like the following screenshot. It is a powerful tool that enables us to visualize modules for creating, executing, and optimizing several queries. Workbench makes the task easier for database admins by providing important tools to manage databases and users, creating databases, running SQL queries, setting up and configuring servers, and many more. MySQL Workbench is a cross-platform GUI client for MySQL database users and administrators.
0 Comments
Read More
Leave a Reply. |