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.
#Create a database workbench in mysql how to#
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 kommentar(er)
