Install and configure MySQL 8 and workbench on Windows Server 2022 | Install MySQL on Windows | 2024

hello guys in this video we will see how to download and install MySQL latest version that is MySQL 8.0.3 on Windows Server 2022 open any browser then go to mySQL official website that is myql.com click on downloads scroll down click on MySQL Community downloads then click on MySQL install for Windows click on it so select the version 8.37 or 5744 so we are going to install 8.0.3 select it then select the operating system Windows by default it has selected it then we have to select the myql installer Community 8.0.3 7 not the web Community okay so click on download then click on no thanks just start my download see download has been started and it size is 296 mbes wait until this download completes see MSI file downloaded click on the this downloaded file see here we have the see here we have to set select the setup type like server only client only or full full means it contains server client workbench and all okay so if you select only server it is going to install only MyQ Ser so I I don't I want to go uninstall all so so select the full then click on next see it is going to install these components then click on execute now click on next now we are going to configure myql server so click on next see Port number3 06 if you see this will be the name for the name pip okay I'm not going to change anything so click on next click on next provide the password for root account if you want add user you have to click on add user then here provide the user then we have to select the role from the list then we have to provide the password so I'm not going to create a this moment so click on cancel then click on next see this will be the name in the services okay okay so I'm not going to change it also also see here the checkbox start myql server at system startup okay whenever Windows Server restarted so myql server automatically starts if you check this one otherwise we have to start manually so I'm not I'm going to keep this as it is and click on next Grant full access then click on next see this is the configuration information so click on execute see everything is done so click on finish next product configuration so click on next so click on finish then provide the password check it done click on next click on execute to install the samples all done click on finish click on next see start myc workbench after setup then start my after setup I don't want MySQL shell so click on finish see this is the MySQL workbench let me Max see now click on this plus button to connect to mySQL click on this plus button from the so give the name MySQL 8 wi 2022 name can be anything then select the connection method then this is the host name you can give the Local Host also or give the IP of the mission if you want to find the IP of the mission CMD ip config see this is the IP okay so next Port number3 06 username root then provide the password by clicking on the store in Vault then provide the password click on okay now test connection is Success click on okay you want to select the default schema or the default database we have to provide here otherwise click on Okay click on connection see here we have the two TPS Administration and schemas click on schemas see this sakila and world are the sample databases you don't want you have to right click on you have to click on drop schema okay if you want to create database click on create schema then provide the name so I'm giving R to scools then click on save or apply again apply finish see new database of the schema is successfully added let me close this one okay now we will see how to connect to MyQ shell click on start see here we have the MySQL folder click on drop down then select the MySQL sh now give / SQL now show databases see we have the same databases like here okay so control L to clear screen now let us connect to a schools database or schema show tables see before we have the blank now database name is added here show tables see we don't have any tables let us create a table in this AR schools database create table student now verify tables show tables see one table is added let us insert some data into this table insert into insert one more row insert one more this time I'm giving s number as1 it will throw error see duplicate entry for primary key okay so we have to give in value or non-existing value of the table so we have the already 101 for the s number so we have to give one2 or any other number now select the data from this table select start from student see we got the same output see we have the three rows okay let us verify list of users show users see we don't have the command like show users but we can get the list of the users by running select control select user from MySQL do user this type of see we have the see these are the default users comes with mySQL installation also we can get those click on users and privileges see we got the same users if you want to add account or user click on add account then provide the name for the new user I'm giving James then select the authentication type standard limit host then provide the password for this user then click on apply it is done now click on users again see here we have the James user even if you go to the see new user James is added last step is go to downloads delete this downloaded MSI file to delete the space now we will see how to stop start and restart my schol service on Windows Server 2022 services. MSC press same see here we have the MySQL 80 see the service status is running and startup type is automatic select the service and see here we have the links for stop pass restart and if you right click we have the same options like stop pass restart and here we have the same stop service pass service and restart service okay if you want to stop click on this stop button if you want to again start it you have to right click on click on start or click on only start see it is stopped so we have only one option that is see these are grade out okay select any one of them so click on start button or if you want to restart select service and click on restart see first it is stopping now it is starting okay so in this video we have seen how to download and install MySQL 8037 and myql workbench on Windows Server 2022 for more videos please subscribe my channel thank you

Channel: r2schools

Views: 186

Keywords: Install MySQL 8.0.37 on Windows Server 2022, MySQL Install on Windows Server 2022, MySQL install in Windows Server 2022, MySQL installation on Windows Server 2022, MySQL Install on Windows 11, MySQL install in Windows 11, MySQL installation on Windows 11, MySQL Installation Tutorials, MySQL Tutorials, MySQL 8.0.37.2 Install on Windows 11, MySQL install Windows 11, MySQL install Windows Server 2022, MySQL install Windows Server, How to install MySQL Workbench on Windows Server

Id: xC21YGFqE2Y

Length: 10min 7sec (607 seconds)

Published: Fri May 31 2024