But the command-line interface is often not user-friendly (especially for newbies), and with large databases managing by command is often more difficult and less intuitive.
So in this article I will show you how to install the MySQL Workbench tool - this is a tool that helps us to visualize the management interface for operations with the MySQL database management system.
NOTE: 'When installing MySQL Workbench, the MySQL installation is integrated so you don't have to install it separately.'
+ Step 1: Download MySQL Workbench tool first.
You can access the following link here to download the installation file
Or you can go to the homepage here : (always the latest version and for multiple operating systems)
You can see here there are two options, I have underlined them so that you can distinguish, the first one is the web version.
In this article, I instruct to install on a personal computer so we will download the installed version below.
+ Step 2: After clicking the Download button, it will be redirected to the download page. You just need to scroll down and click on the words: No thanks, just start my download to download the installation file.
Step 3: After downloading the installation file, double-click the file to start the installation process.
Initially, before installing MySQL Workbench, the installer will install MySQL first. You tick the Custom => then click Next.
+ Step 4: Next, you choose the version of MySQL Server. I note that you should choose versions that are not too new (because it is usually stable, with few bugs). Here I choose version 8.0.15 - 64bit.
+ Step 5: Continue at this screen you choose the MySQL Workbench version. Here I also choose version 8.0.15 (corresponding to the version of MySQL Workbench).
Next you click Next to move to the next step.
In this step, you click Execute for the installer to download MySQL Workbench and MySQL Server.
As shown in the picture below, the download is complete. You click Next to move to the next step.
In this next step you continue to choose Next to go to the configuration section.
+ Step 6: The first is the network configuration and protocol, you just leave it by default and click Next.
Next is the right to default and click Next.
+ Step 7: The next step is quite important that you set up a password and admin rights. You follow the order as the photo you numbered below.
Note that the password you choose is so secure (it is installed on your personal device so I choose a short password for easy remembering. You should choose a long password for more security).
+ Step 8: The next step if you do NOT want MySQL Service to start with Windows, uncheck the line: Start MySQL Server at System Startup => and then click Next.
Next you click Excute to deploy the configuration just now.
OK, the configuration installation is complete will be as shown below.
Click Finish to complete the configuration and click Next.
Finally, click Finish to complete the installation and run the application
So in this article I have very detailed instructions with you how to install MySQL Server and MySQL Workbench on Windows 10 to work with the MySQL database management system already.