How to install MySQL Workbench | Windows 10
How to install MySQL Workbench
What is MySQL Workbench?
MySQL Workbench is a graphical user interface tool used for the working and
development of MySQL databases. It is developed and maintained by Oracle.
There are three types of MySQL Workbench available; the community edition, the
standard edition, and the enterprise edition. Workbench supports MySQL server
v5.6 and above and it is available for all the major platforms like Windows,
Linux, and Mac.
Prerequisite:
- Internet.
- Xampp.
You may also like:
How to download and install MySQL Workbench
How to install MySQL Workbench on windows 10
To download and install MySQL Workbench, follow the given instructions:
- Visit the official download page from here, and click on the download button.
- It will ask you to log in or sign up, simply skip it and click on the "No thanks, just start my download" link.
- Double-click on the downloaded file and follow the on-screen instruction. Do not change any of the default selections.
- At last click on the finish button to close the setup wizard.
How to setup Mysql Workbench on Windows 10
In order to set up MySQL Workbench and use it, follow the given instruction.
- First of all, open the XAMPP control panel and start the Apache server and MySQL (the server status must be turned green).
- Open the MySQL Workbench and click on the plus icon to create a connection.
- Give a name to the connection as well as a password and leave the rest as it is.
- Now double-click on the connection you just made and give the password and click the ok button (if connect warning comes then click on continue anyway, you can update it afterward).
- You will be taken to your dashboard where you can write your MySQL queries.
Note: If the workbench keeps on asking for the password again and again, then you have to fix this issue manually.
How to fix the workbench keeps on asking for the password again and again
This issue happens due to the phpMyAdmin config file. To solve this, follow the given instructions:
- Open the XAMPP folder.
- Now open the phpMyAdmin folder.
- Locate and open the "config.inc.php" file in any text editor.
- Search for this line ($cfg['Servers'][$i]['password'] = '';).
- Write the password in the blank space and save it.
- Restart all the applications, and it should work fine.
This is how you can download, install, and set up MySQL Workbench on Windows 10.
I hope this article was helpful to you.
Thank you.
Comments
Post a Comment