How to Install MySQL Server and Client on Windows

How to install MySQL 8.0.27 on Windows. How to install latest version of MySQL server and Workbench. How to add MySQL to the system environment variables.
*************************************************************

************************* SQL Queries ***********************
show databases;
CREATE DATABASE mystore2022;
USE mystore2022;
SHOW TABLES;
CREATE TABLE IF NOT EXISTS users (id INT( 10 ) NOT NULL PRIMARY KEY AUTO_INCREMENT, name VARCHAR(200) NOT NULL, email VARCHAR(200) NOT NULL UNIQUE, phone VARCHAR(200), address VARCHAR(200), password VARCHAR(200) NOT NULL);

DESCRIBE users;

SHOW TABLES;

SELECT * form users; .

***********************************

🔥 *Complete Udemy Courses* :

⬇️ *Free Document Proofreading* ⬇️

[rikathashmi]

I can't see the list of available data bases

[rickyu]

thanks, is there a simlpe client that we can use to connect to a remote database?

[iichika]

My "starting the server" Check list failed, what should i do?

[Expert_Transcript_Helpers]

When I did the execute stuff
It said Microsoft visual c++ 2019 redistributable package (x64) is not imstalled. Latest binary compatible version will be installed if agreed
Please what do I do?