How to install MySQL 8.0.33 Server and Workbench latest version on Windows 11

hello guys welcome to Amit things in this video we will learn how to download and install MySQL on Windows we will install MySQL server shell as well as workbench with that we will also create a sample database let's start for that go to the web browser I am using Chrome you can use any web browser on Google type MySQL and press enter on passing enter you can see the official website is visible mysql.com click on it now the official website is visible click downloads now go below here and click on MySQL Community downloads now under MySQL Community downloads you need to click on MySQL installer for Windows here in the current version visible this is what we wanted and we want it for Windows so here it is okay we will go for the following 32-bit x86 remember this works for both 32-bit as well as 64-bit Windows operating system it is 428 MB go for the current version here it is and click download that's it now you just need to click on no thanks just start my download here now the download should begin download started 428 MB let's wait for few seconds the download completed here it is the MSA file double click on it to install minimize now the setup started here in we need to choose a setup type we will directly go to custom to understand what we are actually installing click next so here end we need to select the product we wanted server shell as well as workbench so click on bicycle servers click on a drop down again and here it is the current version 8.0.33 click on it to drag and here it is now I'll click on applications I'll click on workbench because you wanted workbench also it is a UI to create database and tables with mySQL click here and just drag it here it is just drag it now we have server workbench we want shell I'll click here click on the drop down again and here it is the shell also click on it we clicked on it and here it is we wanted server shell and workbench now click next now ready to download all of them click execute now we are downloading all three let's wait we have downloaded all three of them click next now ready to install click on execute now it will install one by one the installation is now complete you can see the status and click next now Now product configuration click next here in type and networking keep it as it is and click on next authentication Method Keep the default that is recommended use a strong password click next now we need to set the root password root password that means the admin password for MySQL we will set it we have used the following password you can use your password no problem and click next now Windows service keep it as it is and click on next server file permissions yes Grant full access no problem click next apply configuration just click on execute and one by one all the steps will occur and your bicycle will get installed completely click execute the configuration is successful click finish Now product configuration click on next installation is complete it will start MySQL workbench after setup and shell also no problem click finish now workbench also started okay now what you can do you can just click on the following connections to just log into your MySQL workbench enter the same password which we added for root click save password in Vault and click ok now we will log into our MySQL document you can use this UI to create database and tables we have a complete tutorial for this you can refer the link in the description minimize now what we'll do we will just set the path go to C drive click on it and it got installed under program files here in go below and search for MySQL here it is double click on it double click on the server click on the bin and just right click and and copy this path minimize go to start type environment variables remember click on edit the system environment variables only the following click open now go to Advanced section environment variables click on it after clicking guys go to system variables go below go to path and double click on it to open go below and then click on new and right click and paste the same path which we copied which is fine click ok and the last okay that's it now we will verify the installation go to start type CMD click on open to open the command prompt now guys type MySQL space hyphen iPhone version and press enter this shows that we successfully installed the current version 8.0.33 let us start the server MySQL hyphen u space root this is the user root space hyphen p press enter and add the password okay so we have a root user and a password enter the same password press enter and welcome to mySQL that means we successfully installed it it also got started no type show databases semicolon and press enter herein you can see we have the following default databases now let us quickly create a new database type the command create database let's say the database name we want is amidb semicolon press enter one row affected query okay that means we successfully created a new database now type the same command show databases semicolon and press enter here it is here it is amidb that means we successfully created a new database now if you want to create a new table and work on different operations refer the link in the description of this video we have a complete free tutorial for you thank you for watching the video

Channel: Amit Thinks

Views: 413,597

Keywords: MySQL 8, MySQL, install MySQL, install MySQL on Windows 11, MySQL 8.0.33, how to, amit thinks, 2023, studyopedia, mysql installation, windows, install mysql on windows 11 64 bit, Windows 11, amit diwan, install mysql on windows 11, mysql download and install windows 11, how to install mysql in windows 11, mysql 8, how to install mysql on windows 11, windows 11

Id: qBBXBZXKi0w

Length: 7min 50sec (470 seconds)

Published: Sun Apr 23 2023