62. How to install and configure MySQL 8.0.36 on Amazon Linux 2023 EC2 |Install MySQL 8 on AWS Linux

hello guys in this video we will see how to install MySQL 8 on Amazon Linux 2023 E2 instance first we will create Amazon Linux 2023 E2 instance then we will install the MySQL on Amazon Linux 2023 then we will connect to mySQL which is installed on Amazon Linux so first connect to Amazon console so see I have connected to Amazon console then click on Services search for ec2 click on ec2 see I don't have any ec2 instances running at the moment Okay click on launch instance click on Amazon Linux then select the Amazon Linux 2023 Ami is freeti eligible okay so click on architecture that is 64bit x86 I'm not going to change then next instance type see we have different instance types so I'm going with T2 micro and it's and it is on CPU and 1 GB memory want more you can select from the list but charges will be there next key pair key pair is used to connect to Amazon Linux easy to instance so click on create see I I don't have any keyers so click on create new key provide the name I'm giving AWS Linux 2023 MySQL 8 copy this one I'm also going to give this as name for the Amazon Linux also see here we have to to select private key file format as F so click on create key pair once we see it has downloaded okay so here I want to give name also same okay next network settings see at present I don't have any network information so click on edit see I don't have VC or subnet okay Select Auto public IP to enable so click on refresh still we don't have so click on Services click on Services search for VPC right click on it open link in new tab go to the see I don't have any vpcs so click on create VPC see the region must be the same as this one okay see here it is Us East one here also it must be the same see us East one then select the VPC on mode I'm not going to change anything just click on create VPC see UPC has created go to here refresh here see there is only onec select it then submit refresh see we have four submits for different availability zones okay so I'm going with us one AR and public IP enable then Security Group see this is the default Security Group I want to create new security group so I'm not going to change anything remaining options I'm going to keep as it is then storage here I'm giving 30 GB see preti customers eligible up to get 30 GB EBC general purpose SSD then Advanced details select select host type as host name type as resource name then select this enable resource based ipu for DNS request if you are okay with all the settings click on launch instance see successfully initiated launch of instance wait still it is not started wait status it will be in running State see instance is running click on instance ID see this is the public IP this is the public IP for DNS name so click on connect click on SSH client then copy this one then open CMD on Windows or on Linux open Terminal but the process is same CMD go to where you have downloaded PM file then copy the string hit enter typey for confirmation and hit enter see we have successfully connected to Amazon Linux 2023 we can nfy more/ Etc OS hyph release see Amazon Linux it is of the ID like Fedora Okay so so control L to clear screen now we will see how to install MySQL 8 on this Amazon Linux 2023 easy to instance now go to myql.com click on downloads click on MySQL Community GPL downloads click on MySQL M repository copy this one right click copy the link address then go to the Shell W get paste it and hit enter we have to download this RPM so hit enter see it has successfully downloaded next we have to install this RPM so LS iph LR sudo dnf install then give this RPM hit enter paste it hit enter typey for confirmation and hit enter we have successfully installed now we will install the MySQL server by running the command control L to clear screen sudo dnf install MySQL hyphen Community hyphen server then hit enter see install size is this one total download size is this one type five for confirmation and hit enter Y and hit enter we have successfully installed MySQL 8.0 36 on Amazon Linux 2023 is2 instance contrl L to clear screen now check the status of MySQL service sudo system CTL status MySQL D see MySQL servic is not started okay so we have to start it sudo system CTL start MySQL D I verify see MyQ Services active and running it is started 3 seconds ago also see here service is enabled no need to enable the service manually control L to clear screen I will keep this link in the video description okay you can download the respective RPM okay now connect to my SQL Server now we can get the temporary password C where log MySQL grip for password give the sudo see here we have the temporary password this is the temporary password okay let me copy now connect to my SQL Server sudo I will keep this command in the video description MySQL hyph new root hyph P hit enter paste the password hit enter see we have successfully connected to mySQL server now see this is the temporary password so first step is we have to change the password alter user alter user root single codes Local Host ident identified by then provide new password hit enter see we have successfully changed the password let me exit connect again with new password see I have successfully connected so toy control L to clear screen to verify list of databases comes with SQL installation for databases see these are the databases comes with MyQ installation you want to verify the version select version is the command to check the version of the MySQL server see I have installed MySQL 8.0.3 okay until now we have installed MySQL on Amazon Linux then we have connected to it from the Linux terminal we have successfully installed and connected to mySQL 8 on Amazon Linux 2023 ec2 instance for more MySQL and AWS videos please subscribe my Channel thank you

Channel: r2schools

Views: 385

Keywords: how to install MySQL 8 in AWS EC2 Instance, how to Install MySQL 8 for AWS EC2, install MySQL 8 in windows step by step, how to install MySQL 8 in AWS Linux EC2, MySQL 8 installation on AWS EC2 Linux 2023 Instance, MySQL 8 Tutorials, MySQL 8 Video Tutorials, MySQL 8 Install for AWS EC2 Instance, MySQL 8 installation AWS Linux EC2, install MySQL 8 on AWS EC2 Instance, MySQL 8 Complete Tutorials for beginners, MySQL 8 Tutorials for beginner, Install MySQL 8 on AWS Linux 2023 Instance

Id: XTcpwAgFKf4

Length: 9min 0sec (540 seconds)

Published: Mon Apr 15 2024