How to install and setup MySQL on Windows 10!
Here are the step-by-step instructions to install MySQL on Windows 10:
1.Download MySQL installer: Go to the official MySQL website at https://dev.mysql.com/downloads/mysql/ and download the MySQL installer for Windows
2.Run the installer: Double-click the downloaded installer file and click "Yes" if prompted to allow the app to make changes to your device.
3.Choose installation type: Select "Custom" installation type, as this allows you to choose the components you want to install.
4.Configure server options: In the "Installation" tab, choose the setup type. If you are installing MySQL for the first time, select "Server Only." If you want to upgrade your existing MySQL installation, select "Upgrade."
5.Set password: In the "Accounts and Roles" tab, set a password for the root account. This is the account that you will use to administer MySQL.
6.Choose data directory: In the "Data Directory" tab, select a location to store MySQL data files. You can leave the default location if you're not sure.
7.Complete installation: Click "Install" to start the installation process.
8.Finish installation: Once the installation is complete, click "Finish" to exit the installer.
9.Launch MySQL Workbench: After installation, launch MySQL Workbench to start using MySQL.