Download mysql in windows 11 and create sample database
Installing MySQL on Windows the link "https://www.mysql.com/"
In this tutorial, we are installing the latest version of MySQL (8.0.34) on Windows 11. Follow the given steps to do so −
Step 1: Firstly, choose the MySQL version and operating system. Then, we download the desired MSI installer on your system by clicking the 'Download' button This installer is suitable for both 32-bit and 64-bit systems.
Step 2: Then, we will be redirected to another file download page. Here, ignore the prompts asking to log in or sign up and directly start downloading
Step 3: Once the installer is downloaded, run it to start the MySQL installation.
Step 4: Now, we can see the installer community window, asking to choose a Setup type for our MySQL products. Choose Custom and click Next to decide what products we want to actually install.
Step 5: In the next step, select MySQL Server, MySQL Workbench, MySQL Shell (all latest versions) to be installed. We can also choose more products available as per necessity. Click Next.
Step 6: The installation process will now begin. However, path conflicts might arise if there exists a path directory with the same name. After the installation is done, click Next.
Step 7: In this step, we will be asked to set Type and Networking of MySQL. Unless there is any particular change we want to make, it is recommended to keep the settings as they are, and click Next.
Step 8: Then, we need to set the Authentication method to access MySQL root user. So, choose the strong password encryption method (as it is recommended) and click Next.
Step 9: Set a password for the root account. This password must always be used to log into the root account in every session. After setting password, click Next.
Step 10: In this step, MySQL Server Instance will be configured as a Windows Service. The default name will be set as "MySQL80", which can be changed if needed. Click Next.
Step 11: Now, set the file permissions as required and click Next.
Step 12: As shown in the image below, the specified configuration steps will be applied on clicking Execute.
step13:The installation is now complete. Uncheck the options asking to start MySQL Workbench and Shell after setup, so that they will not run after setup. Click Finish.