How to Install MySQL Workbench CE for MySQL Administration

MySQL Workbench is a comprehensive DBAs tools for server configuration, user administration, backup, viewing database health and more. MySQL Workbench is available on Windows, Linux and Mac OS X. It’s very simple to setup, run, schedule and view running backups. MySQL Workbench has the following features that makes MySQL administration easy.

  1. User administration
  2. Server configuration
  3. Database backup and restorations
  4. MySQL Server logs

In this article, we will install MySQL Workbench in Windows 10 System. 

Let’s start the installation, once download is complete.
Step 1: After clicking on .exe Setup Wizard will started.

Step 2: Choose a installation location and click on Next.

Step 2: Setup Type. Choose complete, this will require more disk space.

Step 3: Ready for installation. Click to Install.

Step 4: Installing MySQL Workbench.

Step 5: Installation is complete. 

Step 6: Lunch MySQL Workbench. Click on MySQL connections to create a connection and fill up the details and change the details i.e IP, Hostname and Password which you have set during installation. Test the connection and click on OK.

Step 7: You may encountered the below error message. Do the following steps shown in Step 8.

Step 8: As per above error, root is unable to connect to MySQL database. We need to grant access as per below screen print.
mysql> select Host, user from mysql.user;
mysql> UPDATE mysql. user SET Host=’%’ WHERE Host=’localhost’ AND User=’root’; 

mysql> FLUSH PRIVILEGES;

Step 9After connection strings is set, click on below string which display Dashboard. 

Step 10: Below screen is the MySQL Workbench Dashboard from where you can perform DBAs tasks.

Conclusion: In this tutorial, we have seen installation steps of MySQL Workbench. Big thanks for reading all the way to the end. Please share it with Your Friends & Help Someone… and also Like Our Facebook Page. Let me hear your thoughts in the comments below!

Leave a Comment